Reading large excel file using "read" command takes ~5 minutes, is this expected performance?

Question

Ajay Kumar 2020-9-5

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/589507-reading-large-excel-file-using-read-command-takes-5-minutes-is-this-expected-performance

评论： J. Alex Lee 2020-9-7

I am reading a simulation/test output data in a .xlsx file into a matlab table through a datastore variable. The test data contains 450+ variables, each with 20000+ samples (i.e.) 450+ columns and 20000+ rows but all are numbers. I created a datastore on the excel file, modified the selected variables and variable type properties and used read command to read the file into a matlab table, it took about ~5 minutes. When I tried readtable command on the excel file directly, it took about the same time as well. However when I tried reading the file interactively using matlab export dialog, it took less than 30 seconds, so I am wondering if there's any way to achieve the same level of efficiency programmatically?

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

请先登录，再回答此问题。

Answer 1

J. Alex Lee 2020-9-6

1
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/589507-reading-large-excel-file-using-read-command-takes-5-minutes-is-this-expected-performance#answer_490762

Try manually creating the import options with spreadsheetimportoptions().

2 个评论
显示无隐藏无

Ajay Kumar 2020-9-7

Thanks. I will read up on this function and try it out. The format of the test output sheet will not change that often, but If it does, then I will have to update this object that I am gonna create?

J. Alex Lee 2020-9-7