Combine Multiple Excel WORKBOOKS into One excel work book without changing the format
2 次查看(过去 30 天)
显示 更早的评论
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 个评论
Walter Roberson
2019-11-28
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.
回答(0 个)
另请参阅
类别
在 Help Center 和 File Exchange 中查找有关 Spreadsheets 的更多信息
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!