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 ?