200分高分求解翻译以下VBA代码,不知道该怎么翻译成DELPHI语言? ActiveSheet.PivotTableWizard SourceType:=xlPivotTable, SourceData:="数据透视表1" _
, TableDestination:="[Lkady.xls]第3题!R10C8", TableName:="数据透视表2"
ActiveSheet.PivotTables("数据透视表2").SmallGrid = False
With ActiveSheet.PivotTables("数据透视表2").PivotFields("性别")
.Orientation = xlColumnField
.Position = 1
End With
With ActiveSheet.PivotTables("数据透视表2").PivotFields("职称")
.Orientation = xlRowField
.Position = 1
End With
With ActiveSheet.PivotTables("数据透视表2").PivotFields("基本工资")
.Orientation = xlDataField
.Position = 1
End With
Range("H10").Select
ActiveSheet.PivotTables("数据透视表2").PivotFields("求和项:基本工资").Function = xlMin
Application.CommandBars("PivotTable").Visible = False
End Sub
特别是PivotTableWizard SourceType在DELPHI中是用什么代码表示?
, TableDestination:="[Lkady.xls]第3题!R10C8", TableName:="数据透视表2"
ActiveSheet.PivotTables("数据透视表2").SmallGrid = False
With ActiveSheet.PivotTables("数据透视表2").PivotFields("性别")
.Orientation = xlColumnField
.Position = 1
End With
With ActiveSheet.PivotTables("数据透视表2").PivotFields("职称")
.Orientation = xlRowField
.Position = 1
End With
With ActiveSheet.PivotTables("数据透视表2").PivotFields("基本工资")
.Orientation = xlDataField
.Position = 1
End With
Range("H10").Select
ActiveSheet.PivotTables("数据透视表2").PivotFields("求和项:基本工资").Function = xlMin
Application.CommandBars("PivotTable").Visible = False
End Sub
特别是PivotTableWizard SourceType在DELPHI中是用什么代码表示?
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货