How can I write complex double cell to excel?

Hello. I have 80*100000 complex double that I put them in 20*1 cell (every 4 rows and 100000 colomns).

I want to save this cells in excel file. I wrote the below code:

Q = rand(80*100000);
Q_1 = mat2cell(Q,4*ones(1,20),100000);
writecell(Q_1,'ExampleMatlab.xlsx');

but I recieve this error:

"Error using writecell (line 195)

The data block starting at cell 'A1' exceeds the sheet boundaries by 0 row(s) and 383616 column(s). "

How can I fix it?

Answer 1

[Ayush Modi]

Hi Majid,

I found a similar question in the community. As @Walter Roberson said, this error is caused due to the limitation on number of columns that are permitted to be written in Excel. Please see the below link -

https://www.mathworks.com/matlabcentral/answers/354894-using-writetable-for-a-very-large-file

[majid]

thanks.