Excel search and export

Help StudioX
1

Hi guys,

I’m kinda new here therefore my apologies if my issue is an easy one.

I have an Excel file with about 700K lines and 18 columns.

I need to be able to create some interogations like the ones from Filter Data Table and to have the results written in another Excel file.

The scenario from my head would be Read Range - Filter Data Table - Write Range however, all my attempts have failed.

If somebody could help me with this, I would be really grateful.

Attached is the header of my file.

Thank you.

Excel export
Excel export1802×117 26.6 KB

2

@AlexB

As you have Excel File with 700K rows

Using Read Range will make more time to load all the rows

You can make Excel as a Database, steps will be as below

Once those were configured then use Connect, Execute query activies to perform your automation

Hope this helps you

Thanks