Copy and Paste Excel Sheet into New WorkBook
12 次查看(过去 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 个评论
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
2019-7-19
Something like this is best suited for VBA, I would recommend exploring how to use that.
另请参阅
类别
在 Help Center 和 File Exchange 中查找有关 Spreadsheets 的更多信息
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!