obtain information on excel files

7 次查看（过去 30 天）
Richard
Richard 2012-1-10
编辑： Walter Roberson 2019-7-28
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?

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

采纳的回答

Titus Edelhofer
Titus Edelhofer 2012-1-10
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.
  2 个评论
Richard
Richard 2012-1-10
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
Titus Edelhofer 2012-1-10
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 ...

请先登录，再进行评论。

更多回答（1 个）

Sukuchha
Sukuchha 2012-1-13
编辑：Walter Roberson 2019-7-28
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;

类别

在 Help Center 和 File Exchange 中查找有关 Use COM Objects in MATLAB 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by