How to Cope XLS Worksheet using Matlab
조회 수: 1(최근 30일)
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.
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.
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.