Append data 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

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

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

Can you share the screenshot of you flow

Regards
Gokul

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


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

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

image

@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