FiveTech Software tech support forums

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?

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

Thank you,

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

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

Thank you,

I just found that also works

But your suggestion is nicer