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
- Read the sheet with read range(Check Is Header property selected). Let’s say output is varDT
- Then varNextEmptyRowCount = (varDT.rows.count+2) will give you next empty row number
and varFilledRowCount = varDt.rows.count
Can you explain with xaml file