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

Help
,
1

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.

2

@ravi_gupta

Could you please share where exactly you’re facing issue

3

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

4

@ravi_gupta

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

5

@ravi_gupta

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
6

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

7

Sure, No problem @ravi_gupta

8

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

9

@ravi_gupta

Multiple files means for more than one rows ?

10

Yes

Untitled
Untitled1920×1080 115 KB

I have these types of files in the Folder.
Untitled1
Untitled11920×1080 173 KB
not giving proper output.

11

@ravi_gupta

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

1 Like
12

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 .

13

@ravi_gupta

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
14

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

Thanks & regards
Ravi Gupta.

15

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