Excel Document Search.xaml (13.1 KB)
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
My workflow is in the comment above using vinay’s method
Still getting an error at For Each Row when the sheet isnt named Report
Actually, on all sheets
I think what I need to do is is put something in else at the item=“Report” if statement
Can you ls post the Error message screenshot here
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
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
Can you please share your example sheet with me? It’s still not working
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
does it matter that the data contained in the second row is merged from A2:I2
I don’t think so .
Pls put a sample file here to verify
See example
have you had any luck
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