PivotTable.SubtotalLocation(XlSubtototalLocationType) PivotTable.SubtotalLocation(XlSubtototalLocationType) PivotTable.SubtotalLocation(XlSubtototalLocationType) Method

定義

このメソッドは、既存のすべての小計の場所を変更PivotFields This method changes the subtotal location for all existing PivotFields. 小計の場所を変更するアウトライン形式のフィールドだけで即時の視覚効果ですがフィールドを表形式にも設定されます。 Changing the subtotal location has an immediate visual effect only for fields in outline form, but it will be set for fields in tabular form as well.

public:
 void SubtotalLocation(Microsoft::Office::Interop::Excel::XlSubtototalLocationType Location);
public void SubtotalLocation (Microsoft.Office.Interop.Excel.XlSubtototalLocationType Location);
Public Sub SubtotalLocation (Location As XlSubtototalLocationType)

パラメーター

Location
XlSubtototalLocationType XlSubtototalLocationType XlSubtototalLocationType

必要なXlSubtototalLocationTypexlAtTopまたはxlAtBottomのいずれかにすることができます。 Required XlSubtototalLocationType can be either xlAtTop or xlAtBottom.

注釈

SubtotalLocation(XlSubtototalLocationType)メソッドのセット、LayoutSubtotalLocationのすべての既存のプロパティPivotFields に自動的にします。 The SubtotalLocation(XlSubtototalLocationType) method sets the LayoutSubtotalLocation property for all existing PivotFields automatically.

適用対象