I want to search through excel files in a folder then copy them else where.
May I know what error are you getting here ?
Please add [for each row] for get data in your datatable
and try to use follwing condition
See as below for guideline
I hope it would be useful for you
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?
If you want to search anywhere in that excel THEN
yes then Move/Copy
Will you pls share the values that are used in filename and copy??
if possible share your xaml
ExcelDocSearch.xaml (10.1 KB)
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
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.