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

조회 수: 1 (최근 30일)
Siqi
Siqi 2013년 9월 9일
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.

답변 (0개)

카테고리

Help CenterFile Exchange에서 Spreadsheets에 대해 자세히 알아보기

Community Treasure Hunt

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

Start Hunting!

Translated by