MATLAB Answers

How to Cope XLS Worksheet using Matlab

2 views (last 30 days)
Bill Rooker
Bill Rooker on 19 Mar 2013
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 Comments

Sign in to comment.

Answers (3)

Conrad
Conrad on 19 Mar 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 Comment

Bill Rooker
Bill Rooker on 21 Mar 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

Sign in to comment.


Cedric Wannaz
Cedric Wannaz on 19 Mar 2013
Edited: Cedric Wannaz on 19 Mar 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.

  0 Comments

Sign in to comment.


Sign in to answer this question.

Tags

Products