Click ACTVTY

[akheelahmad]

As a novice in UiPath, I’m currently working on a task involving Excel automation. My objective is to open an Excel file and select columns A and B for further processing, specifically applying conditional formatting (as illustrated in Pic 1). However, I’ve encountered a challenge in automating the selection of both columns simultaneously, akin to the manual method where we use the Ctrl key to select multiple columns.

I’ve attempted to address this by using the hotkey feature, but I’m still grappling with its implementation. Given my learning phase, I would greatly appreciate any guidance or assistance from those with expertise in this area.

[Anil_G (Anil Gorthi)]

@akheelahmad

Ideally you dont use ui automation for excel…you have dedicated activities for them …so please use excel related activities…for the list in activities search excel

read range will read the data into datatable which cna further be used

cheers

[akheelahmad]

I just use UiPath for personal use. So I have built a bot that’s gonna fetch important data from Chrome and then the last step is to compare the fetched data in Columns A and B so here I just wanna know how to select A and B (using ctrl) and move ahead with the click activities. So I don’t think I have to use Excel read range for this one. My fetching parts were perfectly done and I’m stuck at this one last step.

[AJ_Ask]

Hi @akheelahmad What is the end goal we have here, You want to highlight the duplicates or remove the duplicates for A & B colummn?

[akheelahmad]

Highlight duplicate. So I know how to do that manually but to do it automatically, I am finding it difficult to select 2 columns. In the second picture, I was doing it manually where I selected 2 columns.

[akheelahmad]

nvm, I pre-added the formula in my sheet so when the data enters the sheet, it’s gonna highlight automatically.