xlsread for multiple sheets?
显示 更早的评论
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
2011-11-17
0 个投票
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.
更多回答（0 个）
类别
在 帮助中心 和 File Exchange 中查找有关 Spreadsheets 的更多信息
2011-11-17
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!
Translated by 
