MATLAB Central Newsreader - Problems with export function

Problems with export function

magic_ggg@hotmail.com — Mon, 27 Oct 2008 12:18:58 -0400

Hello,

I want to export the data as xls file. But when I do so, an error has
occured. Here is the command I typed:

[phi,psi,xval] = wavefun('Haar', 8);
xlswrite('sample.xls', xval)

It said that I cannot save the data because the excel does not support
more than 256 rows and 65536 columns.. what should I do?

I am so frustrated because this is the first step of my project.

Re: Problems with export function

Fangjun Jiang — Mon, 27 Oct 2008 12:28:01 -0400

That is the limitation of the Office. We can do nothing about it unless Microsoft does something. What is the reason that you want to export such a huge matrix into a spread sheet? It won't fit for human eyes. If you can explain the reason, there might be other solution for it.

magic_ggg@hotmail.com wrote in message <278bed73-75f8-4147-a8e8-9f2039c2b3e8@n33g2000pri.googlegroups.com>...
> Hello,
>
> I want to export the data as xls file. But when I do so, an error has
> occured. Here is the command I typed:
>
> [phi,psi,xval] = wavefun('Haar', 8);
> xlswrite('sample.xls', xval)
>
> It said that I cannot save the data because the excel does not support
> more than 256 rows and 65536 columns.. what should I do?
>
> I am so frustrated because this is the first step of my project.

Re: Problems with export function

Confusing — Mon, 27 Oct 2008 12:48:54 -0400

Because my project is related to network traffic, I need to generate some waves and then put it into R/S filter to analyze.

All I need to do is :

(1) generate waves in matlab
(2) save the data and then put it into R/S filter

Re: Problems with export function

Ashish Uthama — Mon, 27 Oct 2008 13:04:20 -0400

Try
xlswrite('sample.xls', xval')
to get around the 256 columns issue.

Or you could break the data into segments lesses than 256.

As "Fangjun Jiang" <f@j.com> mentioned, if you elaborate on why you need
to do this, someone might suggest alternatives which would get the same
work done.

On Mon, 27 Oct 2008 08:18:58 -0400, <magic_ggg@hotmail.com> wrote:

> Hello,
>
> I want to export the data as xls file. But when I do so, an error has
> occured. Here is the command I typed:
>
> [phi,psi,xval] = wavefun('Haar', 8);
> xlswrite('sample.xls', xval)
>
> It said that I cannot save the data because the excel does not support
> more than 256 rows and 65536 columns.. what should I do?
>
> I am so frustrated because this is the first step of my project.
>

Re: Problems with export function

Confusing — Mon, 27 Oct 2008 15:09:11 -0400

how to use xlswrite to get around the 256 column issue?
how to break down the data segments in matlab?

thanks!

Re: Problems with export function

Walter Roberson — Mon, 27 Oct 2008 15:56:13 -0400

Confusing wrote:
> how to use xlswrite to get around the 256 column issue?

You cannot.

http://office.microsoft.com/en-us/excel/HA101375451033.aspx

  A Microsoft Office Excel worksheet contains 65,536 rows and 256 columns.
  You cannot increase the number of rows or columns beyond the maximum row and column limits.

http://support.microsoft.com/kb/264626

  MORE INFORMATION
  You cannot exceed the maximum limits of features in Excel. For example, you cannot
  increase the number of worksheet rows beyond 65,536.

http://support.microsoft.com/kb/120596/en-us

  In Microsoft Excel 97 for Windows, Microsoft Excel 2000, Microsoft Excel 2002,
  and Microsoft Office Excel 2003, text files that contain more than 65,536 rows
  cannot be opened in their entirety. You cannot open these files because these versions
  of Microsoft Excel are limited to 65,536 rows.

  Notes

  Versions of Excel earlier than Excel 97 have a limit of 16,384 rows.

  Versions of Excel later than Excel 2003 have a limit of 1,048,576 rows.

"Versions of Excel later than Excel 2003" includes only "Excel 2007" at the present
time. And Matlab's xlswrite() has not caught up to Excel 2007 format in your version.

> how to break down the data segments in matlab?

Do you really need binary Excel format? Or do you just need comma delimited format?
If you just need a comman delimited format, use dlmwrite()