Question Find total rows & columns in xlsx

[rzr]

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?

 

[rzr]

this is the code I'm using to read cell.

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.

 

[JamesBowen]

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?

 

[rzr]

I'm using com-object and I'm on 10.1c

 

[JamesBowen]

I'm using com-object and I'm on 10.1c

Sorry I can't help you.
Does this help :http://stackoverflow.com/questions/16937788/get-the-number-of-rows-in-column-of-a-worksheet

 

[rzr]

Perfect Thanks Cecil !!

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

hObjectRange   = hWorkSheet:UsedRange      
iRowCount      = hObjectRange:Rows:count
iColCount      = hObjectRange:Columns:count.

 

[JamesBowen]

Perfect Thanks Cecil !!

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

hObjectRange   = hWorkSheet:UsedRange     
iRowCount      = hObjectRange:Rows:count
iColCount      = hObjectRange:Columns:count.