Help using xlswrite function
1 view (last 30 days)
Show older comments
Hi everyone,
so i want so save a cell in an excel sheet.
My cell is a 2 x 9 cell and it looks something like this:
Row 1: {'Network No'} {'xx'} {'xx'}
Row 2: {[20]} {[10]} {[30]}
But when i use xlswrite i get the following error:
Error using xlswrite (line 194) An error occurred on data export in CSV format.
Caused by: Error using dlmwrite (line 104) The input cell array cannot be converted to a matrix.
Do you have any idea what i have to change in my cell so that it becomes convertable?
Thank you!
2 Comments
Guillaume
on 11 Sep 2018
An error occurred on data export in CSV format
i want so save a cell in an excel sheet
Clearly, from the error you're attempting to save a csv file, not an excel file. What you probably need to change is your xlswrite line. Without seeing the code it's difficult to say.
Also, it looks like your data would be better stored in a table rather than a cell array. It's also easier to save tables to CSV or excel files.
Answers (0)
See Also
Categories
Find more on Spreadsheets in Help Center and File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!