small code to write a cell array to excel file

版本 1.0.0.0 (519 字节) 作者: Rini
write a cell array to an excel file
131.0 次下载
更新时间 2015/1/19

查看许可证

Hello,
I tried to write a huge cell array with variable number of elements in each cell to excel sheet with xlswrite (filename,matrix) but the sheet was empty. So I tried a small piece of code to write a cell array to excel file. The code searches for the cell that has the maximum number of elements (say N) and appends ones (N-number of elements in cell,1) to each cell. I used ones, it can be something else. Once the sheet is written, I do a ctrl+F to remove the ones from the sheet.
This code saved me a lot of time to copy each cell content from matrix to excel sheet.
Can someone please tell me if there is a better way to write an cell array to excel?
Thanks!

引用格式

Rini (2024). small code to write a cell array to excel file (https://www.mathworks.com/matlabcentral/fileexchange/49079-small-code-to-write-a-cell-array-to-excel-file), MATLAB Central File Exchange. 检索来源 .

MATLAB 版本兼容性
创建方式 R2014a
兼容任何版本
平台兼容性
Windows macOS Linux
类别
Help CenterMATLAB Answers 中查找有关 Spreadsheets 的更多信息
标签 添加标签

Community Treasure Hunt

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

Start Hunting!
版本 已发布 发行说明
1.0.0.0