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

obtain information on excel files

9 次查看（过去 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 中查找有关 Spreadsheets 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by