'xlsread' cost much time to complete. Even readtable

Hello dear friends

xlsread works mormally, but now it cost more than 1min to import data from an Excel sheet (780kb), even readtable. It seems every functions related to open or import data from excel will cost long time suddenly (ONLY few seconds before). I don know why? is there any problems with Matlab or Excel?

Thanks for your reading and suggestion.

[yimin ch]

I found when there's only one sheet in excel it will speed up.

But yesterday even if there were 2 sheets it loaded fast :((((

[Walter Roberson]

Which MATLAB version are you using? If you are using a new enough version you can tell readtable() not to communicate with Excel to do the reading.

[yimin ch]

I am using r2018b, the Help document of 'readtable' indicates that the command creates a table based on a file. Does it mean it must open Excel?

Maybe the version isn't new enough.

Thx , @Walter Roberson.

[Walter Roberson]

If I recall correctly, your R2018b version is the first version that supported the 'UseExcel' option, but it already defaults to false.

... But you could experiment with using 'UseExcel', false or 'UseExcel', true in order to see if it makes a difference.

[yimin ch]

A flawless solution!!!

I found 'UseExcel' opt, and when the logic value equals 0, there is no Excel background process, and the data reading complete in a flash :) Totally different when it equals 1.

Thanks!!!@Walter Roberson