Find out the range of a excel-sheet

[Marc Vanzegbroeck]

Hi,

I have to import an excel file into a database an now I'm using the oSheet:Cells( nRow, nCol ):Value methode to read the first column to know
how many records the are, and read the fist row , how many colums to import.
Then I can use GetExcelRange()
Is there a faster way to know which row is the first empty cell, and which column is the first empty one?

[nageswaragunupudi]

oRange := GetExcelRange( cExcelFile )
Automatically returns the used range.

[Marc Vanzegbroeck]

Thank you,

With len( ArrTranspose( oRange:Value )) and now how many records there are, but how can I know the numbers of columns?

[nageswaragunupudi]

? oRange:Rows:Count
? oRange:Columns:Count

[Marc Vanzegbroeck]

Thank you,

I just found that also

Code: Select all  Expand view

len( ArrTranspose( oRange:Value )[1])

works

But your suggestion is nicer