How to Create Pivot table using Invoke code Method?

Hi,
Please help me to create pivot table using invoke code method

regards
Priyanka

Hi @Priyanka_Jadhav1,

Please have a look into this sample code:
PivotTableVb.net.xaml (8.5 KB)

Sample Input:
Pivot_input.xlsx (10.6 KB)

Change the excel file path in invoke code activity and test it.

Thanks!

1 Like

Hi @kadiravan_kalidoss ,
After editing VB.net code how to save it. because (Ctrl+ S) not working

Regards
Priyanka

Click Ok on expression editor and save the main project using the Save button from the Ribbon

1 Like

Thank you @RAKESH_KUMAR_BEHERA

1 Like

thanks for quick solution @kadiravan_kalidoss

1 Like

Hi ,
Invalid index pop up occurred, please help me to fix that.

invalid_index

can you send the expected pivot table in excel? @Priyanka_Jadhav1

Hi @kadiravan_kalidoss
Expected output screenshot shared above.

Regards

@Priyanka_Jadhav1 In screenshot all columns and fields are not visible. Can you provide the excel file for more details.

Hi @kadiravan_kalidoss
Please help me to solve above issue.

Regards
Priyanka

Hi @Priyanka_Jadhav1,

PivotTableVb.net.xaml (14.4 KB)
Pivot_Input1.xlsx (27.8 KB)

Please update excel file path and range in invoke code activity and test it.

Thanks!

Hi @kadiravan_kalidoss
above code is good for .Xlsx file,but
Can I process it on .Xlsb file ?

Regards

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.