writatable row size limitation

Hello,

I have a matrix, it is 86405x16 table, I am trying to save that table in a excel spread sheet by using writetable command but it exceeds the sheet boundariest by 20870 rows. Can anybody help me how to save that table in a xls file?

[ScottB]

Is that a limitation of writetable? The limits for excel are 1,048,576 rows by 16,384 columns.

[Walter Roberson]

@ScottB

xlsx limit is 1048576 rows, but xls limit is 65535 rows.

Answer 1

[dpb]

Write to '.xlsx' file instead of '.xls'

>> tX=array2table(rand(86405,16));
>> size(tX)
ans =
       86405          16
>> writetable(tX,'BigTable.xlsx')
>> winopen('BigTable.xlsx')

works as expected, but

>> writetable(tX,'BigTable.xls')
The data block starting at cell 'A1' exceeds the sheet boundaries by 20870 row(s) and 0 column(s). 
>> 

The .xls format is limited to 65535 rows.

[kubra]

thank you very much, changing the file extension from .xls to .xlsx helped!