How to get filled row count and get the address of next empty row

Help Activities
, , , ,
1

In excel from range A50:A100 indeed to find how many cells are filled with data and I need to get next empty cell address
For example A50 ,A51 have data so I need to fill from A52 how to find that

1 Like
2

Please help me with this

3
  1. Read the sheet with read range(Check Is Header property selected). Let’s say output is varDT
  2. Then varNextEmptyRowCount = (varDT.rows.count+2) will give you next empty row number
    and varFilledRowCount = varDt.rows.count
4

Can you explain with xaml file

5

@sruthesanju

Check as below for your reference

Hope this may help you

Thanks

6

@sruthesanju PFA

Excel.xaml (5.9 KB) ExcelAutomation1.xlsx (9.5 KB)