Most Efficient Spreadsheet File

Question

Daniel 2014-11-19

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/163445-most-efficient-spreadsheet-file

评论： Daniel 2014-11-20

Hello,

I am going to write a Matlab script that will pull data from multiple Excel files. I imagine this script will take a long time to run. I was wondering if I could save my Excel files as a different file type to make the script work more efficiently. I will only be using one spreadsheet from each excel file and I am only going to be reading text from the Excel files.

Thanks.

3 个评论
显示 1更早的评论隐藏 1更早的评论

Image Analyst 2014-11-19

Tell us how many files you will read. Is it more than about 5 or 10 or so?

Daniel 2014-11-20

I am going to be reading 20-30 files. Each file will have roughly 2000 rows and 5 columns of data. Only one column of the data will be numeric, the other columns will be names, serial numbers, and comments.

请先登录，再进行评论。

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

Answer 1

Image Analyst 2014-11-19

1
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/163445-most-efficient-spreadsheet-file#answer_159524

ExcelDemo.m

It will take a long time, unless you use ActiveX. See my attached ActiveX demo. With ActiveX it only opens and shutdowns Excel once instead of every single time you call xlsread().

3 个评论
显示 1更早的评论隐藏 1更早的评论

Image Analyst 2014-11-20

For that amount of data, you certainly don't want to use xlsread(). You could use ActiveX, but if you can, I think the fastest way would be to convert the data to text (like a csv file) and use csvread(), dlmread(), or importdata(). ActiveX would be more complicated and probably not faster than these text-reading functions since ActiveX still has to launch Excel.

Daniel 2014-11-20

I can't use csvread or dlmread because those are for numeric data only. I made a CSV file and tested the import speed using both importdata and textscan with a simple MATLAB script. Each time I imported the data, textscan was about 10-30 times faster than importdata.

请先登录，再进行评论。

Answer 2

Evan 2014-11-19

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/163445-most-efficient-spreadsheet-file#answer_159527

If Image Analyst's solution doesn't work for you, you might try csvread. Assuming you're able to save your data in .csv format, I've found that csvread is a couple orders of magnitude faster than xlsread.