writetable to (.xlsx file) blank output

I have a Table compose of string names (about 130+ names). Only 1 column.

BUT my excel file is Blank. no errors or warnings. just the output is BLANK.

please, can someone explain.

data=table;
 f=fieldnames(data);
 for k=1:size(f,1)
   xlswrite('name.xlsx',data.(f{k}),f{k})
 end
 
 %also tried this code: writetable(table,'name.xls','Sheet',2)

Answer 1

[Alex Mcaulley]

Apparently writetable(table,'name.xls','Sheet',2) should work.

I think the problem is the name of the variable, table is a matlab function that gives an empty table. Try changing the name of the variable.

[Adel Monette Rivera]

Still blank. Only the variable name on it :(

[Alex Mcaulley]

And that works?

T = table({'name1';'name2';'name3'})
xlswrite('name.xlsx',table2cell(T))

[Adel Monette Rivera]

I think I know the real problem. I added number column to the names. number column are able to be "writetable" but the name column are blanks.

but I still dont know how to correct it

[Alex Mcaulley]

Can you upload your table in a mat file?

[Adel Monette Rivera]

here: my .mat file

[Alex Mcaulley]

The problem is that your names are cell arrays inside cell arrays and for that, xlswrite doesn't work. You need to convert them to char and then write the xlsx file.

nameall(:,1) = cellfun(@char,nameall(:,1),'UniformOutput',0)
xlswrite('name.xlsx',nameall,2)

[Adel Monette Rivera]

WOW!!!~ it work like magic :D

thanks.

now, can i really put cell arrays inside a cell array?

[Alex Mcaulley]

For sure:

A = cell(1,1);
A{1} = cell(1, 5);