|
Set xlSheet = xlBook.Worksheets("透視表")
xlSheet.Activate
Set PC = xlApp.ActiveWorkbook.PivotCaches.Create(xlExternal)
Set PC.Recordset = rs
Set PT = xlApp.ActiveSheet.PivotTables.Add(PC, xlApp.ActiveSheet.Range("A1"), "透視")
With xlApp.ActiveSheet.PivotTables("透視")
.PivotFields("日期").Orientation = xlPageField
.PivotFields("公司簡稱").Orientation = xlRowField
.PivotFields("客戶名稱").Orientation = xlRowField
.PivotFields("供應商").Orientation = xlRowField
.PivotFields("供應商").Subtotals(1) = False
.PivotFields("發(fā)票號").Orientation = xlRowField
.PivotFields("商品名稱").Orientation = xlRowField
.PivotFields("商品名稱").Subtotals(1) = False
.PivotFields("顏色").Orientation = xlColumnField
.PivotFields("金額").Orientation = xlDataField
'明明設定的是美元貨幣,但在Excel上總是顯示人民幣符號¥,不知道為何?
.DataBodyRange.NumberFormat = "$#,##0.00;-$#,##0.00"
.RowAxisLayout xlCompactRow
.TableStyle2 = "PivotStyleMedium13"
' .ColumnGrand = False
' .RowGrand = False
End With
明明設定的是美元貨幣$,但在Excel上總是顯示人民幣符號¥,不知道為何?
|
本帖子中包含更多資源
您需要 登錄 才可以下載或查看,沒有帳號?注冊
x
|