PivotTableCreateOptions
Inheritance: java.lang.Object
public class PivotTableCreateOptions
Options for creating a new PivotTable.
Constructors
| Constructor | Description |
|---|---|
| PivotTableCreateOptions() |
Methods
| Method | Description |
|---|---|
| equals(Object arg0) | |
| getClass() | |
| getTableName() | Gets the name of the new PivotTable report. |
| getUseSameSource() | Gets a value indicating whether to share the same data source with existing pivot tables. |
| hashCode() | |
| isXlsClassic() | Gets a value indicating whether to create classic Excel 97-2003 style PivotTable. |
| notify() | |
| notifyAll() | |
| setTableName(String value) | Sets the name of the new PivotTable report. |
| setUseSameSource(boolean value) | Sets a value indicating whether to share the same data source with existing pivot tables. |
| setXlsClassic(boolean value) | Sets a value indicating whether to create classic Excel 97-2003 style PivotTable. |
| toString() | |
| wait() | |
| wait(long arg0) | |
| wait(long arg0, int arg1) |
PivotTableCreateOptions()
public PivotTableCreateOptions()
equals(Object arg0)
public boolean equals(Object arg0)
Parameters:
| Parameter | Type | Description |
|---|---|---|
| arg0 | java.lang.Object |
Returns: boolean
getClass()
public final native Class<?> getClass()
Returns: java.lang.Class
getTableName()
public String getTableName()
Gets the name of the new PivotTable report.
Remarks
If not set , an automatic name will be set.
Returns: java.lang.String
getUseSameSource()
public boolean getUseSameSource()
Gets a value indicating whether to share the same data source with existing pivot tables. Default value is true.
Remarks
When set to true, multiple pivot tables can reuse one pivot cache to reduce memory consumption.
Returns: boolean
hashCode()
public native int hashCode()
Returns: int
isXlsClassic()
public boolean isXlsClassic()
Gets a value indicating whether to create classic Excel 97-2003 style PivotTable.
Remarks
Classic PivotTable uses legacy layout and formatting from Excel 97-2003. When not explicitly set, the default value is determined by the target workbook file format.
Returns: boolean
notify()
public final native void notify()
notifyAll()
public final native void notifyAll()
setTableName(String value)
public void setTableName(String value)
Sets the name of the new PivotTable report.
Remarks
If not set , an automatic name will be set.
Parameters:
| Parameter | Type | Description |
|---|---|---|
| value | java.lang.String |
setUseSameSource(boolean value)
public void setUseSameSource(boolean value)
Sets a value indicating whether to share the same data source with existing pivot tables. Default value is true.
Remarks
When set to true, multiple pivot tables can reuse one pivot cache to reduce memory consumption.
Parameters:
| Parameter | Type | Description |
|---|---|---|
| value | boolean |
setXlsClassic(boolean value)
public void setXlsClassic(boolean value)
Sets a value indicating whether to create classic Excel 97-2003 style PivotTable.
Remarks
Classic PivotTable uses legacy layout and formatting from Excel 97-2003. When not explicitly set, the default value is determined by the target workbook file format.
Parameters:
| Parameter | Type | Description |
|---|---|---|
| value | boolean |
toString()
public String toString()
Returns: java.lang.String
wait()
public final void wait()
wait(long arg0)
public final native void wait(long arg0)
Parameters:
| Parameter | Type | Description |
|---|---|---|
| arg0 | long |
wait(long arg0, int arg1)
public final void wait(long arg0, int arg1)
Parameters:
| Parameter | Type | Description |
|---|---|---|
| arg0 | long | |
| arg1 | int |
