Borrar filtros
Borrar filtros

How can I write complex double cell to excel?

8 visualizaciones (últimos 30 días)
majid
majid el 15 de Abr. de 2024
Comentada: majid el 15 de Abr. de 2024
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?

Respuesta aceptada

Ayush Modi
Ayush Modi el 15 de Abr. de 2024
Editada: Ayush Modi el 15 de Abr. de 2024
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 -

Más respuestas (0)

Community Treasure Hunt

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

Start Hunting!

Translated by