Writematrix error exceeds sheet boundaries error
显示 更早的评论
Hello,
Iis there any way to use writematrix (r2020a; excel 16 Mac or 2010 WIN) to write more than 2^16 rows of data (2 cols). Excel help says it can take 2^20 rows but writematrix throws error message if matrix > 2^16 rows.
Thanks,
Andy
6 个评论
Andrew Trafford
2020-10-29
Andrew Trafford
2020-10-29
Andrew Trafford
2020-10-29
Mathieu NOE
2020-10-30
hi
I notice you're trying to save in older xls format which is limited to 2^16 = 65536 rows
could you try with xlsx format (the limit should be 2^20 rows)
Walter Roberson
2020-10-30
Good point, Mathieu.
Andrew Trafford
2020-11-1
采纳的回答
Mathieu NOE
2020-10-30
hi again
the proof is here
you're trying to save in older xls format which is limited to 2^16 = 65536 rows
try with xlsx format (the limit should be 2^20 rows)
>> A = rand(2^17,2);
>> writematrix(A, 'test.xls','Sheet', 1, 'Range','A1');
Error using writematrix (line 175)
The data block starting at cell 'A1' exceeds the sheet boundaries by 65536 row(s) and 0 column(s).
>> writematrix(A, 'test.xlsx','Sheet', 1, 'Range','A1');
>>
更多回答（0 个）
类别
在 帮助中心 和 File Exchange 中查找有关 Spreadsheets 的更多信息
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!
Translated by 
