Append data 1

Help Robot
,
1

I want to check that if excel file is not there the write excel file if it is there then append more data in file
what should i write in condition of if activity

2

Hi @Kuldeep_Pandey

In the If activity

System.IO.File.Exists("C:\Users\Dell\Documents\UiPath\Test\BuildDt.xlsx")

In Then → Use Append activity

In Else → Use Write Range activity

image

Regards
Gokul

3

Its not adding data its clearing privious data and writing new one not adding

4

Can you share the screenshot of you flow

Regards
Gokul

5

Your flow should look like this on in the below image @Kuldeep_Pandey

image
image736×394 18.5 KB

6

image
image872×451 12.8 KB

Its not adding data its removing previous data and give new data in append range

7

Then Switch the write and Append Range activity and check it @Kuldeep_Pandey

image

8

@Kuldeep_Pandey

Check that will file exist activity then if file is available then use write range activity to write the data in excel else if excel file is available the use append range activity

Thanks
Varun