java.lang.Objectcom.aspose.cells.WorkbookDesigner
public class WorkbookDesigner
Constructor Summary |
---|
WorkbookDesigner()
Initializes a new instance of the |
Property Getters/Setters Summary | ||
---|---|---|
boolean | getCalculateFormula() | |
void | setCalculateFormula(boolean value) | |
Indicates whether formulas should be calculated. | ||
boolean | getUpdateReference() | |
void | setUpdateReference(boolean value) | |
Indicates if references in other worksheets will be updated. | ||
Workbook | getWorkbook() | |
void | setWorkbook(Workbook value) | |
Gets and sets the |
Method Summary | ||
---|---|---|
void | clearDataSource() | |
Clears all data sources. | ||
java.lang.String[] | getSmartMarkers() | |
Returns a collection of smart markers in a spreadsheet. | ||
void | process() | |
Processes the smart markers and populates the data source values. | ||
void | process(boolean isPreserved) | |
Processes the smart markers and populates the data source values. | ||
void | process(int sheetIndex, boolean isPreserved) | |
Processes the smart markers and populates the data source values. | ||
void | setDataSource(java.lang.String dataSource, ICellsDataTable cellsDataTable) | |
Set the data source. | ||
void | setDataSource(java.lang.String variable, java.lang.Object data) | |
Sets data binding to a variable. | ||
void | setDataSource(java.lang.String variable, java.lang.Object[] dataArray) | |
Sets data array binding to a variable. | ||
void | setDataSource(java.lang.String dataSource, java.sql.ResultSet rs) | |
void | setDataSource(java.lang.String dataSource, java.sql.ResultSet rs, int rowCount) | |
Set the data source. | ||
void | setDataSource(java.sql.ResultSet rs) | |
Constructor Detail |
---|
public WorkbookDesigner()
Property Getters/Setters Detail |
---|
getWorkbook/setWorkbook | |
public Workbook getWorkbook() / public void setWorkbook(Workbook value) |
getUpdateReference/setUpdateReference | |
public boolean getUpdateReference() / public void setUpdateReference(boolean value) |
getCalculateFormula/setCalculateFormula | |
public boolean getCalculateFormula() / public void setCalculateFormula(boolean value) |
Method Detail |
---|
clearDataSource | |
public void clearDataSource() |
setDataSource | |
public void setDataSource(java.lang.String variable, java.lang.Object data) |
variable
- Variable name created using smark marker.data
- Source data.setDataSource | |
public void setDataSource(java.lang.String variable, java.lang.Object[] dataArray) |
variable
- Variable name created using smark marker.dataArray
- Source data array.process | |
public void process() throws java.lang.Exception |
process | |
public void process(boolean isPreserved) throws java.lang.Exception |
isPreserved
- True if the unrecognized smart marker is preserved.process | |
public void process(int sheetIndex, boolean isPreserved) throws java.lang.Exception |
sheetIndex
- Worksheet index.isPreserved
- True if the unrecognized smart marker is preserved.getSmartMarkers | |
public java.lang.String[] getSmartMarkers() |
setDataSource | |
public void setDataSource(java.lang.String dataSource, ICellsDataTable cellsDataTable) |
dataSource
- The name of the data source.cellsDataTable
- The interface of cells data table.setDataSource | |
public void setDataSource(java.lang.String dataSource, java.sql.ResultSet rs, int rowCount) |
dataSource
- The name of the data source.rs
- The result set.rowCount
- The data count of given resultset.
It should be the exact row count or -1;
If the resultset is forward only, user should give the exact row count here,
otherwise the smart may not be processed correctly when the smart marker's "noadd" is not set.
setDataSource | |
public void setDataSource(java.lang.String dataSource, java.sql.ResultSet rs) |
setDataSource | |
public void setDataSource(java.sql.ResultSet rs) |