small code to write a cell array to excel file
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!
Citation pour cette source
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. Récupéré le .
Compatibilité avec les versions de MATLAB
Plateformes compatibles
Windows macOS LinuxCatégories
Tags
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!Découvrir Live Editor
Créez des scripts avec du code, des résultats et du texte formaté dans un même document exécutable.
Version | Publié le | Notes de version | |
---|---|---|---|
1.0.0.0 |