Combine Multiple Excel WORKBOOKS into One excel work book without changing the format
2 visualizzazioni (ultimi 30 giorni)
Mostra commenti meno recenti
Hi friends, I have to combine multiple excel work book and make it one workbook (by using MATLAB )which will contains all sheets ,for example I have two excel work book which containing 5 excel sheet each now my output excel work book should contain 10 sheets .I tried the merge commands but it is not helping me.
2 Commenti
Walter Roberson
il 28 Nov 2019
The only way to do that is to use the ActiveX interface to Excel on a Windows system. The Mathworks interface functions for reading and writing workbooks cannot query or set cell format information.
Each excel cell can have its own format, and when you are dealing with multiple sheets you must assume that the sheets do not have thesame number of columns or the same format.
Risposte (0)
Vedere anche
Categorie
Scopri di più su Spreadsheets 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!