Help using xlswrite function

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)

Produkte

Version

R2018a

Tags

Gefragt:

am 11 Sep. 2018

Bearbeitet:

am 11 Sep. 2018

Community Treasure Hunt

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

Start Hunting!

Translated by