清空筛选条件
清空筛选条件

Read 'next sheet' in excel file

1 次查看（过去 30 天）
raymond
raymond 2012-7-19
I have multiple excel files with many sheets of different name. (5 excel files, each has >20 worksheets)
my objective is to read cell B2 from every sheet and store them in a big matrix
its really really time consuming to write something like this f=xlsread(InputFileName1,sheet1,'B2'); f=xlsread(InputFileName1,sheet2,'B2'); f=xlsread(InputFileName1,sheet3,'B2'); f=xlsread(InputFileName1,sheet4,'B2'); etc...
every sheet is nammed differently, so in the above example, i have to rename every single sheet (again time consuming)
xlsread is a very slow command, is there a more efficient way to read all one shot? or any command to "read next sheet", so i dont have to rename the sheet name one by one in my m file?
please help, thanks:-)

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

回答（1 个）

Image Analyst
Image Analyst 2012-7-19
You need to use ActiveX. Search the Answers forum for examples, or use Brett's code: http://www.mathworks.com/matlabcentral/fileexchange/4415-readfromexcel

类别

在 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