Combine Multiple Excel WORKBOOKS into One excel work book without changing the format

2 visualizzazioni (ultimi 30 giorni)
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
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.

Accedi per commentare.

Risposte (0)

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by