How can I extract from Matlab two vector with diferrent dimension in to the same excel page without having to create different sheets

T=table(X(:),Y(:));

% X and Y have the same length

fileName='Project.xlsx';

writetable(T,fileName);

I need to extrac other 2 vector (with equal length) but with differente length from the privious ones to the same exel file~or at least to the same exel file but in a different sheet.

How can I do that?

Answer 1

[Tommy]

One option, which leaves a blank column between the two sets:

T2 = table(X2(:), Y2(:));
writetable(T2, fileName, 'Range', 'D1');

[Bernardo Pereira]

I tried that aprouch but i forgot to include the 'Range'.

Tank you very much Tommy. Now It works!

[Bernardo Pereira]

Do you happen to know how can i label my columns?!

For exemple in the column X2 I want to name that in the exel page as "Nº of deaths"

[Tommy]

Happy to help!

Sure, use

T2 = table(X2(:), Y2(:), 'VariableNames', {'var1name', 'var2name'});

when creating the table, and writetable will write the variable names to excel by default.

[Bernardo Pereira]

T=table(deaths(:),rate(:));

fileName='Results.xlsx';

writetable(T,fileName, 'VariableNames',{'Deaths','Rate'});

L=table(Mortality(:),life(:));

fileName='Results.xlsx';

writetable(L,fileName,'Range','D1');

Sorry i tried to implement your sugestion but it gives an error

[Tommy]

table takes the 'VariableNames' argument, not writetable:

T=table(deaths(:),rate(:),'VariableNames',{'Deaths','Rate'});
fileName='Results.xlsx';
writetable(T,fileName);

L=table(Mortality(:),life(:));
writetable(L,fileName,'Range','D1');

[Bernardo Pereira]

By doing that how can a label my columns in the table L?!

L=table(Mortality(:),life(:),'VariableNames',{'Mortality','life'});-I can´t do this since i already used 'VariableNames' in the previous table

[Tommy]

You can do that! T and L are different tables, you are able to use any valid syntax of the function table() for either one. Do you get an error if you do try it like that? i.e.

T=table(deaths(:),rate(:),'VariableNames',{'Deaths','Rate'});
fileName='Results.xlsx';
writetable(T,fileName);

L=table(Mortality(:),life(:), 'Variablenames', {'Mortality','life'});
writetable(L,fileName,'Range','D1');

[Bernardo Pereira]

Thak You so much for your time and patience!