Stored hotkeys sedning From Excel issue

Help Activities
, ,
1

Hi Expert,

I have issue with Sending hotkeys which is stored in Excel.

Here is problem:
I have stored [k(down)][k(down)][k(down)][k(down)] in excel cell
This need to send in Web browser.

I have tried but it’s not working.

I have read data table from excel which already included hotkeys. And using this cell in sending hotkeys. But it doesn’t work.

Please help me out this problem.

2

@Karampuri_Sathish1

Can you share your workflow screenshot

Thanks

3

image
image482×580 12.4 KB

Work flow very long so i have small screenshot for understanding.

item(1).Tostring

4

@Karampuri_Sathish1

If you manually select down, so only one down key will be accepted.

image

So to execute multiple down you have to place multiple send Hotkey activities and pass only down

Also you can create a while loop inside that you can pass the hotkey

Hope this helps you

Thanks

5

Should i send from excel this hotkeys.

Can i write “down” in excel cell.
Is that work?

Thanks

6

Yes, just write down in excel cell and specify.

Thanks

7

I have tried that it is not working for me.

Any other way please suggest. or else any other check mark need to give

Thank you !

8

@Karampuri_Sathish1

Can you show me excel, did you use Read Range activity? and what you are passing in hotkey

Share the screenshot

Thanks

9

image

image
image733×448 10.6 KB

Initially i am using the read range activity and then i am using this column where required. Some cells required multiple downs required.

10

@Karampuri_Sathish1

After that place the For each row activity inside that give place send hotkey activity and type as row(“Scroll down”).ToString

This should work

Thanks

11

image

Is this correct?

It is not working. Any case senstive

12

@Karampuri_Sathish1

image
image1552×488 49.6 KB

You have to pass in key as above

This is working

image
image852×596 12.3 KB

Hope this helps you

Thanks