net.rgielen.com4j.office2010.excel.PivotTable Maven / Gradle / Ivy
package net.rgielen.com4j.office2010.excel ;
import com4j.*;
@IID("{00020400-0000-0000-C000-000000000046}")
public interface PivotTable extends Com4jObject {
// Methods:
/**
*
* Getter method for the COM property "Application"
*
*/
@DISPID(148)
@PropGet
net.rgielen.com4j.office2010.excel._Application application();
/**
*
* Getter method for the COM property "Creator"
*
*/
@DISPID(149)
@PropGet
net.rgielen.com4j.office2010.excel.XlCreator creator();
/**
*
* Getter method for the COM property "Parent"
*
*/
@DISPID(150)
@PropGet
com4j.Com4jObject parent();
/**
* @param rowFields Optional parameter. Default value is com4j.Variant.getMissing()
* @param columnFields Optional parameter. Default value is com4j.Variant.getMissing()
* @param pageFields Optional parameter. Default value is com4j.Variant.getMissing()
* @param addToTable Optional parameter. Default value is com4j.Variant.getMissing()
*/
@DISPID(708)
java.lang.Object addFields(
@Optional java.lang.Object rowFields,
@Optional java.lang.Object columnFields,
@Optional java.lang.Object pageFields,
@Optional java.lang.Object addToTable);
/**
*
* Getter method for the COM property "ColumnFields"
*
* @param index Optional parameter. Default value is com4j.Variant.getMissing()
*/
@DISPID(713)
@PropGet
com4j.Com4jObject columnFields(
@Optional java.lang.Object index);
/**
*
* Getter method for the COM property "ColumnGrand"
*
*/
@DISPID(694)
@PropGet
boolean columnGrand();
/**
*
* Setter method for the COM property "ColumnGrand"
*
* @param rhs Mandatory boolean parameter.
*/
@DISPID(694)
@PropPut
void columnGrand(
boolean rhs);
/**
*
* Getter method for the COM property "ColumnRange"
*
*/
@DISPID(702)
@PropGet
net.rgielen.com4j.office2010.excel.Range columnRange();
/**
* @param pageField Optional parameter. Default value is com4j.Variant.getMissing()
*/
@DISPID(706)
java.lang.Object showPages(
@Optional java.lang.Object pageField);
/**
*
* Getter method for the COM property "DataBodyRange"
*
*/
@DISPID(705)
@PropGet
net.rgielen.com4j.office2010.excel.Range dataBodyRange();
/**
*
* Getter method for the COM property "DataFields"
*
* @param index Optional parameter. Default value is com4j.Variant.getMissing()
*/
@DISPID(715)
@PropGet
com4j.Com4jObject dataFields(
@Optional java.lang.Object index);
/**
*
* Getter method for the COM property "DataLabelRange"
*
*/
@DISPID(704)
@PropGet
net.rgielen.com4j.office2010.excel.Range dataLabelRange();
/**
*
* Getter method for the COM property "_Default"
*
*/
@DISPID(0)
@PropGet
@DefaultMethod
java.lang.String _Default();
/**
*
* Setter method for the COM property "_Default"
*
* @param rhs Mandatory java.lang.String parameter.
*/
@DISPID(0)
@PropPut
@DefaultMethod
void _Default(
java.lang.String rhs);
/**
*
* Getter method for the COM property "HasAutoFormat"
*
*/
@DISPID(695)
@PropGet
boolean hasAutoFormat();
/**
*
* Setter method for the COM property "HasAutoFormat"
*
* @param rhs Mandatory boolean parameter.
*/
@DISPID(695)
@PropPut
void hasAutoFormat(
boolean rhs);
/**
*
* Getter method for the COM property "HiddenFields"
*
* @param index Optional parameter. Default value is com4j.Variant.getMissing()
*/
@DISPID(711)
@PropGet
com4j.Com4jObject hiddenFields(
@Optional java.lang.Object index);
/**
*
* Getter method for the COM property "InnerDetail"
*
*/
@DISPID(698)
@PropGet
java.lang.String innerDetail();
/**
*
* Setter method for the COM property "InnerDetail"
*
* @param rhs Mandatory java.lang.String parameter.
*/
@DISPID(698)
@PropPut
void innerDetail(
java.lang.String rhs);
/**
*
* Getter method for the COM property "Name"
*
*/
@DISPID(110)
@PropGet
java.lang.String name();
/**
*
* Setter method for the COM property "Name"
*
* @param rhs Mandatory java.lang.String parameter.
*/
@DISPID(110)
@PropPut
void name(
java.lang.String rhs);
/**
*
* Getter method for the COM property "PageFields"
*
* @param index Optional parameter. Default value is com4j.Variant.getMissing()
*/
@DISPID(714)
@PropGet
com4j.Com4jObject pageFields(
@Optional java.lang.Object index);
/**
*
* Getter method for the COM property "PageRange"
*
*/
@DISPID(703)
@PropGet
net.rgielen.com4j.office2010.excel.Range pageRange();
/**
*
* Getter method for the COM property "PageRangeCells"
*
*/
@DISPID(1482)
@PropGet
net.rgielen.com4j.office2010.excel.Range pageRangeCells();
/**
* @param index Optional parameter. Default value is com4j.Variant.getMissing()
*/
@DISPID(718)
com4j.Com4jObject pivotFields(
@Optional java.lang.Object index);
/**
*
* Getter method for the COM property "RefreshDate"
*
*/
@DISPID(696)
@PropGet
java.util.Date refreshDate();
/**
*
* Getter method for the COM property "RefreshName"
*
*/
@DISPID(697)
@PropGet
java.lang.String refreshName();
/**
*/
@DISPID(717)
boolean refreshTable();
/**
*
* Getter method for the COM property "RowFields"
*
* @param index Optional parameter. Default value is com4j.Variant.getMissing()
*/
@DISPID(712)
@PropGet
com4j.Com4jObject rowFields(
@Optional java.lang.Object index);
/**
*
* Getter method for the COM property "RowGrand"
*
*/
@DISPID(693)
@PropGet
boolean rowGrand();
/**
*
* Setter method for the COM property "RowGrand"
*
* @param rhs Mandatory boolean parameter.
*/
@DISPID(693)
@PropPut
void rowGrand(
boolean rhs);
/**
*
* Getter method for the COM property "RowRange"
*
*/
@DISPID(701)
@PropGet
net.rgielen.com4j.office2010.excel.Range rowRange();
/**
*
* Getter method for the COM property "SaveData"
*
*/
@DISPID(692)
@PropGet
boolean saveData();
/**
*
* Setter method for the COM property "SaveData"
*
* @param rhs Mandatory boolean parameter.
*/
@DISPID(692)
@PropPut
void saveData(
boolean rhs);
/**
*
* Getter method for the COM property "SourceData"
*
*/
@DISPID(686)
@PropGet
java.lang.Object sourceData();
/**
*
* Setter method for the COM property "SourceData"
*
* @param rhs Mandatory java.lang.Object parameter.
*/
@DISPID(686)
@PropPut
void sourceData(
java.lang.Object rhs);
/**
*
* Getter method for the COM property "TableRange1"
*
*/
@DISPID(699)
@PropGet
net.rgielen.com4j.office2010.excel.Range tableRange1();
/**
*
* Getter method for the COM property "TableRange2"
*
*/
@DISPID(700)
@PropGet
net.rgielen.com4j.office2010.excel.Range tableRange2();
/**
*
* Getter method for the COM property "Value"
*
*/
@DISPID(6)
@PropGet
java.lang.String value();
/**
*
* Setter method for the COM property "Value"
*
* @param rhs Mandatory java.lang.String parameter.
*/
@DISPID(6)
@PropPut
void value(
java.lang.String rhs);
/**
*
* Getter method for the COM property "VisibleFields"
*
* @param index Optional parameter. Default value is com4j.Variant.getMissing()
*/
@DISPID(710)
@PropGet
com4j.Com4jObject visibleFields(
@Optional java.lang.Object index);
/**
*
* Getter method for the COM property "CacheIndex"
*
*/
@DISPID(1483)
@PropGet
int cacheIndex();
/**
*
* Setter method for the COM property "CacheIndex"
*
* @param rhs Mandatory int parameter.
*/
@DISPID(1483)
@PropPut
void cacheIndex(
int rhs);
/**
*/
@DISPID(1484)
net.rgielen.com4j.office2010.excel.CalculatedFields calculatedFields();
/**
*
* Getter method for the COM property "DisplayErrorString"
*
*/
@DISPID(1485)
@PropGet
boolean displayErrorString();
/**
*
* Setter method for the COM property "DisplayErrorString"
*
* @param rhs Mandatory boolean parameter.
*/
@DISPID(1485)
@PropPut
void displayErrorString(
boolean rhs);
/**
*
* Getter method for the COM property "DisplayNullString"
*
*/
@DISPID(1486)
@PropGet
boolean displayNullString();
/**
*
* Setter method for the COM property "DisplayNullString"
*
* @param rhs Mandatory boolean parameter.
*/
@DISPID(1486)
@PropPut
void displayNullString(
boolean rhs);
/**
*
* Getter method for the COM property "EnableDrilldown"
*
*/
@DISPID(1487)
@PropGet
boolean enableDrilldown();
/**
*
* Setter method for the COM property "EnableDrilldown"
*
* @param rhs Mandatory boolean parameter.
*/
@DISPID(1487)
@PropPut
void enableDrilldown(
boolean rhs);
/**
*
* Getter method for the COM property "EnableFieldDialog"
*
*/
@DISPID(1488)
@PropGet
boolean enableFieldDialog();
/**
*
* Setter method for the COM property "EnableFieldDialog"
*
* @param rhs Mandatory boolean parameter.
*/
@DISPID(1488)
@PropPut
void enableFieldDialog(
boolean rhs);
/**
*
* Getter method for the COM property "EnableWizard"
*
*/
@DISPID(1489)
@PropGet
boolean enableWizard();
/**
*
* Setter method for the COM property "EnableWizard"
*
* @param rhs Mandatory boolean parameter.
*/
@DISPID(1489)
@PropPut
void enableWizard(
boolean rhs);
/**
*
* Getter method for the COM property "ErrorString"
*
*/
@DISPID(1490)
@PropGet
java.lang.String errorString();
/**
*
* Setter method for the COM property "ErrorString"
*
* @param rhs Mandatory java.lang.String parameter.
*/
@DISPID(1490)
@PropPut
void errorString(
java.lang.String rhs);
/**
* @param name Mandatory java.lang.String parameter.
*/
@DISPID(1491)
double getData(
java.lang.String name);
/**
*/
@DISPID(1492)
void listFormulas();
/**
*
* Getter method for the COM property "ManualUpdate"
*
*/
@DISPID(1493)
@PropGet
boolean manualUpdate();
/**
*
* Setter method for the COM property "ManualUpdate"
*
* @param rhs Mandatory boolean parameter.
*/
@DISPID(1493)
@PropPut
void manualUpdate(
boolean rhs);
/**
*
* Getter method for the COM property "MergeLabels"
*
*/
@DISPID(1494)
@PropGet
boolean mergeLabels();
/**
*
* Setter method for the COM property "MergeLabels"
*
* @param rhs Mandatory boolean parameter.
*/
@DISPID(1494)
@PropPut
void mergeLabels(
boolean rhs);
/**
*
* Getter method for the COM property "NullString"
*
*/
@DISPID(1495)
@PropGet
java.lang.String nullString();
/**
*
* Setter method for the COM property "NullString"
*
* @param rhs Mandatory java.lang.String parameter.
*/
@DISPID(1495)
@PropPut
void nullString(
java.lang.String rhs);
/**
*/
@DISPID(1496)
net.rgielen.com4j.office2010.excel.PivotCache pivotCache();
/**
*
* Getter method for the COM property "PivotFormulas"
*
*/
@DISPID(1497)
@PropGet
net.rgielen.com4j.office2010.excel.PivotFormulas pivotFormulas();
/**
* @param sourceType Optional parameter. Default value is com4j.Variant.getMissing()
* @param sourceData Optional parameter. Default value is com4j.Variant.getMissing()
* @param tableDestination Optional parameter. Default value is com4j.Variant.getMissing()
* @param tableName Optional parameter. Default value is com4j.Variant.getMissing()
* @param rowGrand Optional parameter. Default value is com4j.Variant.getMissing()
* @param columnGrand Optional parameter. Default value is com4j.Variant.getMissing()
* @param saveData Optional parameter. Default value is com4j.Variant.getMissing()
* @param hasAutoFormat Optional parameter. Default value is com4j.Variant.getMissing()
* @param autoPage Optional parameter. Default value is com4j.Variant.getMissing()
* @param reserved Optional parameter. Default value is com4j.Variant.getMissing()
* @param backgroundQuery Optional parameter. Default value is com4j.Variant.getMissing()
* @param optimizeCache Optional parameter. Default value is com4j.Variant.getMissing()
* @param pageFieldOrder Optional parameter. Default value is com4j.Variant.getMissing()
* @param pageFieldWrapCount Optional parameter. Default value is com4j.Variant.getMissing()
* @param readData Optional parameter. Default value is com4j.Variant.getMissing()
* @param connection Optional parameter. Default value is com4j.Variant.getMissing()
*/
@DISPID(684)
void pivotTableWizard(
@Optional java.lang.Object sourceType,
@Optional java.lang.Object sourceData,
@Optional java.lang.Object tableDestination,
@Optional java.lang.Object tableName,
@Optional java.lang.Object rowGrand,
@Optional java.lang.Object columnGrand,
@Optional java.lang.Object saveData,
@Optional java.lang.Object hasAutoFormat,
@Optional java.lang.Object autoPage,
@Optional java.lang.Object reserved,
@Optional java.lang.Object backgroundQuery,
@Optional java.lang.Object optimizeCache,
@Optional java.lang.Object pageFieldOrder,
@Optional java.lang.Object pageFieldWrapCount,
@Optional java.lang.Object readData,
@Optional java.lang.Object connection);
/**
*
* Getter method for the COM property "SubtotalHiddenPageItems"
*
*/
@DISPID(1498)
@PropGet
boolean subtotalHiddenPageItems();
/**
*
* Setter method for the COM property "SubtotalHiddenPageItems"
*
* @param rhs Mandatory boolean parameter.
*/
@DISPID(1498)
@PropPut
void subtotalHiddenPageItems(
boolean rhs);
/**
*
* Getter method for the COM property "PageFieldOrder"
*
*/
@DISPID(1429)
@PropGet
int pageFieldOrder();
/**
*
* Setter method for the COM property "PageFieldOrder"
*
* @param rhs Mandatory int parameter.
*/
@DISPID(1429)
@PropPut
void pageFieldOrder(
int rhs);
/**
*
* Getter method for the COM property "PageFieldStyle"
*
*/
@DISPID(1499)
@PropGet
java.lang.String pageFieldStyle();
/**
*
* Setter method for the COM property "PageFieldStyle"
*
* @param rhs Mandatory java.lang.String parameter.
*/
@DISPID(1499)
@PropPut
void pageFieldStyle(
java.lang.String rhs);
/**
*
* Getter method for the COM property "PageFieldWrapCount"
*
*/
@DISPID(1430)
@PropGet
int pageFieldWrapCount();
/**
*
* Setter method for the COM property "PageFieldWrapCount"
*
* @param rhs Mandatory int parameter.
*/
@DISPID(1430)
@PropPut
void pageFieldWrapCount(
int rhs);
/**
*
* Getter method for the COM property "PreserveFormatting"
*
*/
@DISPID(1500)
@PropGet
boolean preserveFormatting();
/**
*
* Setter method for the COM property "PreserveFormatting"
*
* @param rhs Mandatory boolean parameter.
*/
@DISPID(1500)
@PropPut
void preserveFormatting(
boolean rhs);
/**
* @param name Mandatory java.lang.String parameter.
* @param mode Optional parameter. Default value is 0
*/
@DISPID(2087)
void _PivotSelect(
java.lang.String name,
@Optional @DefaultValue("0") net.rgielen.com4j.office2010.excel.XlPTSelectionMode mode);
/**
*
* Getter method for the COM property "PivotSelection"
*
*/
@DISPID(1502)
@PropGet
java.lang.String pivotSelection();
/**
*
* Setter method for the COM property "PivotSelection"
*
* @param rhs Mandatory java.lang.String parameter.
*/
@DISPID(1502)
@PropPut
void pivotSelection(
java.lang.String rhs);
/**
*
* Getter method for the COM property "SelectionMode"
*
*/
@DISPID(1503)
@PropGet
net.rgielen.com4j.office2010.excel.XlPTSelectionMode selectionMode();
/**
*
* Setter method for the COM property "SelectionMode"
*
* @param rhs Mandatory net.rgielen.com4j.office2010.excel.XlPTSelectionMode parameter.
*/
@DISPID(1503)
@PropPut
void selectionMode(
net.rgielen.com4j.office2010.excel.XlPTSelectionMode rhs);
/**
*
* Getter method for the COM property "TableStyle"
*
*/
@DISPID(1504)
@PropGet
java.lang.String tableStyle();
/**
*
* Setter method for the COM property "TableStyle"
*
* @param rhs Mandatory java.lang.String parameter.
*/
@DISPID(1504)
@PropPut
void tableStyle(
java.lang.String rhs);
/**
*
* Getter method for the COM property "Tag"
*
*/
@DISPID(1505)
@PropGet
java.lang.String tag();
/**
*
* Setter method for the COM property "Tag"
*
* @param rhs Mandatory java.lang.String parameter.
*/
@DISPID(1505)
@PropPut
void tag(
java.lang.String rhs);
/**
*/
@DISPID(680)
void update();
/**
*
* Getter method for the COM property "VacatedStyle"
*
*/
@DISPID(1506)
@PropGet
java.lang.String vacatedStyle();
/**
*
* Setter method for the COM property "VacatedStyle"
*
* @param rhs Mandatory java.lang.String parameter.
*/
@DISPID(1506)
@PropPut
void vacatedStyle(
java.lang.String rhs);
/**
* @param format Mandatory net.rgielen.com4j.office2010.excel.XlPivotFormatType parameter.
*/
@DISPID(116)
void format(
net.rgielen.com4j.office2010.excel.XlPivotFormatType format);
/**
*
* Getter method for the COM property "PrintTitles"
*
*/
@DISPID(1838)
@PropGet
boolean printTitles();
/**
*
* Setter method for the COM property "PrintTitles"
*
* @param rhs Mandatory boolean parameter.
*/
@DISPID(1838)
@PropPut
void printTitles(
boolean rhs);
/**
*
* Getter method for the COM property "CubeFields"
*
*/
@DISPID(1839)
@PropGet
net.rgielen.com4j.office2010.excel.CubeFields cubeFields();
/**
*
* Getter method for the COM property "GrandTotalName"
*
*/
@DISPID(1840)
@PropGet
java.lang.String grandTotalName();
/**
*
* Setter method for the COM property "GrandTotalName"
*
* @param rhs Mandatory java.lang.String parameter.
*/
@DISPID(1840)
@PropPut
void grandTotalName(
java.lang.String rhs);
/**
*
* Getter method for the COM property "SmallGrid"
*
*/
@DISPID(1841)
@PropGet
boolean smallGrid();
/**
*
* Setter method for the COM property "SmallGrid"
*
* @param rhs Mandatory boolean parameter.
*/
@DISPID(1841)
@PropPut
void smallGrid(
boolean rhs);
/**
*
* Getter method for the COM property "RepeatItemsOnEachPrintedPage"
*
*/
@DISPID(1842)
@PropGet
boolean repeatItemsOnEachPrintedPage();
/**
*
* Setter method for the COM property "RepeatItemsOnEachPrintedPage"
*
* @param rhs Mandatory boolean parameter.
*/
@DISPID(1842)
@PropPut
void repeatItemsOnEachPrintedPage(
boolean rhs);
/**
*
* Getter method for the COM property "TotalsAnnotation"
*
*/
@DISPID(1843)
@PropGet
boolean totalsAnnotation();
/**
*
* Setter method for the COM property "TotalsAnnotation"
*
* @param rhs Mandatory boolean parameter.
*/
@DISPID(1843)
@PropPut
void totalsAnnotation(
boolean rhs);
/**
* @param name Mandatory java.lang.String parameter.
* @param mode Optional parameter. Default value is 0
* @param useStandardName Optional parameter. Default value is com4j.Variant.getMissing()
*/
@DISPID(1501)
void pivotSelect(
java.lang.String name,
@Optional @DefaultValue("0") net.rgielen.com4j.office2010.excel.XlPTSelectionMode mode,
@Optional java.lang.Object useStandardName);
/**
*
* Getter method for the COM property "PivotSelectionStandard"
*
*/
@DISPID(2089)
@PropGet
java.lang.String pivotSelectionStandard();
/**
*
* Setter method for the COM property "PivotSelectionStandard"
*
* @param rhs Mandatory java.lang.String parameter.
*/
@DISPID(2089)
@PropPut
void pivotSelectionStandard(
java.lang.String rhs);
/**
* @param dataField Optional parameter. Default value is com4j.Variant.getMissing()
* @param field1 Optional parameter. Default value is com4j.Variant.getMissing()
* @param item1 Optional parameter. Default value is com4j.Variant.getMissing()
* @param field2 Optional parameter. Default value is com4j.Variant.getMissing()
* @param item2 Optional parameter. Default value is com4j.Variant.getMissing()
* @param field3 Optional parameter. Default value is com4j.Variant.getMissing()
* @param item3 Optional parameter. Default value is com4j.Variant.getMissing()
* @param field4 Optional parameter. Default value is com4j.Variant.getMissing()
* @param item4 Optional parameter. Default value is com4j.Variant.getMissing()
* @param field5 Optional parameter. Default value is com4j.Variant.getMissing()
* @param item5 Optional parameter. Default value is com4j.Variant.getMissing()
* @param field6 Optional parameter. Default value is com4j.Variant.getMissing()
* @param item6 Optional parameter. Default value is com4j.Variant.getMissing()
* @param field7 Optional parameter. Default value is com4j.Variant.getMissing()
* @param item7 Optional parameter. Default value is com4j.Variant.getMissing()
* @param field8 Optional parameter. Default value is com4j.Variant.getMissing()
* @param item8 Optional parameter. Default value is com4j.Variant.getMissing()
* @param field9 Optional parameter. Default value is com4j.Variant.getMissing()
* @param item9 Optional parameter. Default value is com4j.Variant.getMissing()
* @param field10 Optional parameter. Default value is com4j.Variant.getMissing()
* @param item10 Optional parameter. Default value is com4j.Variant.getMissing()
* @param field11 Optional parameter. Default value is com4j.Variant.getMissing()
* @param item11 Optional parameter. Default value is com4j.Variant.getMissing()
* @param field12 Optional parameter. Default value is com4j.Variant.getMissing()
* @param item12 Optional parameter. Default value is com4j.Variant.getMissing()
* @param field13 Optional parameter. Default value is com4j.Variant.getMissing()
* @param item13 Optional parameter. Default value is com4j.Variant.getMissing()
* @param field14 Optional parameter. Default value is com4j.Variant.getMissing()
* @param item14 Optional parameter. Default value is com4j.Variant.getMissing()
*/
@DISPID(2090)
net.rgielen.com4j.office2010.excel.Range getPivotData(
@Optional java.lang.Object dataField,
@Optional java.lang.Object field1,
@Optional java.lang.Object item1,
@Optional java.lang.Object field2,
@Optional java.lang.Object item2,
@Optional java.lang.Object field3,
@Optional java.lang.Object item3,
@Optional java.lang.Object field4,
@Optional java.lang.Object item4,
@Optional java.lang.Object field5,
@Optional java.lang.Object item5,
@Optional java.lang.Object field6,
@Optional java.lang.Object item6,
@Optional java.lang.Object field7,
@Optional java.lang.Object item7,
@Optional java.lang.Object field8,
@Optional java.lang.Object item8,
@Optional java.lang.Object field9,
@Optional java.lang.Object item9,
@Optional java.lang.Object field10,
@Optional java.lang.Object item10,
@Optional java.lang.Object field11,
@Optional java.lang.Object item11,
@Optional java.lang.Object field12,
@Optional java.lang.Object item12,
@Optional java.lang.Object field13,
@Optional java.lang.Object item13,
@Optional java.lang.Object field14,
@Optional java.lang.Object item14);
/**
*
* Getter method for the COM property "DataPivotField"
*
*/
@DISPID(2120)
@PropGet
net.rgielen.com4j.office2010.excel.PivotField dataPivotField();
/**
*
* Getter method for the COM property "EnableDataValueEditing"
*
*/
@DISPID(2121)
@PropGet
boolean enableDataValueEditing();
/**
*
* Setter method for the COM property "EnableDataValueEditing"
*
* @param rhs Mandatory boolean parameter.
*/
@DISPID(2121)
@PropPut
void enableDataValueEditing(
boolean rhs);
/**
* @param field Mandatory com4j.Com4jObject parameter.
* @param caption Optional parameter. Default value is com4j.Variant.getMissing()
* @param function Optional parameter. Default value is com4j.Variant.getMissing()
*/
@DISPID(2122)
net.rgielen.com4j.office2010.excel.PivotField addDataField(
com4j.Com4jObject field,
@Optional java.lang.Object caption,
@Optional java.lang.Object function);
/**
*
* Getter method for the COM property "MDX"
*
*/
@DISPID(2123)
@PropGet
java.lang.String mdx();
/**
*
* Getter method for the COM property "ViewCalculatedMembers"
*
*/
@DISPID(2124)
@PropGet
boolean viewCalculatedMembers();
/**
*
* Setter method for the COM property "ViewCalculatedMembers"
*
* @param rhs Mandatory boolean parameter.
*/
@DISPID(2124)
@PropPut
void viewCalculatedMembers(
boolean rhs);
/**
*
* Getter method for the COM property "CalculatedMembers"
*
*/
@DISPID(2125)
@PropGet
net.rgielen.com4j.office2010.excel.CalculatedMembers calculatedMembers();
/**
*
* Getter method for the COM property "DisplayImmediateItems"
*
*/
@DISPID(2126)
@PropGet
boolean displayImmediateItems();
/**
*
* Setter method for the COM property "DisplayImmediateItems"
*
* @param rhs Mandatory boolean parameter.
*/
@DISPID(2126)
@PropPut
void displayImmediateItems(
boolean rhs);
/**
* @param arg1 Mandatory java.lang.Object parameter.
* @param arg2 Optional parameter. Default value is com4j.Variant.getMissing()
* @param arg3 Optional parameter. Default value is com4j.Variant.getMissing()
* @param arg4 Optional parameter. Default value is com4j.Variant.getMissing()
* @param arg5 Optional parameter. Default value is com4j.Variant.getMissing()
* @param arg6 Optional parameter. Default value is com4j.Variant.getMissing()
* @param arg7 Optional parameter. Default value is com4j.Variant.getMissing()
* @param arg8 Optional parameter. Default value is com4j.Variant.getMissing()
* @param arg9 Optional parameter. Default value is com4j.Variant.getMissing()
* @param arg10 Optional parameter. Default value is com4j.Variant.getMissing()
* @param arg11 Optional parameter. Default value is com4j.Variant.getMissing()
* @param arg12 Optional parameter. Default value is com4j.Variant.getMissing()
* @param arg13 Optional parameter. Default value is com4j.Variant.getMissing()
* @param arg14 Optional parameter. Default value is com4j.Variant.getMissing()
* @param arg15 Optional parameter. Default value is com4j.Variant.getMissing()
* @param arg16 Optional parameter. Default value is com4j.Variant.getMissing()
* @param arg17 Optional parameter. Default value is com4j.Variant.getMissing()
* @param arg18 Optional parameter. Default value is com4j.Variant.getMissing()
* @param arg19 Optional parameter. Default value is com4j.Variant.getMissing()
* @param arg20 Optional parameter. Default value is com4j.Variant.getMissing()
* @param arg21 Optional parameter. Default value is com4j.Variant.getMissing()
* @param arg22 Optional parameter. Default value is com4j.Variant.getMissing()
* @param arg23 Optional parameter. Default value is com4j.Variant.getMissing()
* @param arg24 Optional parameter. Default value is com4j.Variant.getMissing()
* @param arg25 Optional parameter. Default value is com4j.Variant.getMissing()
* @param arg26 Optional parameter. Default value is com4j.Variant.getMissing()
* @param arg27 Optional parameter. Default value is com4j.Variant.getMissing()
* @param arg28 Optional parameter. Default value is com4j.Variant.getMissing()
* @param arg29 Optional parameter. Default value is com4j.Variant.getMissing()
* @param arg30 Optional parameter. Default value is com4j.Variant.getMissing()
*/
@DISPID(2127)
java.lang.Object dummy15(
java.lang.Object arg1,
@Optional java.lang.Object arg2,
@Optional java.lang.Object arg3,
@Optional java.lang.Object arg4,
@Optional java.lang.Object arg5,
@Optional java.lang.Object arg6,
@Optional java.lang.Object arg7,
@Optional java.lang.Object arg8,
@Optional java.lang.Object arg9,
@Optional java.lang.Object arg10,
@Optional java.lang.Object arg11,
@Optional java.lang.Object arg12,
@Optional java.lang.Object arg13,
@Optional java.lang.Object arg14,
@Optional java.lang.Object arg15,
@Optional java.lang.Object arg16,
@Optional java.lang.Object arg17,
@Optional java.lang.Object arg18,
@Optional java.lang.Object arg19,
@Optional java.lang.Object arg20,
@Optional java.lang.Object arg21,
@Optional java.lang.Object arg22,
@Optional java.lang.Object arg23,
@Optional java.lang.Object arg24,
@Optional java.lang.Object arg25,
@Optional java.lang.Object arg26,
@Optional java.lang.Object arg27,
@Optional java.lang.Object arg28,
@Optional java.lang.Object arg29,
@Optional java.lang.Object arg30);
/**
*
* Getter method for the COM property "EnableFieldList"
*
*/
@DISPID(2128)
@PropGet
boolean enableFieldList();
/**
*
* Setter method for the COM property "EnableFieldList"
*
* @param rhs Mandatory boolean parameter.
*/
@DISPID(2128)
@PropPut
void enableFieldList(
boolean rhs);
/**
*
* Getter method for the COM property "VisualTotals"
*
*/
@DISPID(2129)
@PropGet
boolean visualTotals();
/**
*
* Setter method for the COM property "VisualTotals"
*
* @param rhs Mandatory boolean parameter.
*/
@DISPID(2129)
@PropPut
void visualTotals(
boolean rhs);
/**
*
* Getter method for the COM property "ShowPageMultipleItemLabel"
*
*/
@DISPID(2130)
@PropGet
boolean showPageMultipleItemLabel();
/**
*
* Setter method for the COM property "ShowPageMultipleItemLabel"
*
* @param rhs Mandatory boolean parameter.
*/
@DISPID(2130)
@PropPut
void showPageMultipleItemLabel(
boolean rhs);
/**
*
* Getter method for the COM property "Version"
*
*/
@DISPID(392)
@PropGet
net.rgielen.com4j.office2010.excel.XlPivotTableVersionList version();
/**
* @param file Mandatory java.lang.String parameter.
* @param measures Optional parameter. Default value is com4j.Variant.getMissing()
* @param levels Optional parameter. Default value is com4j.Variant.getMissing()
* @param members Optional parameter. Default value is com4j.Variant.getMissing()
* @param properties Optional parameter. Default value is com4j.Variant.getMissing()
*/
@DISPID(2131)
java.lang.String createCubeFile(
java.lang.String file,
@Optional java.lang.Object measures,
@Optional java.lang.Object levels,
@Optional java.lang.Object members,
@Optional java.lang.Object properties);
/**
*
* Getter method for the COM property "DisplayEmptyRow"
*
*/
@DISPID(2136)
@PropGet
boolean displayEmptyRow();
/**
*
* Setter method for the COM property "DisplayEmptyRow"
*
* @param rhs Mandatory boolean parameter.
*/
@DISPID(2136)
@PropPut
void displayEmptyRow(
boolean rhs);
/**
*
* Getter method for the COM property "DisplayEmptyColumn"
*
*/
@DISPID(2137)
@PropGet
boolean displayEmptyColumn();
/**
*
* Setter method for the COM property "DisplayEmptyColumn"
*
* @param rhs Mandatory boolean parameter.
*/
@DISPID(2137)
@PropPut
void displayEmptyColumn(
boolean rhs);
/**
*
* Getter method for the COM property "ShowCellBackgroundFromOLAP"
*
*/
@DISPID(2138)
@PropGet
boolean showCellBackgroundFromOLAP();
/**
*
* Setter method for the COM property "ShowCellBackgroundFromOLAP"
*
* @param rhs Mandatory boolean parameter.
*/
@DISPID(2138)
@PropPut
void showCellBackgroundFromOLAP(
boolean rhs);
/**
*
* Getter method for the COM property "PivotColumnAxis"
*
*/
@DISPID(2546)
@PropGet
net.rgielen.com4j.office2010.excel.PivotAxis pivotColumnAxis();
/**
*
* Getter method for the COM property "PivotRowAxis"
*
*/
@DISPID(2547)
@PropGet
net.rgielen.com4j.office2010.excel.PivotAxis pivotRowAxis();
/**
*
* Getter method for the COM property "ShowDrillIndicators"
*
*/
@DISPID(2548)
@PropGet
boolean showDrillIndicators();
/**
*
* Setter method for the COM property "ShowDrillIndicators"
*
* @param rhs Mandatory boolean parameter.
*/
@DISPID(2548)
@PropPut
void showDrillIndicators(
boolean rhs);
/**
*
* Getter method for the COM property "PrintDrillIndicators"
*
*/
@DISPID(2549)
@PropGet
boolean printDrillIndicators();
/**
*
* Setter method for the COM property "PrintDrillIndicators"
*
* @param rhs Mandatory boolean parameter.
*/
@DISPID(2549)
@PropPut
void printDrillIndicators(
boolean rhs);
/**
*
* Getter method for the COM property "DisplayMemberPropertyTooltips"
*
*/
@DISPID(2550)
@PropGet
boolean displayMemberPropertyTooltips();
/**
*
* Setter method for the COM property "DisplayMemberPropertyTooltips"
*
* @param rhs Mandatory boolean parameter.
*/
@DISPID(2550)
@PropPut
void displayMemberPropertyTooltips(
boolean rhs);
/**
*
* Getter method for the COM property "DisplayContextTooltips"
*
*/
@DISPID(2551)
@PropGet
boolean displayContextTooltips();
/**
*
* Setter method for the COM property "DisplayContextTooltips"
*
* @param rhs Mandatory boolean parameter.
*/
@DISPID(2551)
@PropPut
void displayContextTooltips(
boolean rhs);
/**
*/
@DISPID(2552)
void clearTable();
/**
*
* Getter method for the COM property "CompactRowIndent"
*
*/
@DISPID(2553)
@PropGet
int compactRowIndent();
/**
*
* Setter method for the COM property "CompactRowIndent"
*
* @param rhs Mandatory int parameter.
*/
@DISPID(2553)
@PropPut
void compactRowIndent(
int rhs);
/**
*
* Getter method for the COM property "LayoutRowDefault"
*
*/
@DISPID(2554)
@PropGet
net.rgielen.com4j.office2010.excel.XlLayoutRowType layoutRowDefault();
/**
*
* Setter method for the COM property "LayoutRowDefault"
*
* @param rhs Mandatory net.rgielen.com4j.office2010.excel.XlLayoutRowType parameter.
*/
@DISPID(2554)
@PropPut
void layoutRowDefault(
net.rgielen.com4j.office2010.excel.XlLayoutRowType rhs);
/**
*
* Getter method for the COM property "DisplayFieldCaptions"
*
*/
@DISPID(2555)
@PropGet
boolean displayFieldCaptions();
/**
*
* Setter method for the COM property "DisplayFieldCaptions"
*
* @param rhs Mandatory boolean parameter.
*/
@DISPID(2555)
@PropPut
void displayFieldCaptions(
boolean rhs);
/**
* @param rowLayout Mandatory net.rgielen.com4j.office2010.excel.XlLayoutRowType parameter.
*/
@DISPID(2556)
void rowAxisLayout(
net.rgielen.com4j.office2010.excel.XlLayoutRowType rowLayout);
/**
* @param location Mandatory net.rgielen.com4j.office2010.excel.XlSubtototalLocationType parameter.
*/
@DISPID(2558)
void subtotalLocation(
net.rgielen.com4j.office2010.excel.XlSubtototalLocationType location);
/**
*
* Getter method for the COM property "ActiveFilters"
*
*/
@DISPID(2559)
@PropGet
net.rgielen.com4j.office2010.excel.PivotFilters activeFilters();
/**
*
* Getter method for the COM property "InGridDropZones"
*
*/
@DISPID(2560)
@PropGet
boolean inGridDropZones();
/**
*
* Setter method for the COM property "InGridDropZones"
*
* @param rhs Mandatory boolean parameter.
*/
@DISPID(2560)
@PropPut
void inGridDropZones(
boolean rhs);
/**
*/
@DISPID(2561)
void clearAllFilters();
/**
*
* Getter method for the COM property "TableStyle2"
*
*/
@DISPID(2562)
@PropGet
java.lang.Object tableStyle2();
/**
*
* Setter method for the COM property "TableStyle2"
*
* @param rhs Mandatory java.lang.Object parameter.
*/
@DISPID(2562)
@PropPut
void tableStyle2(
java.lang.Object rhs);
/**
*
* Getter method for the COM property "ShowTableStyleLastColumn"
*
*/
@DISPID(2563)
@PropGet
boolean showTableStyleLastColumn();
/**
*
* Setter method for the COM property "ShowTableStyleLastColumn"
*
* @param rhs Mandatory boolean parameter.
*/
@DISPID(2563)
@PropPut
void showTableStyleLastColumn(
boolean rhs);
/**
*
* Getter method for the COM property "ShowTableStyleRowStripes"
*
*/
@DISPID(2564)
@PropGet
boolean showTableStyleRowStripes();
/**
*
* Setter method for the COM property "ShowTableStyleRowStripes"
*
* @param rhs Mandatory boolean parameter.
*/
@DISPID(2564)
@PropPut
void showTableStyleRowStripes(
boolean rhs);
/**
*
* Getter method for the COM property "ShowTableStyleColumnStripes"
*
*/
@DISPID(2565)
@PropGet
boolean showTableStyleColumnStripes();
/**
*
* Setter method for the COM property "ShowTableStyleColumnStripes"
*
* @param rhs Mandatory boolean parameter.
*/
@DISPID(2565)
@PropPut
void showTableStyleColumnStripes(
boolean rhs);
/**
*
* Getter method for the COM property "ShowTableStyleRowHeaders"
*
*/
@DISPID(2566)
@PropGet
boolean showTableStyleRowHeaders();
/**
*
* Setter method for the COM property "ShowTableStyleRowHeaders"
*
* @param rhs Mandatory boolean parameter.
*/
@DISPID(2566)
@PropPut
void showTableStyleRowHeaders(
boolean rhs);
/**
*
* Getter method for the COM property "ShowTableStyleColumnHeaders"
*
*/
@DISPID(2567)
@PropGet
boolean showTableStyleColumnHeaders();
/**
*
* Setter method for the COM property "ShowTableStyleColumnHeaders"
*
* @param rhs Mandatory boolean parameter.
*/
@DISPID(2567)
@PropPut
void showTableStyleColumnHeaders(
boolean rhs);
/**
* @param convertFilters Mandatory boolean parameter.
*/
@DISPID(2568)
void convertToFormulas(
boolean convertFilters);
/**
*
* Getter method for the COM property "AllowMultipleFilters"
*
*/
@DISPID(2570)
@PropGet
boolean allowMultipleFilters();
/**
*
* Setter method for the COM property "AllowMultipleFilters"
*
* @param rhs Mandatory boolean parameter.
*/
@DISPID(2570)
@PropPut
void allowMultipleFilters(
boolean rhs);
/**
*
* Getter method for the COM property "CompactLayoutRowHeader"
*
*/
@DISPID(2571)
@PropGet
java.lang.String compactLayoutRowHeader();
/**
*
* Setter method for the COM property "CompactLayoutRowHeader"
*
* @param rhs Mandatory java.lang.String parameter.
*/
@DISPID(2571)
@PropPut
void compactLayoutRowHeader(
java.lang.String rhs);
/**
*
* Getter method for the COM property "CompactLayoutColumnHeader"
*
*/
@DISPID(2572)
@PropGet
java.lang.String compactLayoutColumnHeader();
/**
*
* Setter method for the COM property "CompactLayoutColumnHeader"
*
* @param rhs Mandatory java.lang.String parameter.
*/
@DISPID(2572)
@PropPut
void compactLayoutColumnHeader(
java.lang.String rhs);
/**
*
* Getter method for the COM property "FieldListSortAscending"
*
*/
@DISPID(2573)
@PropGet
boolean fieldListSortAscending();
/**
*
* Setter method for the COM property "FieldListSortAscending"
*
* @param rhs Mandatory boolean parameter.
*/
@DISPID(2573)
@PropPut
void fieldListSortAscending(
boolean rhs);
/**
*
* Getter method for the COM property "SortUsingCustomLists"
*
*/
@DISPID(2574)
@PropGet
boolean sortUsingCustomLists();
/**
*
* Setter method for the COM property "SortUsingCustomLists"
*
* @param rhs Mandatory boolean parameter.
*/
@DISPID(2574)
@PropPut
void sortUsingCustomLists(
boolean rhs);
/**
* @param conn Mandatory net.rgielen.com4j.office2010.excel.WorkbookConnection parameter.
*/
@DISPID(2575)
void changeConnection(
net.rgielen.com4j.office2010.excel.WorkbookConnection conn);
/**
* @param pivotCache Mandatory java.lang.Object parameter.
*/
@DISPID(2577)
void changePivotCache(
java.lang.Object pivotCache);
/**
*
* Getter method for the COM property "Location"
*
*/
@DISPID(1397)
@PropGet
java.lang.String location();
/**
*
* Setter method for the COM property "Location"
*
* @param rhs Mandatory java.lang.String parameter.
*/
@DISPID(1397)
@PropPut
void location(
java.lang.String rhs);
/**
*
* Getter method for the COM property "EnableWriteback"
*
*/
@DISPID(2872)
@PropGet
boolean enableWriteback();
/**
*
* Setter method for the COM property "EnableWriteback"
*
* @param rhs Mandatory boolean parameter.
*/
@DISPID(2872)
@PropPut
void enableWriteback(
boolean rhs);
/**
*
* Getter method for the COM property "Allocation"
*
*/
@DISPID(2873)
@PropGet
net.rgielen.com4j.office2010.excel.XlAllocation allocation();
/**
*
* Setter method for the COM property "Allocation"
*
* @param rhs Mandatory net.rgielen.com4j.office2010.excel.XlAllocation parameter.
*/
@DISPID(2873)
@PropPut
void allocation(
net.rgielen.com4j.office2010.excel.XlAllocation rhs);
/**
*
* Getter method for the COM property "AllocationValue"
*
*/
@DISPID(2874)
@PropGet
net.rgielen.com4j.office2010.excel.XlAllocationValue allocationValue();
/**
*
* Setter method for the COM property "AllocationValue"
*
* @param rhs Mandatory net.rgielen.com4j.office2010.excel.XlAllocationValue parameter.
*/
@DISPID(2874)
@PropPut
void allocationValue(
net.rgielen.com4j.office2010.excel.XlAllocationValue rhs);
/**
*
* Getter method for the COM property "AllocationMethod"
*
*/
@DISPID(2875)
@PropGet
net.rgielen.com4j.office2010.excel.XlAllocationMethod allocationMethod();
/**
*
* Setter method for the COM property "AllocationMethod"
*
* @param rhs Mandatory net.rgielen.com4j.office2010.excel.XlAllocationMethod parameter.
*/
@DISPID(2875)
@PropPut
void allocationMethod(
net.rgielen.com4j.office2010.excel.XlAllocationMethod rhs);
/**
*
* Getter method for the COM property "AllocationWeightExpression"
*
*/
@DISPID(2876)
@PropGet
java.lang.String allocationWeightExpression();
/**
*
* Setter method for the COM property "AllocationWeightExpression"
*
* @param rhs Mandatory java.lang.String parameter.
*/
@DISPID(2876)
@PropPut
void allocationWeightExpression(
java.lang.String rhs);
/**
*/
@DISPID(2855)
void allocateChanges();
/**
*/
@DISPID(2877)
void commitChanges();
/**
*/
@DISPID(2856)
void discardChanges();
/**
*/
@DISPID(2878)
void refreshDataSourceValues();
/**
* @param repeat Mandatory net.rgielen.com4j.office2010.excel.XlPivotFieldRepeatLabels parameter.
*/
@DISPID(2879)
void repeatAllLabels(
net.rgielen.com4j.office2010.excel.XlPivotFieldRepeatLabels repeat);
/**
*
* Getter method for the COM property "ChangeList"
*
*/
@DISPID(2880)
@PropGet
net.rgielen.com4j.office2010.excel.PivotTableChangeList changeList();
/**
*
* Getter method for the COM property "Slicers"
*
*/
@DISPID(2881)
@PropGet
net.rgielen.com4j.office2010.excel.Slicers slicers();
/**
*
* Getter method for the COM property "AlternativeText"
*
*/
@DISPID(1891)
@PropGet
java.lang.String alternativeText();
/**
*
* Setter method for the COM property "AlternativeText"
*
* @param rhs Mandatory java.lang.String parameter.
*/
@DISPID(1891)
@PropPut
void alternativeText(
java.lang.String rhs);
/**
*
* Getter method for the COM property "Summary"
*
*/
@DISPID(273)
@PropGet
java.lang.String summary();
/**
*
* Setter method for the COM property "Summary"
*
* @param rhs Mandatory java.lang.String parameter.
*/
@DISPID(273)
@PropPut
void summary(
java.lang.String rhs);
/**
*
* Getter method for the COM property "VisualTotalsForSets"
*
*/
@DISPID(2882)
@PropGet
boolean visualTotalsForSets();
/**
*
* Setter method for the COM property "VisualTotalsForSets"
*
* @param rhs Mandatory boolean parameter.
*/
@DISPID(2882)
@PropPut
void visualTotalsForSets(
boolean rhs);
/**
*
* Getter method for the COM property "ShowValuesRow"
*
*/
@DISPID(2883)
@PropGet
boolean showValuesRow();
/**
*
* Setter method for the COM property "ShowValuesRow"
*
* @param rhs Mandatory boolean parameter.
*/
@DISPID(2883)
@PropPut
void showValuesRow(
boolean rhs);
/**
*
* Getter method for the COM property "CalculatedMembersInFilters"
*
*/
@DISPID(2884)
@PropGet
boolean calculatedMembersInFilters();
/**
*
* Setter method for the COM property "CalculatedMembersInFilters"
*
* @param rhs Mandatory boolean parameter.
*/
@DISPID(2884)
@PropPut
void calculatedMembersInFilters(
boolean rhs);
// Properties:
}