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
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!