MATLAB Answers

Copy and Paste Excel Sheet into New WorkBook

51 views (last 30 days)
Logan Stetsko
Logan Stetsko on 7 Jul 2015
Answered: Pruthvi G on 30 Sep 2019
I have two excel files:
file1.xlsx
file2.xlsx
file1.xlsx has a formatted sheet that I want to copy and paste into sheet 2 of a new workbook: file2.xlsx.
Basically I want to copy a sheet from one book to another.
This is what I have so far( I have tried to modify what I've found from other Threads)
Excel = actxserver('excel.application');
wkbk = Excel.Workbooks.Open('file1');
wksheet = wkbk.Worksheets.Item('Sheet1');
wksheet.Copy(wksheet);
wkbk = Excel.Workbooks.Open('file2.xlsx');
newSheet=wkbk.Worksheets.Item('Sheet2');
newSheet.Name='140C';
wkbk.Save
Excel.Quit

  3 Comments

Jan
Jan on 19 Jul 2019
[MOVED from flags] Flagged as Unclear by Brian Peoples on 17 Jul 2019 at 5:42.
This answer would be appreciated!!
Jan
Jan on 19 Jul 2019
@Brian: The thread is old and the OP forgot to ask a question. So which answer do you mean?
Most likely it is the best idea to open your own question and to add the details there.
Mario Chiappelli
Mario Chiappelli on 19 Jul 2019
Something like this is best suited for VBA, I would recommend exploring how to use that.

Sign in to comment.

Community Treasure Hunt

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

Start Hunting!