About Pivot table

Phoebe · November 19, 2021, 6:42am

hi everyone,

My excel data have 28 columns and 600 rows, I want to pivot it,
i use “create table” (A) and “create Pivot table”,
how can i only choice what i want item on specify position not all in the same chart?
Can anyone help me on this? thanks in advance

kirankumar.mahanthi1 · November 19, 2021, 8:30am

Hi,

Please find the Attached Code which i have used to implement the pivot table and there are lot of columns but i have selected some of the columns and used one function too.

Modify the code according to your requirement and use invoke code activity VB.net option to create pivot table in your excel. Try and let me know. Thanks.

Pivot Code.txt (2.7 KB)

Regards,

Kirankumar.

Cristian_Negulescu · November 25, 2021, 7:22pm

Hello Phoebe,
Here I have a Video with code of how I create Pivot Tabel:

Code:

github.com

cristinegulescu/startUiPathFromSalesforce/blob/master/VBAFile.vbs

Sub MyVBA()

Set PSheet = Worksheets("Rez2")
Set DSheet = Worksheets("Test")

'Define Data Range
LastRow = DSheet.Cells(Rows.Count, 1).End(xlUp).Row
LastCol = DSheet.Cells(1, Columns.Count).End(xlToLeft).Column
Set PRange = DSheet.Cells(1, 1).Resize(LastRow, LastCol)


'Define Pivot Cache
Set PCache = ActiveWorkbook.PivotCaches.Create _
(SourceType:=xlDatabase, SourceData:=PRange)


'Insert Blank Pivot Table
Set PTable = PCache.CreatePivotTable _
(TableDestination:=PSheet.Cells(1, 1), TableName:="RezPivot")
PTable.ClearTable

This file has been truncated. show original

Thanks,
Cristian

Topic		Replies	Views
Pivot table in excel Studio excel	1	890	February 8, 2022
VBA for pivot table Studio studio , question , activities_panel	4	763	August 22, 2022
Problem related to creating Pivot table by passing more than one row, column and value fields Activities excel , activities , question	1	630	November 25, 2021
Pivot Table Automation Studio studio , studiox , question , activities_panel	2	1144	November 25, 2021
Create Table and Create Pivot Table using specific columns Studio excel , uiautomation , activities , question	14	6634	March 6, 2020

Most Active Users - Yesterday
ashokkarale
anjani_priya
Dheerendra_vishwakarma
Parvathy
Aakash_Singh_Rawat
Luis_Fernando
bjorn2390
neco
pere
Shiva_Nikhil
More details...

About Pivot table

Related Topics