How to write excel-file correctly?

2017 10 9
1 个回答
更新时间：2017 10 9
2 次查看（30 天）

0 个投票

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更早的评论 隐藏 1更早的评论

Jan
Jan 2017-10-9
编辑：Jan 2017-10-9
Please post the contents of A. Perhaps it is a cell of cell strings? What is "lot"? Perhaps you have written to cells far apart from the location where you expect them?
xlswrite answers the status, if you catch the output:
status = xlswrite(...)
Please post some code, which allows to reproduce the problem.
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

0 个投票

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.

类别

在 帮助中心 和 File Exchange 中查找有关 Spreadsheets 的更多信息

标签

回答：

Jan
Jan
2017-10-9

Community Treasure Hunt

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

Start Hunting!

Translated by