I want to add filter to excel table. How may i do that?
I want it seems like that:
Use START PROCESS activity
And mention the file path of excel as input to Filename property
—this will open the file in foreground
—now use a send hot key activity with key as ctrl+g
—and use type into activity and mention the input as ”A1”
—now use a send hot key activity with key as enter
—then use a Send hot key activity with key as ctrl+shift+l
And this will add filter to all columns
thanks a lot but when i write ctrl+g in send hotkey, it doesnt work. am i writing it wrong?
Can you indicate the excel selector inside the hot key and ensure that you give g instead of G
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.