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?

Antworten (1)

Walter Roberson
Walter Roberson am 27 Feb. 2017

0 Stimmen

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 Kommentare

SUSHMA MB
SUSHMA MB am 28 Feb. 2017
Here does the filename indicates the name of the .mat file
SUSHMA MB
SUSHMA MB am 28 Feb. 2017
Bearbeitet: SUSHMA MB am 28 Feb. 2017
I am getting the following error
Error using xlswrite (line 165)
Range argument must be a string in Excel A1 notation.

Melden Sie sich an, um zu kommentieren.

Gefragt:

am 27 Feb. 2017

Bearbeitet:

am 28 Feb. 2017

Community Treasure Hunt

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

Start Hunting!

Translated by