Unanswered

Writing data to excel

(0) Share

Report

Posted on by CU27030743-0

Hi community,

I am new to PAD and i am working with excels.

I need to read data from an excel worksheet and then filter that data and then write the filtered data into another worksheet in the same excel. How can i achieve this? Please help

Categories:

Power Automate Desktop

I have the same question (0)

All responses (2)

Answers (0)

Sort by

VJR 7,635 on at

Like (0)

Report
Copy link

Link copied!

Hi @hrana4375

As of now no in-built features in PAD to filter data in spreadsheet.

Here are alternative options:
#1. Write a macro that filters this data and call this macro from PAD - Easiest

#2. Use "Read from Excel Worksheet" to read the data into a datatable and then loop through the table. Whenever a value is found that matches the filter criteria(s), then read that row from the table and write to another worksheet - Going to be time taking due to the looping particularly if there are large number of records. Would not recommend.

#3. Using Sendkeys on the Excel filter menus and buttons - should be the last resort. Sendkeys not always reliable.

Was this reply helpful? Yes No
XRQ57 206 on at

Like (0)

Report
Copy link

Link copied!

Hi
You can use Power Query too.
We don't know your all process so it's difficult to help you.
Is your filter always the same?

I don't think PAD is the best choice.

Was this reply helpful? Yes No