Question Find total rows & columns in xlsx

rzr

rzr

Member
Hello All,

It may be very obvious but can't figure this out this afternoon. I'm trying to load a xlsx file into a temp-table.
Before I do that is there way to determine how many rows and columns does this file contain, so I know how many rows & columns I need to loop through?
 
this is the code I'm using to read cell.

Code: 
REPEAT iRow = 1 TO 4 :                                   
                                                         
    MESSAGE                                              
        hWorkSheet:Range("A":U + STRING(iRow)):VALUE SKIP
        hWorkSheet:Range("B":U + STRING(iRow)):VALUE SKIP
        hWorkSheet:Range("C":U + STRING(iRow)):VALUE SKIP
        hWorkSheet:Range("D":U + STRING(iRow)):VALUE SKIP
        hWorkSheet:Range("E":U + STRING(iRow)):VALUE     
        VIEW-AS ALERT-BOX INFO BUTTONS OK.               
END.
 
Are you using Excel com-object to extract data from the the xlsx file or are you parsing the XML to get the cell data?
 
Perfect Thanks Cecil !!

the below code gets the "Range" and then from there on I can get the RowCount & ColumnCount.

Code: 
hObjectRange   = hWorkSheet:UsedRange      
iRowCount      = hObjectRange:Rows:count
iColCount      = hObjectRange:Columns:count.
 
rzr said:
Perfect Thanks Cecil !!

the below code gets the "Range" and then from there on I can get the RowCount & ColumnCount.

Code: 
hObjectRange   = hWorkSheet:UsedRange     
iRowCount      = hObjectRange:Rows:count
iColCount      = hObjectRange:Columns:count.
Click to expand...
:)
 
You must log in or register to reply here.
Back
Top