Combine Multiple Excel WORKBOOKS into One excel work book without changing the format
2 views (last 30 days)
Show older comments
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 Comments
Walter Roberson
on 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.
Answers (0)
See Also
Categories
Find more on Spreadsheets in Help Center and File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!