writatable row size limitation

4 次查看（过去 30 天）
kubra
kubra 2024-9-5
编辑： dpb 2024-9-5
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?
  2 个评论
ScottB
ScottB 2024-9-5
Is that a limitation of writetable? The limits for excel are 1,048,576 rows by 16,384 columns.
Walter Roberson
Walter Roberson 2024-9-5
@ScottB
xlsx limit is 1048576 rows, but xls limit is 65535 rows.

请先登录，再进行评论。

请先登录，再回答此问题。

采纳的回答

dpb
dpb 2024-9-5
编辑：dpb 2024-9-5
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.
  1 个评论
kubra
kubra 2024-9-5
thank you very much, changing the file extension from .xls to .xlsx helped!

请先登录，再进行评论。

更多回答（0 个）

类别

在 Help Center 和 File Exchange 中查找有关 Data Import from MATLAB 的更多信息

标签

产品


版本

R2017b

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by