Clear Filters
Clear Filters

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

1 view (last 30 days)
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

Answers (0)

Products


Release

R2017b

Community Treasure Hunt

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

Start Hunting!