Copy sheets from an excel workbook to a new created workbook with matlab
25 views (last 30 days)
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.
Prince Kumar on 29 Mar 2022
Please refer to the following answers:
Hope this helps!!