Sql query output and excel


#1

I want to paste the data from the result of query in sql server to an excel.Afterwards i need to filter that data in excel…So how to make automation of all this using uipath? Any earliest help would be much appreciable. Thanks.

Regards,
Asit


#2
  1. Sql Connect Activity
  2. Execute Query Activity --> Output to Datatable
    3)) Sql Disconnect Activity
  3. FIlter your Datatable (than in Excel)
  4. Write Range activity to Write to Excel. (you can filter here also)