필터 지우기
필터 지우기

Export cell array into Excel, with each column in a separate Excel Sheet

조회 수: 1 (최근 30일)
Jose Rubio
Jose Rubio 2022년 5월 31일
편집: Jose Rubio 2022년 5월 31일
I have a 87x46 cell array called "ExpSimple". Within this cell array, the size of each cell is: 1 row by k columns, where k changes (as you can see in the attached screenshot).
I would like to export this cell array in Excel in the following manner:
Each Excel sheet must have one column of the array "ExpSimple". Hence, the Excel file must have 46 sheets. Then, within each Excel sheet, the rows must have the content of each cell. At the end, each of the 46 Excel sheets will have 87 rows. How can I do this? Note that some columns are empty (for example, row 8 column 10). Also, the cell data is text or strings, not numerical values. I'm using Matlab version R2017b
Thanks,
JJ

답변 (0개)

카테고리

Help CenterFile Exchange에서 Spreadsheets에 대해 자세히 알아보기

제품


릴리스

R2017b

Community Treasure Hunt

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

Start Hunting!

Translated by