Copy and Paste Excel Sheet into New WorkBook

19 次查看（过去 30 天）

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

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.

Pruthvi G 2019-9-30

MATLAB Data Import and Analysis Data Import and Export Standard File Formats Spreadsheets

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

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

Translated by