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

Question

Andres 2013-6-19

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/79538-there-is-any-way-to-know-the-dimensions-of-an-excel-file-rows-columns-without-using-xlsread

评论： dpb 2024-8-4，14:41

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.

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

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

Answer 1

Tom 2013-6-19

2
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/79538-there-is-any-way-to-know-the-dimensions-of-an-excel-file-rows-columns-without-using-xlsread#answer_89278

在 MATLAB Online 中打开

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 个评论
显示无隐藏无

William Quiroz 2022-4-4

very useful, thanks!

dpb 2024-8-4，14:41

在 MATLAB Online 中打开

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