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 リリースの互換性
プラットフォームの互換性
Windows macOS Linuxカテゴリ
タグ
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!バージョン | 公開済み | リリース ノート | |
---|---|---|---|
1.0.0.0 |