How to Cope XLS Worksheet using Matlab

1 visualización (últimos 30 días)
Bill Rooker
Bill Rooker el 19 de Mzo. de 2013
Respondida: Pruthvi G el 30 de Sept. de 2019
Hello everyone,
Is there any way to copy an XLS worksheet, rename it, and post data to it? I have a template worksheet that is formatted in the manner I want it. I have different data sets in which I want to use the template so that I can minimize having to reformat every worksheet I generate. Note that I did not see anything under XLSWRITE, but let me know otherwise.
Thank you for any assistance.
Best regards,
Bill Rooker

Respuestas (3)

Conrad
Conrad el 19 de Mzo. de 2013
Hi Bill, you can use dos commands from within MATLAB to copy the file:
original_file = 'orginal_file_name';
copied_file = 'copied_field_name';
dos(['copy ' original_file ' ' copied_file]);
You can now use xlswrite to write to the copied sheet.
Conrad
  1 comentario
Bill Rooker
Bill Rooker el 21 de Mzo. de 2013
Hello Conrad,
Thanks for the response. To clarify, I am looking for a way to copy a template worksheet from within a XLS file so that I only have 1 file with multiple worksheets. Do you have a solution for this? Thanks.
Best regards,
Bill Rooker

Iniciar sesión para comentar.


Cedric
Cedric el 19 de Mzo. de 2013
Editada: Cedric el 19 de Mzo. de 2013
You can actually write data into an existing, preformated worksheet using xlswrite, because it doesn't change the format. If you had a template file, you could copy this file first and then write data into the copy. Now if you really want to add/copy worksheets to/within an existing file/workbook, I think that you will need to have a look at ACTXSERVER. I've never used it myself, though.

Pruthvi G
Pruthvi G el 30 de Sept. de 2019

Etiquetas

Productos

Community Treasure Hunt

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

Start Hunting!

Translated by