fprintf a cell array

I have a cell array with columns of different lengths.
I want to fprintf each column into different columns in excel.
Please help thanks.

6 Kommentare

Simon Chan
Simon Chan am 18 Jul. 2021
Did you try to use function writecell?
HYZ
HYZ am 18 Jul. 2021
I got this error. 'The data block starting at cell 'A1' exceeds the sheet boundaries by 0 row(s) and 45670 column(s).'
Simon Chan
Simon Chan am 18 Jul. 2021
Check This link
Walter Roberson
Walter Roberson am 18 Jul. 2021
Simon is correct: xls and xlsx files do not permit that many columns.
HYZ
HYZ am 18 Jul. 2021
Mine is Microsoft office 2013. still does not work
Walter Roberson
Walter Roberson am 18 Jul. 2021
Referring to the official Microsoft documentation:
Total number of rows and columns on a worksheet
1,048,576 rows by 16,384 columns

Melden Sie sich an, um zu kommentieren.

Antworten (0)

Gefragt:

HYZ
am 18 Jul. 2021

Kommentiert:

am 18 Jul. 2021

Community Treasure Hunt

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

Start Hunting!

Translated by