How to copy a cell array to Excel?

7 vues (au cours des 30 derniers jours)
SUSHMA MB
SUSHMA MB le 27 Fév 2017
Modifié(e) : SUSHMA MB le 28 Fév 2017
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?

Connectez-vous pour répondre à cette question.

Réponses (1)

Walter Roberson
Walter Roberson le 27 Fév 2017
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 commentaires
SUSHMA MB
SUSHMA MB le 28 Fév 2017
Here does the filename indicates the name of the .mat file
SUSHMA MB
SUSHMA MB le 28 Fév 2017
Modifié(e) : SUSHMA MB le 28 Fév 2017
I am getting the following error
Error using xlswrite (line 165)
Range argument must be a string in Excel A1 notation.

Connectez-vous pour commenter.

Catégories

En savoir plus sur Spreadsheets dans Help Center et File Exchange

Tags

Community Treasure Hunt

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

Start Hunting!

Translated by