How to make pivot table in an excel spreadsheet uipath

Help
1

hi, how to make pivot table execution in an excel spreadsheet uipath

2

Hi,

You can send hot keys to make the pivot table (shortcut key - ALT + N + V + T + ENTER).

1 Like
3

i just tryd it but it does nnot work, here is the codeflow1.xaml (7.3 KB)

it says cannot write in hotkye

1 Like
4

any comment?

5

Abdel, manage to get anywhere with this? im trying to achieve the same thing (hotkeys would be good, would rather not use UI automation!)

6

Can you please tell ?How to do?

7

You can use to Click on the “Insert” tab by click Mouse. Then Click on the PIvot option my Click Image. (MS Office 7 )

8

You should small spell when using hot key activity.

9
2 Likes
10

hI ,

I have implemented this code but It is giving this error at Pivot cache statement as
“Type mismatch. (Exception from HRESULT: 0x80020005 (DISP_E_TYPEMISMATCH))”

It is occurring at line oPivotCache=CType(wb.PivotCaches().Add(Microsoft.Office.Interop.Excel.XlPivotTableSourceType.xlDatabase,rng),Microsoft.Office.Interop.Excel.PivotCache) in the given code

11

hI ,
Can you help me on this asap please?
I have implemented this code but It is giving this error at Pivot cache statement as
“Type mismatch. (Exception from HRESULT: 0x80020005 (DISP_E_TYPEMISMATCH))”

It is occurring at line oPivotCache=CType(wb.PivotCaches().Add(Microsoft.Office.Interop.Excel.XlPivotTableSourceType.xlDatabase,rng),Microsoft.Office.Interop.Excel.PivotCache) in the given code

12

thank you