xlsread for multiple sheets?

5 次查看（过去 30 天）
Matt Kocoloski
Matt Kocoloski 2011-11-17
Hello,
Is it possible to import multiple sheets in an Excel workbook using a single call to xlsread? I have a ~100 MB spreadsheet with 72 tabs, each of which has the same format, which all need to be imported.
A single call of xlsread to this file takes about 45 seconds on my machine, and I'm wondering if there is a faster way than calling this function 72 individual times. Thanks a lot.
Matt

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

采纳的回答

Fangjun Jiang
Fangjun Jiang 2011-11-17
I don't think xlsread() currently supports it. You can use Excel COM server to speed up the process. Follow the link in this answer to see a brief introduction. The comments in the answer provide some code too.
http://www.mathworks.com/matlabcentral/answers/16299-is-there-instead-solution-of-xlsread
  2 个评论
Matt Kocoloski
Matt Kocoloski 2011-11-28
Thanks a lot, Fangjun. I had never used this functionality before, but it was exactly what I was looking for. Runtime is down from about an hour to about 2 minutes. Thanks buddy.
Fangjun Jiang
Fangjun Jiang 2011-11-28
Wow, that's a lot of saving on time!

请先登录，再进行评论。

更多回答（0 个）

类别

在 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