How to add new data row in excel

how to add new data row in the data table every day I want to extract some data from one more data table and I want to save the data in another excel sheet (In this excel data has been present) don’t overwrite every day I want to add new data extract from another excel file.

How to do this

Thanks and regards
Chethan p

1 Like

@Chethan_P
in general new data is added to Excel with the append range activity

2 Likes

adding add data row activity

Please add photos or excel file so that we can help you

2 Likes

I got the solution i use Directory.getFiles(“PathOfTheFile”) in assign activity(Variable_1)
path exist–Activity use its a boolean value its give
Use read range activity
inside that use add data row <<>> in array row use row.itemArray
come out of if loop and excel scope use write range activity
use build data table in starting its self

And you will get the O/P

Cheers :beers: :beer:
Chethan P
Happy Automation

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.