Hi there,
The excel sheet is one element (grid) in itself. You can't select a single cell, but there is a way to click a cell with
mouse command.
All you have to do is define which pixels the robot should click in point section.
------------------------------
Mateusz Ryszawy
------------------------------
Original Message:
Sent: Wed May 11, 2022 11:30 PM
From: KARTHIK GUTTAPUDI
Subject: Record excel actions using recorder
Hi Team
I am trying to create to a pivot table in excel by recoding my actions using the recorder, I want to select the first cell (A1) and then click on "Insert" then "PivotTable"
When I run the script, it opens the excel but after that the selection/click doesn't work, it is not able to select/click the A1 cell in the excel.
This is my first time using the recorder, below is the script
defVar --name vNewExcelOne --type Excel
defVar --name vWindow --type Window
defVar --name vNewEXCEL_PROCESS --type Numeric
defVar --name vBaseWindow --type Window
defVar --name vBaseWindows --type Window
defVar --name vCreatePivotTableWindow --type Window
defVar --name vPivotPopValue --type String --value " \'All Orders Report\\\'!$A$1:$H$3043"
openFile --file "C:\\Users\\ZZ008G834\\Documents\\Planning_story_workspace\\New.xlsx" vNewEXCEL_PROCESS=value
delay --timeout "00:00:05"
launchOrAttach --executablepath "C:\\Program Files\\Microsoft Office\\Root\\Office16\\EXCEL.EXE" --title "New - Excel" --classname XLMAIN --processid ${vNewEXCEL_PROCESS} --processname EXCEL vBaseWindow=value
delay --timeout "00:00:03"
attachWindow --window ${vBaseWindow}
delay --timeout "00:00:02"
click --selector "XPath" --controlsimilarity 100 --simulatehuman --usetable --xpath "/root/pane[1]/pane[1]/pane[1]/datagrid[1]" --searchcolumn 1 --row 1
------------------------------
KARTHIK GUTTAPUDI
------------------------------