 |
| IXlsPivotTableOptions |
|
COM interface ( getting help with interfaces )
interface IXlsPivotTableOptions : IDispatch
{
[id(1),propput] HRESULT BuiltInPivotTableStyle([in]enumPivotTableStyle pivotTableStyle);
[id(2),propput] HRESULT CustomPivotTableStyle([in]BSTR customPivotTableStyleName);
[id(3),propget] HRESULT ShowRowHeaders([out, retval]BOOL* bShowRowHeaders);
[id(3),propput] HRESULT ShowRowHeaders([in]BOOL bShowRowHeaders);
[id(4),propget] HRESULT ShowColumnHeaders([out, retval]BOOL* bShowColumnHeaders);
[id(4),propput] HRESULT ShowColumnHeaders([in]BOOL bShowColumnHeaders);
[id(5),propget] HRESULT ShowRowStripes([out, retval]BOOL* bShowRowStripes);
[id(5),propput] HRESULT ShowRowStripes([in]BOOL bShowRowStripes);
[id(6),propget] HRESULT ShowColumnStripes([out, retval]BOOL* bShowColumnStripes);
[id(6),propput] HRESULT ShowColumnStripes([in]BOOL bShowColumnStripes);
[id(7),propput] HRESULT BuiltInPivotTableAutoFormat([in]enumPivotTableAutoFormat pivotTableAutoFormat);
[id(8),propget] HRESULT Layout([out, retval]enumPivotTableLayout* layout);
[id(8),propput] HRESULT Layout([in]enumPivotTableLayout layout);
[id(9),propget] HRESULT ShowExpandControls([out, retval]BOOL* bShowExpandControls);
[id(9),propput] HRESULT ShowExpandControls([in]BOOL bShowExpandControls);
[id(10),propget] HRESULT ResizeOnUpdate([out, retval]BOOL* bResizeOnUpdate);
[id(10),propput] HRESULT ResizeOnUpdate([in]BOOL bResizeOnUpdate);
[id(11),propget] HRESULT MergeItems([out, retval]BOOL* bMergeItems);
[id(11),propput] HRESULT MergeItems([in]BOOL bMergeItems);
[id(12),propget] HRESULT ShowGrandTotalsForRows([out, retval]BOOL* bShowGrandTotalRows);
[id(12),propput] HRESULT ShowGrandTotalsForRows([in]BOOL bShowGrandTotalRows);
[id(13),propget] HRESULT ShowGrandTotalsForColumns([out, retval]BOOL* bShowGrandTotalColumns);
[id(13),propput] HRESULT ShowGrandTotalsForColumns([in]BOOL bShowGrandTotalColumns);
[id(14),propget] HRESULT AutoRendering([out, retval]BOOL* bAutoRendering);
[id(14),propput] HRESULT AutoRendering([in]BOOL bAutoRendering);
[id(15),propget] HRESULT EnablePivotTableUI([out, retval]BOOL* bEnable);
[id(15),propput] HRESULT EnablePivotTableUI([in]BOOL bEnable);
[id(16),propget] HRESULT ShowDetails([out, retval]BOOL* bShow);
[id(16),propput] HRESULT ShowDetails([in]BOOL bShow);
[id(17),propget] HRESULT EnableFieldListUI([out, retval]BOOL* bEnable);
[id(17),propput] HRESULT EnableFieldListUI([in]BOOL bEnable);
[id(18),propget] HRESULT EnableFieldPropertiesUI([out, retval]BOOL* bEnable);
[id(18),propput] HRESULT EnableFieldPropertiesUI([in]BOOL bEnable);
[id(19),propget] HRESULT ShowFieldHeaders([out, retval]BOOL* bShow);
[id(19),propput] HRESULT ShowFieldHeaders([in]BOOL bShow);
}
HRESULT BuiltInPivotTableStyle([in]enumPivotTableStyle pivotTableStyle);
sets the pivot style (XLSX files) from one of the existing pivot table styles (85).
HRESULT CustomPivotTableStyle([in]BSTR customPivotTableStyleName);
sets a custom pivot style.
HRESULT ShowRowHeaders([out, retval]BOOL* bShowRowHeaders);
retrieves whether or not the row headers of the pivot table should show.
HRESULT ShowRowHeaders([in]BOOL bShowRowHeaders);
sets whether or not the row headers of the pivot table should show.
HRESULT ShowColumnHeaders([out, retval]BOOL* bShowColumnHeaders);
retrieves whether or not the column headers of the pivot table should show.
HRESULT ShowColumnHeaders([in]BOOL bShowColumnHeaders);
sets whether or not the column headers of the pivot table should show.
HRESULT ShowRowStripes([out, retval]BOOL* bShowRowStripes);
retrieves whether or not the row stripes of the pivot table should show.
HRESULT ShowRowStripes([in]BOOL bShowRowStripes);
sets whether or not the row stripes of the pivot table should show.
HRESULT ShowColumnStripes([out, retval]BOOL* bShowColumnStripes);
retrieves whether or not the column stripes of the pivot table should show.
HRESULT ShowColumnStripes([in]BOOL bShowColumnStripes);
sets whether or not the column stripes of the pivot table should show.
HRESULT BuiltInPivotTableAutoFormat([in]enumPivotTableAutoFormat pivotTableAutoFormat);
sets the pivot auto format (XLS files) from one of the existing pivot table auto formats.
HRESULT Layout([out, retval]enumPivotTableLayout* layout);
retrieves the pivot table layout among 3 choices : compact, outline and tabular. Default is : compact.
HRESULT Layout([in]enumPivotTableLayout layout);
sets the pivot table layout among 3 choices : compact, outline and tabular. Default is : compact.
HRESULT ShowExpandControls([out, retval]BOOL* bShowExpandControls);
retrieves whether or not the collapse/expand controls are displayed. Default is : true.
HRESULT ShowExpandControls([in]BOOL bShowExpandControls);
sets whether or not the collapse/expand controls are displayed. Default is : true.
HRESULT ResizeOnUpdate([out, retval]BOOL* bResizeOnUpdate);
retrieves whether or not the pivot table is resized (column widths, ...) on update events. Default is : true.
HRESULT ResizeOnUpdate([in]BOOL bResizeOnUpdate);
sets whether or not the pivot table is resized (column widths, ...) on update events. Default is : true.
HRESULT MergeItems([out, retval]BOOL* bMergeItems);
retrieves whether or not the items are displayed merged and centered. Default is : false.
HRESULT MergeItems([in]BOOL bMergeItems);
sets whether or not the items are displayed merged and centered. Default is : false.
HRESULT ShowGrandTotalsForRows([out, retval]BOOL* bShowGrandTotalRows);
retrieves whether or not the totals for rows are displayed. Default is : true.
HRESULT ShowGrandTotalsForRows([in]BOOL bShowGrandTotalRows);
sets whether or not the totals for rows are displayed. Default is : true.
HRESULT ShowGrandTotalsForColumns([out, retval]BOOL* bShowGrandTotalColumns);
retrieves whether or not the totals for columns are displayed. Default is : true.
HRESULT ShowGrandTotalsForColumns([in]BOOL bShowGrandTotalColumns);
sets whether or not the totals for columns are displayed. Default is : true.
HRESULT AutoRendering([out, retval]BOOL* bAutoRendering);
retrieves whether or not the pivot table should be calculated and rendered on save. Default is : false
HRESULT AutoRendering([in]BOOL bAutoRendering);
sets whether or not the pivot table should be calculated and rendered on save. Default is : false
HRESULT EnablePivotTableUI([out, retval]BOOL* bEnable);
retrieves whether or not the pivot table user interface should show in Excel. Default is : true
HRESULT EnablePivotTableUI([in]BOOL bEnable);
sets whether or not the pivot table user interface should show in Excel. Default is : true
HRESULT ShowDetails([out, retval]BOOL* bShow);
retrieves whether or not the pivot table should show drill down details. Default is : true
HRESULT ShowDetails([in]BOOL bShow);
sets whether or not the pivot table should show drill down details. Default is : true
HRESULT EnableFieldListUI([out, retval]BOOL* bEnable);
retrieves whether or not the pivot table should show the field list user interface in Excel. Default is : true
HRESULT EnableFieldListUI([in]BOOL bEnable);
sets whether or not the pivot table should show the field list user interface in Excel. Default is : true
HRESULT EnableFieldPropertiesUI([out, retval]BOOL* bEnable);
retrieves whether or not the pivot table should show field properties in Excel. Default is : true
HRESULT EnableFieldPropertiesUI([in]BOOL bEnable);
sets whether or not the pivot table should show field properties in Excel. Default is : true
HRESULT ShowFieldHeaders([out, retval]BOOL* bShow);
retrieves whether or not the pivot table should show field headers. Default is : true
HRESULT ShowFieldHeaders([in]BOOL bShow);
sets whether or not the pivot table should show field headers. Default is : true