Pivot table in excel

I have a work book and need to create pivot on one of the sheet. The sheet has a lot of columns. Pivot table should have data as : Rows = column1 and Values = Sum of (value in column 7).

I need to design it in Studio… I checked the create pivot table activity. But it doesn’t seems to be useful. The excel data is not in “Table”.

Please guide me for possible solution.

Hi @pandeypriyanka1312 ,

In that case we can use invoke code activity and insert vb code to create pivot table and also we can perform sum values for multiple column and also format the data. Please have view on below my post it is having sample vb code to create pivot table in excel. I hope it might helpful for your requirement. Thanks.