Why is MATLAB slow in reading certain Microsoft Excel 2007 files?
Show older comments
I am using the new Microsoft Excel 2007 to create data files which are subsequently imported into MATLAB. I have observed that reading some of the Excel files can be very slow. In particular, the XSLX format is slow. I have tried the following functions XLSREAD, XLSFINFO, IMPORTDATA and the Import Data Wizard.
Accepted Answer
MathWorks Support Team
on 27 Jun 2009
0 votes
It has been determined that the slowness attributed to these formats is because of issues with Microsoft Excel.
One workaround is to save the Excel files in the older XLS format. Another option is to save the files in the new XLSB (B stands for binary) format. It might show some improvement. According to Microsoft, the XLSB format is "optimized for fast loading and saving".
More Answers (0)
Categories
Find more on Spreadsheets in Help Center and File Exchange
Products
on 27 Jun 2009
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!
