Double click on Excel Pivot total cell

Help Studio
, , ,
1

Anyone can tell me,
i have one excel dashbord in that the sheet pivots have multiple columns one is Estimate repair date pending i have to double click on grand total side 166 cell then open new exceland copy that data to new excel

image

image

like estimate repair date pending i have 3 columns in pivote table which have column name differnt but double click on grand total side cell

2

Hi @yogitagaikwad2206

You can use the find / Replace activity and get the cell value of the Grand Total.
After getting the cell value extract the alphabet’s from that value and convert that to a number using the below syntax:

UiPath.Excel.Helpers.ExcelUtilities.ConvertColumnLetterToColumnIndex(Your column Alphabets)

later add one to the converted number and again convert that to the alphabet’s again using the below syntax:

UiPath.Excel.Helpers.ExcelUtilities.ConvertColumnIndexToColumnLetter(Your New value)

Now add the number extracted from the find / Replace activity to the new value and store that in a variable.

Pass that variable into the click activity and is should work!!

Regards

3

can u plz share workflow for this

4

Can you please share an excel file @yogitagaikwad2206

Regards

5

sry, i can’t share excel file can u plz send sample code for this

6

Okay sure I will update the code please give me sometime @yogitagaikwad2206

Regards