Copy sheets from an excel workbook to a new created workbook with matlab

20 次查看（过去 30 天）
Ruth Pikovsky
Ruth Pikovsky 2021-11-11
回答： Prince Kumar 2022-3-29
Hello,
my question is how to use matlab to copy sheets from a specific workbook, create a workbook, and copy the sheets to the new workbook. I tried to following code:
wkbk = ExcelApp.Workbooks.Open(fullname);
wksheet = wkbk.Worksheets.Item('sheet1');
wksheet.Copy(wksheet);
but it copies the sheet into the same workbook and I wasn't sure how to create a new one and copy the sheet there.
I would highly appreciate your help.

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

回答（1 个）

Prince Kumar
Prince Kumar 2022-3-29

类别

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

标签

产品


版本

R2021a

Community Treasure Hunt

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

Start Hunting!

Translated by