large excel file reading.

1 次查看（过去 30 天）
Pappu Murthy
Pappu Murthy 2018-2-2
回答： Bob Thompson 2018-2-2
my excel file has 61 columns and 180,000 rows or so. It is taking forever to read it. i am using Readtable with appropriate range specified. It worked fine for smaller size excel file. Is there a trick to it?

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

回答（1 个）

Bob Thompson
Bob Thompson 2018-2-2
It is possible to use the ActiveX ability, (actxserver('Excel.Application') to start excel) but this option can take a bit of learning and requires a lot more manual control for sheet names and the like.
Basically, what it does is opens Excel within matlab and conducts the operations with the consistently open file. It will still take some time, simply because you have a lot of data, but it will prevent any opening and reopening you may have with tableread or other commands.

类别

在 Help Center 和 File Exchange 中查找有关 Spreadsheets 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by