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

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

Please help me with this

  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

Can you explain with xaml file


Check as below for your reference

Hope this may help you


@sruthesanju PFA

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