small code to write a cell array to excel file

Version 1.0.0.0 (519 Bytes) by Rini
write a cell array to an excel file
131 Downloads
Updated 19 Jan 2015

View License

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!

Cite As

Rini (2026). small code to write a cell array to excel file (https://in.mathworks.com/matlabcentral/fileexchange/49079-small-code-to-write-a-cell-array-to-excel-file), MATLAB Central File Exchange. Retrieved .

MATLAB Release Compatibility
Created with R2014a
Compatible with any release
Platform Compatibility
Windows macOS Linux
Tags Add Tags
Version Published Release Notes
1.0.0.0