Read Specific Range in Excel then move file if it contains specific word

Excel Document Search.xaml (13.1 KB)

1 Like

can i have a view on that error with a screenshot if possible
and also the structure of activities used in the design with a screenshot
Cheers @sparkplug93

1 Like

My workflow is in the comment above using vinay’s method

1 Like

Excel Document Search.xaml (13.8 KB)

Hi , I have modified the code
can you pls check now

2 Likes

Still getting an error at For Each Row when the sheet isnt named Report

1 Like

Actually, on all sheets

1 Like

I think what I need to do is is put something in else at the item=“Report” if statement

1 Like

Can you ls post the Error message screenshot here

2 Likes

I’ve narrowed down the issue to being the if statement. When sorting through the files, those with a sheet titled report are open longer but nothing is happening to them after they’re passed onto the if statement

1 Like

Hi , The Issue was you have used excel application scope all the way
which is keeping the excel file open till the End
I have modified the Code
And tested , which is working fine
Pls modify the file paths and get row item value validation in below attached workflow to suit your need

if still faces any issue , pls reply back with the issue , happy to help
Excel Document Search.xaml (15.3 KB)

cheers , Happy Automation

1 Like

Can you please share your example sheet with me? It’s still not working

1 Like

Excel Validation.zip (12.3 KB)

It’s the Test1.Xlsx file in the folder
You need to change Column index in your workflow at Get row item of OutputName for your file validation to work

1 Like

does it matter that the data contained in the second row is merged from A2:I2

1 Like

I don’t think so .
Pls put a sample file here to verify

1 Like

Example.xlsx (18.9 KB)

1 Like

See example

1 Like

have you had any luck

1 Like

Hi , I need a file with Dummy Data but same like original file format if you don;t want to share actual data
because i want to see which row you are trying to extract
The file you have sent is Blank and tried with some data But unable to understand your requirement , which row you want to get values

1 Like