- https://www.mathworks.com/matlabcentral/answers/228912-copy-and-paste-excel-sheet-into-new-workbook?s_tid=answers_rc1-2_p2_MLT
- https://www.mathworks.com/matlabcentral/answers/478865-copy-an-excel-worksheet-from-one-workbook-to-another-with-matlab
Copy sheets from an excel workbook to a new created workbook with matlab
29 visualizzazioni (ultimi 30 giorni)
Mostra commenti meno recenti
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.
0 Commenti
Risposte (1)
Prince Kumar
il 29 Mar 2022
Hi,
Please refer to the following answers:
Hope this helps!!
0 Commenti
Vedere anche
Categorie
Scopri di più su Startup and Shutdown in Help Center e File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!