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

[Andrew Trafford]

writematrix(app.ba', 'test.xls','Sheet', 1, 'Range','A1');

[Andrew Trafford]

app.ba' dimensions are 78132*2 double

[Andrew Trafford]

Error using writematrix (line 156)

The data block starting at cell 'A1' exceeds the sheet boundaries by 12596

row(s) and 0 column(s).

[Mathieu NOE]

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]

Good point, Mathieu.

[Andrew Trafford]

Fantastic, thank you. Hadn't mentally made the link between office versions and 'xls' to 'xlsx'...rookie!

Answer 1

[Mathieu NOE]

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');
>>