obtain information on excel files

Is there a method for obtaining more information for excel files? I can use

    [status,sheets,format] = xlsfinfo(filename)

to find the names of each sheet in the workbook, however, I'm trying to find a way of obtaining the number of measurements i.e. the number of rows and columns in the excel files. Is there a way of doing this without having to import the data into matlab?

Answer 1

[Titus Edelhofer]

You could open the file using actxserver (see doc) and make your way through the file using methods and properties. It probably will be cumbersome, though.

[Richard]

I have used actxserver before but it takes too long to process the excel files (75+ files) therefore was hoping to aviod using it.

[Titus Edelhofer]

But you could still save some time: if you take a look at xlsfinfo, you see, that it starts Excel as activeX server as well. Most of the time is spent for two lines, namely starting the server and opening/closing a file. You could save the first by looping over all files without stopping the activex server. I guess not much else can be done ...

Answer 2

[Sukuchha]

I guess if you know VBA then you can use to get what u want after opening with activeX server. for example below, sheets and counts are funtion of excel.

excelObj = actxserver('Excel.Application');
excelWorkbook = excelObj.workbooks.Open('Book2.xls');
worksheets = excelObj.sheets;
numSheets = worksheets.Count;