How to read a large number of xlsx files without error on EXCEL server?

1 visualizzazione (ultimi 30 giorni)
Siqi
Siqi il 9 Set 2013
I have about 15,000 xlsx files to extract information from. XLSREAD was used to read data. It worked fine and fast at the beginning, but became slow after several thousand files have been read. At the same time, there was a warning saying that EXCEL server failed and 'Basic Mode' was used. Data were still able to be read in 'Basic Mode', but it was very very slow. Does anybody know what may cause the failure in EXCEL server after reading a large number of files? Thanks!
PS: The Matlab version is R2013a. The EXCEL version is 2010. The OS is WinXP SP3.

Accedi per rispondere a questa domanda.

Risposte (0)

Categorie

Scopri di più su Spreadsheets in Help Center e File Exchange

Tag

Community Treasure Hunt

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

Start Hunting!

Translated by