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

27 views (last 30 days)
Ruth Pikovsky
Ruth Pikovsky on 11 Nov 2021
Answered: Prince Kumar on 29 Mar 2022
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');
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.

Answers (1)

Prince Kumar
Prince Kumar on 29 Mar 2022





Community Treasure Hunt

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

Start Hunting!