Excel Column Double click

Help
, ,
1

Hi guys,

I want to double click column in excel file, but the selector is always change based on the zoom out/in of the file. and the robot cannot find the element. And also keep failing whenever I opened the new excel file. Is any way on how to solve it except for activity such as double click, anchor base, find element?

Thanks.

2

@Amin

After double clicking what you want to do.

1 Like
3

Hi @lakshman

the pop-up window opens after the double click, then fill some data onto the pop-up window. unfortunately, only the double click cell keeps failing.

1 Like
4

Did we try with CLICK IMAGE ACTIVITY where in the property panel set the property for click type as double

Cheers @Amin

1 Like
5

@Amin

Is the cell position fixed ? Or will it change every time ?

If you know the cell number before only then enter cell number in the top left corner and Hit enter using Type Into activity and then that pop up will open. And then use Attach Window Activity and indicate that pop up window put all activities inside of this to perform actions with in that window.

6

@lakshman

the excel cell will change depending on how the user displays the excel file since it has zoom in/out.
I already try with different zoom in/out cell, unfortunately, it fails.

7

Send hot key activity with any key combination to get that pop up will work in this either
Cheers @Amin

1 Like
8

@Amin

If possible could you please show me screenshot of that excel file where you want to click.

9

@lakshman

the yellow column that are needed to double click.

image
image849×447 90.2 KB

10

@Balupad14

Hope you are doing good.

Could you please help him @Amin.

2 Likes
11

Hi @lakshman,
Yes. I can help him,@Amin may know what is purpose with detail to double click the column ?

Regards
Balamurugan.S

1 Like
12

Hi @balupad14

the purpose of a double click cell is to fill in some data from the pdf file. the extract data from the pdf is then written onto the pop-up window after double click activity on the excel file.

13

Hi @Amin,

why don’t use the write cell activity. The double click is to do the function of edit cell . It is equal to write cell activity.

Regards
Balamurugan.S

14

hi @balupad14

I already try that part, its pop-up window to double click the cell.

15

Hi @Amin,
I am not able to image your situation. Can you please share sample excel , it would be great-full to give the solution.

Thank you
Balamurugan.S

16

Hi @balupad14

sorry for that part, I cannot give you the excel file since it related to some software, and I think u will need to install the software, only then u can open the full version excel file. I can only give you some pictures. I hope it helps.

image
image1240×594 142 KB