Exports any type of MATLAB data to a nicely formated csv-file, including fieldnames of structs and any multidimensional subscript-indices.
This tool is especially useful if you want to save the content of large structs and cell-arrays to an excel or ods sheet. Any to csv works recursively until all the content of a complicated object is written to a csv-spreadsheet and opens it in the standard csv application. There you can save it to e.g. xls or ods.
This does not work with a structure that has nested field names.
MATLAB 2012a, <1305983x3 cell>, sucked all my RAM, I ended up using http://www.mathworks.com/matlabcentral/fileexchange/7601-cell2csv instead
Thanks, very useful
Could you please have a look at this thread?
I am out of memory in 2009b. What could be a reason for that?
very useful !!
but I find the opening of excel annoying
I also got a (little) problem when creating the file, it says :
The system cannot find the file ''pathname''
normal it does not found... has not been created yet....
Very usefull work ( see comment from Steffen).
This is a great way to manage the workflow of your data from Matlab to any office-programm like excel or openoffice. It's handy and easy to use.
I am using OpenOffice.org instead of Microsoft Office. OpenOffice.org has a very nice import function for csv files. Once the file is imported you can save as XLS. I know that those functions are available via command-line tools, however I do not remember the names and I have never used them.
Do you know of a way to convert from CSV to XLS quickly?
Shame on me, I should have tested that case... Thanks Urs, I corrected the bug. Felix
does NOT work with empty cell entries, eg,
- display struct fields horizontally or vertically -> line 128
Thanks Jiro Doke for those two ideas!
- removed empty struct bug
The empty cell bug is now finally gone.
Download apps, toolboxes, and other File Exchange content using Add-On Explorer in MATLAB.