small code to write a cell array to excel file

バージョン 1.0.0.0 (519 Bytes) 作成者: Rini
write a cell array to an excel file
ダウンロード: 131
更新 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 (2026). small code to write a cell array to excel file (https://jp.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 Center および MATLAB AnswersSpreadsheets についてさらに検索
タグ タグを追加
バージョン 公開済み リリース ノート
1.0.0.0