Copy and Paste Excel Sheet into New WorkBook

38 次查看（过去 30 天）
Logan Stetsko
Logan Stetsko 2015-7-7
回答： Pruthvi G 2019-9-30
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 个评论
显示 1更早的评论
Jan
Jan 2019-7-19
@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 2019-7-19
Something like this is best suited for VBA, I would recommend exploring how to use that.

请先登录，再进行评论。

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

回答（1 个）

Pruthvi G
Pruthvi G 2019-9-30

类别

在 Help Center 和 File Exchange 中查找有关 Spreadsheets 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by