Writetable does not allow me to have more than 32 columns in my table!

I am trying to export an Excel table using writetable commend, but it gives me this error:

Error using writetable (line 117)
The data block starting at cell 'A1' exceeds the sheet boundaries by 0 row(s) and 32 column(s).

Do you have any ideas how to fix this? Thanks :)

[Guillaume]

Using what code? Can you attach a demo table that shows the problem?

[Milad Zarei]

   Tab1 = randn(101, 288);
   writetable(Tab1,filename,'sheet',1,'Range','A1')

[Walter Roberson]

>> filename = 'test.xlsx';
>> Tab1 = randn(101, 288);
   writetable(Tab1,filename,'sheet',1,'Range','A1')
Undefined function 'write' for input arguments of type 'double'.
Error in writetable (line 124)
write(a,filename,varargin{:}) 
>> Tab1 = table(Tab1)
Tab1 =
  101×1 table
         Tab1     
    ______________
    [1x288 double]
    [1x288 double]
    ...
>> writetable(Tab1,filename,'sheet',1,'Range','A1')
>>

This suggests that your test case is not an accurate reflection of your actual usage.

[Walter Roberson]

What extension are you using for the file name?

Answer 1

[Fangjun Jiang]

You may have a quite old version of Microsoft Office, in which the Excel has a limit of 256 columns. Try some data with less number of columns to see if the error message still exists.

[Milad Zarei]

That is right. I noticed that it would work with less than 256 columns. But I sill can't create a table with 288 columns!

[Image Analyst]

So simply upgrade your Excel. Can't you do that? If not, write to a csv file instead.

[Fangjun Jiang]

Excel 2007 already has a column limit of 16384. Make sure you don't set the save option as "save to 97-2003 XLS format". Follow menu

File, Options, Save