Search through excel files in folders then copy them to another folder

Hello,

I want to search through excel files in a folder then copy them else where.

@sparkplug93

May I know what error are you getting here ?

Hi @sparkplug93

Please add [for each row] for get data in your datatable
and try to use follwing condition

string.Join(",",row.ItemArray).Contains(“NORTH”)

See as below for guideline

I hope it would be useful for you :blush:

I’m getting an error at output tables (variable type DataTable) and with the condition for the if statement. Additionally, is there a way to move these files to a folder if they contain the keyword?

Thanks

If you want to search anywhere in that excel THEN
Use
Read Range-----dt1
output datatable—textdt
if-------textdt.contains(“North”)
yes then Move/Copy

No objects are being moved but I’m not getting an error. Any ideas?

Will you pls share the values that are used in filename and copy??
if possible share your xaml

ExcelDocSearch.xaml (10.1 KB)

Hello
Do you want to check North keyword in entire excel ryt?
if yes then You can directly use LookUp Range so if that matches the keyword then
ExcelDocSearch.xaml (13.6 KB)

or if you want to search for each row then
ExcelDocSearch.xaml (10.4 KB)

Neither are working. But the first one worked much quicker.

Hope u get the idea make changes as per your need
Happy Automaion

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