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

3 visualizaciones (últimos 30 días)
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 comentarios
Manish Shankar Neelgar
Manish Shankar Neelgar el 22 de En. de 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

Iniciar sesión para comentar.

Respuestas (0)

Etiquetas

Productos


Versión

R2019b

Community Treasure Hunt

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

Start Hunting!

Translated by