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?
2 个评论
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
2024-9-5
xlsx limit is 1048576 rows, but xls limit is 65535 rows.
采纳的回答
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.
更多回答（0 个）
类别
在 帮助中心 和 File Exchange 中查找有关 Text Data Preparation 的更多信息
Translated by 
