Hello,
i need to fill row if suppose 4 rows are already filled then automation will read the excel row count and will write new row in 5 the row.
i am trying to do same .i am getting excel count and adding 1 to it.
and writing new row .but it is directly starting from 5 th
cehclk below ss
it should start from A2
help me to resolve this
This can sometimes happen in cases when data was previously there in the rows and then removed.
You can use filter datatable activity to remove rows from original datatable where column should not be empty. For eg where ticket number is empty, remove those rows.
And then calculate dt rows count from the filtered table and assign to int_pendingricketscnt variable
This situation can happen when you deleted already existing data. There data will be deleted but It consider the data is still presents we can say like memory of excel not cleared properly. If you are doing for testing purpose while deleting the existing data dont do like select the data and cick on delete button instead of that choose the option Delete Rows this will clear all the memory and it will give the exact count.
if you requirement also like above, use filter datatable activity take any one column reference and use the filter section for not empty or not whitespace then use that output variable to check the row count.
One more thing why you are using filter conditions to write after the next row try with append activity. for this activity we no need to mention from where it needs to write, it will write free row where it found.
Happy Automation!!
