Excel click activity


#1

Hey everyone I was wondering on how can I select a cell in excel with out selecting the entire table. I know click activity does not work and i tried recording with worked on my 2017 excel but not the 2010 excel. Open to any infor thanks!!


#2

you can use ctrl+G and specify the cell name it will take you to the particular cell and then Ctrl+A, Ctrl+c will copy the information(in excel). if it is the table you can specify the DataTable.item(colname).rows(rownumber).


#3

control G is not working


#4

Hello @kishanpatel728

use type into activity to type the cell address in “Name box” field (just above the Column A) with enter key like this:

celladdress.tostring & “[k(enter)]”
dont use simulate type, use either Send windows message or default


#5

click on name BOX and enter the cell Capturename -> this will take you to the particular cell


#6

are you passing capital G.? if yes, please use ctrl+g not capital G.


#7

Hi @kishanpatel728 - You can use Read cell activity to read the value of a cell from a Spreadsheet as a string.
image

Regards,
Nitesh