Writematrix error exceeds sheet boundaries error

29 次查看（过去 30 天）
Andrew Trafford
Andrew Trafford 2020-10-29
评论： Andrew Trafford 2020-11-1
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 个评论
显示 4更早的评论
Andrew Trafford
Andrew Trafford 2020-11-1
Fantastic, thank you. Hadn't mentally made the link between office versions and 'xls' to 'xlsx'...rookie!

请先登录，再进行评论。

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

采纳的回答

Mathieu NOE
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 个）

类别

在 Help Center 和 File Exchange 中查找有关 Spreadsheets 的更多信息

标签

产品


版本

R2020a

Community Treasure Hunt

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

Start Hunting!

Translated by