Help using xlswrite function

5 ビュー (過去 30 日間)
Julian
Julian 2018 年 9 月 11 日
編集済み: Julian 2018 年 9 月 11 日
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 件のコメント
Guillaume
Guillaume 2018 年 9 月 11 日
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 2018 年 9 月 11 日
編集済み: Julian 2018 年 9 月 11 日
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!

サインインしてコメントする。

回答 (0 件)

カテゴリ

Help Center および File ExchangeSpreadsheets についてさらに検索

タグ

製品


リリース

R2018a

Community Treasure Hunt

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

Start Hunting!

Translated by