Clear Excel values


#1

I have a pre-populated excel (Excel1) with dynamic rows and columns (sometime its 3 rows , 5 columns , sometimes it is 6 rows, 10 colums).

it looks something like this - I have to clear out the greyed part.

One logic I thought -read each cell and delete if not empty.which is fine but SLOW.

Is there an option of selecting the complete row ?

Is there an option to get row count/column count of the excel table ?


#2

@sampad_das_PwC2,

There is an action to get a row and put its value into a variable - https://kb.workfusion.com/display/RPAe/Excel#Excel-GetRow

There is no function to get row count/column count of the excel table.

But you can create a While loop that will run until the current cell value is not empty.