How to add/write multiple spreadsheets to a excel file from MATLAB?

1 visualizzazione (ultimi 30 giorni)
Hello Everyone,
Let's consider I have three spreadsheets named A1, A2, A3 and I wish to write these 3 spreadsheets to a single excel file in MATLAB. Could anyone please let me know How I can do it?
Thanks in advance.
  6 Commenti
Manish Shankar Neelgar
Manish Shankar Neelgar il 22 Gen 2021
I need the sheet name also to be same. I tweeked your code and got the perfect solution. Thank you for your help. It saved my time.
[~,sheet_name]=xlsfinfo('Test.xlsx')
for k=1:numel(sheet_name)
[~,~,data{k}]=xlsread('Test.xlsx',sheet_name{k});
writecell(data{k},'Result.xlsx','Sheet',sheet_name{k});
end

Accedi per commentare.

Risposte (0)

Prodotti


Release

R2019b

Community Treasure Hunt

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

Start Hunting!

Translated by