How to Cope XLS Worksheet using Matlab

Question

Bill Rooker 2013-3-19

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/67849-how-to-cope-xls-worksheet-using-matlab

回答： 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

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

请先登录，再回答此问题。

Answer 1

Conrad 2013-3-19

1
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/67849-how-to-cope-xls-worksheet-using-matlab#answer_79267

在 MATLAB Online 中打开

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 个评论
显示 -1更早的评论隐藏 -1更早的评论

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

请先登录，再进行评论。

Answer 2

Cedric 2013-3-19

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/67849-how-to-cope-xls-worksheet-using-matlab#answer_79265

编辑：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.