There is any way to know the dimensions of an excel file (rows, columns) without using xlsread?

30 次查看（过去 30 天）
Andres
Andres 2013-6-19
评论： dpb 2024-8-4
There is any way to know the dimensions of an excel file (rows, columns) without using xlsread?
I have very large .csv/.xlsx files and I want to increase a waitbar. My strategy will be make a loop with a percentage of the file to read and then increase the waitbar.... repeating it till the file is completely read.

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

采纳的回答

Tom
Tom 2013-6-19
You can, but you have to open an Actx server - I wouldn't bother unless you really think it's worth it...
Excel = actxserver('excel.application');
Excel.workbooks.Open(fileName,0,true); %file name must also have path
nCols = Excel.ActiveSheet.UsedRange.Columns.Count;
nRows = Excel.ActiveSheet.UsedRange.Rows.Count;
Excel.Quit
Excel.delete
That will probably need adding to (e.g. specifying a worksheet)
  2 个评论
dpb
dpb 2024-8-4
NOTA BENE: The above code snippet leaves the Excel file open...it should also close the file before destroying the connection...
Excel = actxserver('excel.application');
Excel.workbooks.Open(fileName,0,true); %file name must also have path
nCols = Excel.ActiveSheet.UsedRange.Columns.Count;
nRows = Excel.ActiveSheet.UsedRange.Rows.Count;
Excel.ActiveWorkbook.Close(0); % close the workbook!!!!
Excel.Quit
Excel.delete
clear Excel % also get rid of no longer valid Excel object hanging around in workspace
It would be better to encapusate the functionality in a function...

请先登录，再进行评论。

更多回答（1 个）

David Sanchez
David Sanchez 2013-6-19
NO, there is not a way to do what you need/want.

类别

在 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