How to copy a cell array to Excel?

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 日

0 投票

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.

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

質問済み:

2017 年 2 月 27 日

編集済み:

2017 年 2 月 28 日

Community Treasure Hunt

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

Start Hunting!

Translated by