Excel Automation : File Found Than Do Else Write File Not Found In Excel

Dear All,

Hi I have Some Issue Regarding Excel Automation Like in folder I have 2 files like “price change 02 02 2019” and “price change 25 02 2019” and that file name is Written in one Exel Sheet Column Named as “Files” named as a report.xlsx
Automation is Like Go through the excel row by row and Check That File Exist or not.
If File Exist Do Something and if file Doesn’t exist Write in the status file not Found In Specific Folder

XAML File is attached with excel sheetReport.xlsx (8.2 KB)
Sequence1.xaml (15.2 KB)

can Someone help me out with this scenario?

Thanks & Regards
Ravi Gupta.


Could you please share where exactly you’re facing issue

I Cannot write if the File not Found AND it is not not breaking if file found i have Tried Many Times .
U can look in the xaml Files


Sure, I’ll go through it and update you on the same.


Please find the attached below files. I tried and it’s working as per your problem statement.
Report.xlsx (9.9 KB)
Sequence1.xaml (18.3 KB)

Let me know if you’re good to go with this solution.

1 Like

Its Worked Thank You For the Solution I Will Go through the File And Let You If i have any Doubt.

Thanks & Regards
Ravi Gupta

Sure, No problem @ravi_gupta

It is not Working With Multiple Files Report.xlsx (8.0 KB)
You Can Run and See this Report File.


Multiple files means for more than one rows ?


I have these types of files in the Folder. not giving proper output.


No issues. I guess I need to change a little bit in condition. I’ll check and update you

1 Like

Thank You For your Help …:grinning:
I have Learn many things .

Report file is like it will add file name continuously. and check that file exist or not in the Folder .


There was one condition missing in the workflow. The issue was in Status column, it was overriding the status however the data inside the file is getting updated properly.

I’ve updated the workflow. Please find the attached files and let me know if that’s the solution you’re looking for.
Report.xlsx (9.9 KB)
Sequence1.xaml (18.7 KB)
Device Price Change -12 04 98.xlsx (9.8 KB)
Device Price Change -20 05 99.xlsx (9.8 KB)
Device Price Change -20 05 100.xlsx (9.8 KB)

I’m glad to hear that. Happy Automation :+1:

1 Like

Thank You Its Working As Expected. :heart_eyes::heart_eyes::heart_eyes::heart_eyes::heart_eyes::heart_eyes::heart_eyes:

Thanks & regards
Ravi Gupta.

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