这是一个手工录制的数据透视表的宏,想通过delphi 代码来操作EXCEL 达到执行该宏的效果.请问该如何写呢?Sub Macro1()
' ActiveWorkbook.PivotCaches.Add(SourceType:=xlDatabase, SourceData:= _
"'832006'!R1C1:R99C14").CreatePivotTable TableDestination:="", TableName:= _
"数据透视表1", DefaultVersion:=xlPivotTableVersion10
ActiveSheet.PivotTableWizard TableDestination:=ActiveSheet.Cells(3, 1)
ActiveSheet.Cells(3, 1).Select
ActiveWorkbook.ShowPivotTableFieldList = True
With ActiveSheet.PivotTables("数据透视表1").PivotFields("公司")
.Orientation = xlRowField
.Position = 1
End With
With ActiveSheet.PivotTables("数据透视表1").PivotFields("代码")
.Orientation = xlRowField
.Position = 2
End With
With ActiveSheet.PivotTables("数据透视表1").PivotFields("名称")
.Orientation = xlRowField
.Position = 3
End With
With ActiveSheet.PivotTables("数据透视表1").PivotFields("类型")
.Orientation = xlColumnField
.Position = 1
End With
With ActiveSheet.PivotTables("数据透视表1").PivotFields("舱位编码")
.Orientation = xlColumnField
.Position = 2
End With
ActiveSheet.PivotTables("数据透视表1").AddDataField ActiveSheet.PivotTables("数据透视表1" _
).PivotFields("金额"), "求和项:金额", xlSum
ActiveSheet.PivotTables("数据透视表1").AddDataField ActiveSheet.PivotTables("数据透视表1" _
).PivotFields("费用"), "求和项:费用", xlSum
End Sub
' ActiveWorkbook.PivotCaches.Add(SourceType:=xlDatabase, SourceData:= _
"'832006'!R1C1:R99C14").CreatePivotTable TableDestination:="", TableName:= _
"数据透视表1", DefaultVersion:=xlPivotTableVersion10
ActiveSheet.PivotTableWizard TableDestination:=ActiveSheet.Cells(3, 1)
ActiveSheet.Cells(3, 1).Select
ActiveWorkbook.ShowPivotTableFieldList = True
With ActiveSheet.PivotTables("数据透视表1").PivotFields("公司")
.Orientation = xlRowField
.Position = 1
End With
With ActiveSheet.PivotTables("数据透视表1").PivotFields("代码")
.Orientation = xlRowField
.Position = 2
End With
With ActiveSheet.PivotTables("数据透视表1").PivotFields("名称")
.Orientation = xlRowField
.Position = 3
End With
With ActiveSheet.PivotTables("数据透视表1").PivotFields("类型")
.Orientation = xlColumnField
.Position = 1
End With
With ActiveSheet.PivotTables("数据透视表1").PivotFields("舱位编码")
.Orientation = xlColumnField
.Position = 2
End With
ActiveSheet.PivotTables("数据透视表1").AddDataField ActiveSheet.PivotTables("数据透视表1" _
).PivotFields("金额"), "求和项:金额", xlSum
ActiveSheet.PivotTables("数据透视表1").AddDataField ActiveSheet.PivotTables("数据透视表1" _
).PivotFields("费用"), "求和项:费用", xlSum
End Sub
解决方案 »
- 百分求 delphi 登录系统
- 请教:在业务模块中,关于订单类(用oo)大家是怎么做的?着急!
- 刚刚看的sina新闻:公务员强制带薪休假,居然还有休假补贴
- 如何学好与精通Dilphi?
- 请问那有 TreeView 和 CheckListBox 和为一体的控件下载??
- 高手请进
- 怎样用DELPHI6取得win9x,win2k,winxp的系统硬件信息!!!,急急。。。
- delphi的常量变量、对象在内存中的存放有什么不同?
- 关于程序移植的问题,有高分哦!
- 向Delphi高手咨询
- delphi 操作网页onclick按钮
- TDBChart的DataSource用Summary时,Group by遇NULL会有问题?
http://www.delphibbs.com/keylife/iblog_show.asp?xid=27039