How to copy a cell array to Excel?

4 次查看（过去 30 天）
SUSHMA MB
SUSHMA MB 2017-2-27
编辑： SUSHMA MB 2017-2-28
I have a cell array 'X' with value '82794x1 cell' Inside which their are some matrix like
[1x12] double
[1x18] double
[1x6] double
[1x14] double
[1x6] double
[1x10] double
[1x6] double
[1x8] double.....and so
How can i copy the values of cell 'X' into an excel sheet?

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

回答（1 个）

Walter Roberson
Walter Roberson 2017-2-27
Excel is not designed to have nested arrays inside entries. You would have to create 82794 "sheets" with one cell's worth each:
for K = 1 : length(X)
xlswrite(FileName, X{K}, 'Sheet', K);
end
  2 个评论
SUSHMA MB
SUSHMA MB 2017-2-28
Here does the filename indicates the name of the .mat file
SUSHMA MB
SUSHMA MB 2017-2-28
编辑：SUSHMA MB 2017-2-28
I am getting the following error
Error using xlswrite (line 165)
Range argument must be a string in Excel A1 notation.

请先登录，再进行评论。

类别

在 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