How to Cope XLS Worksheet using Matlab

1 次查看(过去 30 天)
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

回答(3 个)

Conrad
Conrad 2013-3-19
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 个评论
Bill Rooker
Bill Rooker 2013-3-21
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

请先登录,再进行评论。


Cedric
Cedric 2013-3-19
编辑:Cedric 2013-3-19
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 2019-9-30

标签

产品

Community Treasure Hunt

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

Start Hunting!

Translated by