How to Cope XLS Worksheet using Matlab

조회 수: 1(최근 30일)
Bill Rooker
Bill Rooker 2013년 3월 19일
답변: Pruthvi G 2019년 9월 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


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.
  댓글 수: 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 Wannaz
Cedric Wannaz 2013년 3월 19일
편집: Cedric Wannaz 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