How to write excel-file correctly?

3 次查看（过去 30 天）
laboratoryassist
laboratoryassist 2017-10-9
回答： Jan 2017-10-9
Hello, i'm attempting to create an excel-file which contains the information of a cell array i created.
sheet = 1;
xlRange = lot;
A=chain;
xlswrite(filename,A,sheet,xlRange)
It's possible to open the file, the aimed cells are highlighted but empty. Also i dont get back a 1 or 0 as a status for the writing operation. Does anyone have a clue how to fix this? (The cell array 'chain' is not empty.)
Thanks in advance.
  3 个评论
显示 1更早的评论
laboratoryassist
laboratoryassist 2017-10-9
>> lot
lot =
B2
>> A
A =
{1x1 cell} {1x1 cell} {1x1 cell}
>> A{:,:}
ans =
'ABC'
ans =
'DEF'
ans =
'GHI'
laboratoryassist
laboratoryassist 2017-10-9
The problem seems to be that the content of A are cell arrays themselves. Fixed it. Thanks for the impulses.

请先登录，再进行评论。

请先登录，再回答此问题。

回答（1 个）

Jan
Jan 2017-10-9
The problem was solved in the comments already. Now as an answer:
A =
{1x1 cell} {1x1 cell} {1x1 cell}
The contents of A must be strings or scalar numbers:
A = {'hello', 9}
Providing a cell of cells does not work. What a pity, that XLSWRITE does not provide a meaningful error message.

类别

在 Help Center 和 File Exchange 中查找有关 Spreadsheets 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by