obtain information on excel files
9 Ansichten (letzte 30 Tage)
Ältere Kommentare anzeigen
Richard
am 10 Jan. 2012
Bearbeitet: Walter Roberson
am 28 Jul. 2019
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?
0 Kommentare
Akzeptierte Antwort
Titus Edelhofer
am 10 Jan. 2012
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 Kommentare
Titus Edelhofer
am 10 Jan. 2012
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 ...
Weitere Antworten (1)
Sukuchha
am 13 Jan. 2012
Bearbeitet: Walter Roberson
am 28 Jul. 2019
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;
0 Kommentare
Siehe auch
Kategorien
Mehr zu Spreadsheets finden Sie in Help Center und File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!