Help using xlswrite function

2 Ansichten (letzte 30 Tage)
Julian
Julian am 11 Sep. 2018
Bearbeitet: Julian am 11 Sep. 2018
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 Kommentare
Guillaume
Guillaume am 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.
Julian
Julian am 11 Sep. 2018
Bearbeitet: Julian am 11 Sep. 2018
Hi,
i don't know why it wants to save a csv, maybe because i'm using Linux and there is no Excel installed?
I made a table as you advised and it worked exactly as I wanted, thank you very much!

Melden Sie sich an, um zu kommentieren.

Antworten (0)

Tags

Produkte


Version

R2018a

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by