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

Simon Chan
Simon Chan 2021년 7월 18일
Did you try to use function writecell?
HYZ
HYZ 2021년 7월 18일
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 2021년 7월 18일
Check This link
Walter Roberson
Walter Roberson 2021년 7월 18일
Simon is correct: xls and xlsx files do not permit that many columns.
HYZ
HYZ 2021년 7월 18일
Mine is Microsoft office 2013. still does not work
Walter Roberson
Walter Roberson 2021년 7월 18일
Referring to the official Microsoft documentation:
Total number of rows and columns on a worksheet
1,048,576 rows by 16,384 columns

댓글을 달려면 로그인하십시오.

답변 (0개)

카테고리

질문:

HYZ
2021년 7월 18일

댓글:

2021년 7월 18일

Community Treasure Hunt

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

Start Hunting!

Translated by