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

27 次查看（过去 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 中查找有关 Startup and Shutdown 的更多信息

标签

产品


版本

R2021a

Community Treasure Hunt

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

Start Hunting!

Translated by