Writing cell array to an excel file - Empty!

1 vue (au cours des 30 derniers jours)
Panda
Panda le 7 Avr 2016
Hello
I have a cell array of size 267X400 where every cell is a has 3 elements (A:B:C for eg.). I would like to copy the contents of this cell array to -
1. A text file 2. An excel file
For the text file, I used the following code:
[nrow ncol]=size(combi);
%formatspec=repmat('%u\t',1,size(combi,2));
for j=1:nrow
fprintf(fileID,[repmat('%u\t',1,size(combi,2)) '\n\n'],combi{j,:});
end
problem is that the text file displays upto some columns properly and then its random.
2. For the excel file, I used xlswrite ('Filename',combi) .All i get is a blank excel file.
Any insights as to where I am going wrong, it would be nice.
Thanks!
  2 commentaires
Muhammad Usman Saleem
Muhammad Usman Saleem le 7 Avr 2016
can you provide your sample cell array. I want to investigate it
Azzi Abdelmalek
Azzi Abdelmalek le 7 Avr 2016
Can you post a short example that illustrate how your data are stored, for example a 2x2 cell array

Connectez-vous pour commenter.

Réponses (1)

Muhammad Usman Saleem
Muhammad Usman Saleem le 7 Avr 2016
try this
xlswrite ('Filename',combi(:))
  1 commentaire
Panda
Panda le 7 Avr 2016
@Saleem..no bro..it aint working. The excel file is still empty...

Connectez-vous pour commenter.

Community Treasure Hunt

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

Start Hunting!

Translated by