Combine Multiple Excel WORKBOOKS into One excel work book without changing the format
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.
Akash Rana
on 19 Dec 2019
Answers (0)
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!