com.aspose.cells

Constructor Detail

• WorkbookDesigner

  public WorkbookDesigner()

  Initializes a new instance of the WorkbookDesigner class.

• WorkbookDesigner

  public WorkbookDesigner(Workbook workbook)

  Initializes a new instance of the WorkbookDesigner class.

  Parameters:

  workbook - The template workbook file.

Property Getters/Setters Detail

• getWorkbook/setWorkbook

  public Workbook getWorkbook() / public void setWorkbook(Workbook value)
  

  Gets and sets the Workbook object.

• getRepeatFormulasWithSubtotal/setRepeatFormulasWithSubtotal

  public boolean getRepeatFormulasWithSubtotal() / public void setRepeatFormulasWithSubtotal(boolean value)
  

  Indicates whether repeating formulas with subtotal row.

• getUpdateEmptyStringAsNull/setUpdateEmptyStringAsNull

  public boolean getUpdateEmptyStringAsNull() / public void setUpdateEmptyStringAsNull(boolean value)
  

  If TRUE, Null will be inserted if the value is "";

• getUpdateReference/setUpdateReference

  public boolean getUpdateReference() / public void setUpdateReference(boolean value)
  

  Indicates if references in other worksheets will be updated.

• getCalculateFormula/setCalculateFormula

  public boolean getCalculateFormula() / public void setCalculateFormula(boolean value)
  

  Indicates whether formulas should be calculated.

• getCallBack/setCallBack

  public ISmartMarkerCallBack getCallBack() / public void setCallBack(ISmartMarkerCallBack value)
  

  Gets and sets callback interface of processing smartmarker.

• getLineByLine/setLineByLine

  public boolean getLineByLine() / public void setLineByLine(boolean value)
  

  Indicates wether processing the smart marker line by line.

  The default value is false. If False, the template file must contain a range which is named as "_CellsSmartMarkers".

Method Detail

• clearDataSource

  public void clearDataSource()

  Clears all data sources.

• setDataSource

  public void setDataSource(java.lang.String name, ICellsDataTable dataTable)

  Sets data source of a ICellsDataTable object.

  Parameters:

  name - The name of the table.

  dataTable - DataTable object

• setDataSource

  public void setDataSource(java.lang.String variable, java.lang.Object data)

  Sets data binding to a variable.

  Parameters:

  variable - Variable name created using smart marker.

  data - Source data.

• setDataSource

  public void setDataSource(java.lang.String variable, java.lang.Object[] dataArray)

  Sets data array binding to a variable.

  Parameters:

  variable - Variable name created using smart marker.

  dataArray - Source data array.

• process

  public void process()
              throws java.lang.Exception

  Processes the smart markers and populates the data source values.

• process

  public void process(boolean isPreserved)
              throws java.lang.Exception

  Processes the smart markers and populates the data source values.

  Parameters:

  isPreserved - True if the unrecognized smart marker is preserved.

• process

  public void process(int sheetIndex, boolean isPreserved)
              throws java.lang.Exception

  Processes the smart markers and populates the data source values.

  This method works on worksheet level.

  Parameters:

  sheetIndex - Worksheet index.

  isPreserved - True if the unrecognized smart marker is preserved.

• getSmartMarkers

  public java.lang.String[] getSmartMarkers()

  Returns a collection of smart markers in a spreadsheet.

  A string array is created on every call. The array is sorted and duplicated values are removed.

  Returns:

  A collection of smart markers