How To Add Filter Excel Table

[mazlumkacar (mazlum kaçar)]

Hi all,

I want to add filter to excel table. How may i do that?

I want it seems like that:

[Palaniyappan (Forum Leader)]

Hi
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

Cheers @mazlumkacar

[mazlumkacar (mazlum kaçar)]

thanks a lot but when i write ctrl+g in send hotkey, it doesnt work. am i writing it wrong?

@Palaniyappan

[AshwinS2 (Ashwin S)]

Hi @mazlumkacar

Can you indicate the excel selector inside the hot key and ensure that you give g instead of G

Thanks
Ashwin S