aspose.cells

Class WorkbookDesigner

Encapsulates the object that represents a designer spreadsheet.

Constructor Summary
WorkbookDesigner()
Initializes a new instance of the WorkbookDesigner class.
WorkbookDesigner(workbook)
Initializes a new instance of the WorkbookDesigner class.
 
Property Getters/Setters Summary
functiongetCalculateFormula()
function
           Indicates whether formulas should be calculated.
functiongetLineByLine()
function
           Indicates whether processing the smart marker line by line.
functiongetRepeatFormulasWithSubtotal()
function
           Indicates whether repeating formulas with subtotal row.
functiongetUpdateEmptyStringAsNull()
function
           If TRUE, Null will be inserted if the value is "";
functiongetUpdateReference()
function
           Indicates if references in other worksheets will be updated.
functiongetWorkbook()
function
           Gets and sets the Workbook object.
 
Method Summary
functionclearDataSource()
Clears all data sources.
functiongetSmartMarkers()
Returns a collection of smart markers in a spreadsheet.
functionprocess()
Processes the smart markers and populates the data source values.
functionprocess(isPreserved)
Processes the smart markers and populates the data source values.
functionprocess(sheetIndex, isPreserved)
Processes the smart markers and populates the data source values.
functionsetDataSource(variable, data)
Sets data binding to a variable.
functionsetJsonDataSource(variable, data)
 

    • Constructor Detail

      • WorkbookDesigner

        function WorkbookDesigner()
        Initializes a new instance of the WorkbookDesigner class.
      • WorkbookDesigner

        function WorkbookDesigner(workbook)
        Initializes a new instance of the WorkbookDesigner class.
        Parameters:
        workbook: Workbook - The template workbook file.
    • Property Getters/Setters Detail

      • getWorkbook/setWorkbook : Workbook 

        function getWorkbook() / function setWorkbook(value)
        
        Gets and sets the Workbook object.
      • getRepeatFormulasWithSubtotal/setRepeatFormulasWithSubtotal : boolean 

        function getRepeatFormulasWithSubtotal() / function setRepeatFormulasWithSubtotal(value)
        
        Indicates whether repeating formulas with subtotal row.
      • getUpdateEmptyStringAsNull/setUpdateEmptyStringAsNull : boolean 

        function getUpdateEmptyStringAsNull() / function setUpdateEmptyStringAsNull(value)
        
        If TRUE, Null will be inserted if the value is "";
      • getUpdateReference/setUpdateReference : boolean 

        function getUpdateReference() / function setUpdateReference(value)
        
        Indicates if references in other worksheets will be updated.
      • getCalculateFormula/setCalculateFormula : boolean 

        function getCalculateFormula() / function setCalculateFormula(value)
        
        Indicates whether formulas should be calculated.
      • getLineByLine/setLineByLine : boolean 

        function getLineByLine() / function setLineByLine(value)
        
        Indicates whether processing the smart marker line by line. The default value is true. If False, the template file must contain a range which is named as "_CellsSmartMarkers".
    • Method Detail

      • clearDataSource

        function clearDataSource()
        Clears all data sources.
      • setJsonDataSource

        function setJsonDataSource(variable, data)
        Parameters:
        variable: String -
        data: String -
      • setDataSource

        function setDataSource(variable, data)
        Sets data binding to a variable.
        Parameters:
        variable: String - Variable name created using smart marker.
        data: Object - Source data.
      • process

        function process()
        Processes the smart markers and populates the data source values.
      • process

        function process(isPreserved)
        Processes the smart markers and populates the data source values.
        Parameters:
        isPreserved: boolean - True if the unrecognized smart marker is preserved.
      • process

        function process(sheetIndex, isPreserved)
        Processes the smart markers and populates the data source values. This method works on worksheet level.
        Parameters:
        sheetIndex: Number - Worksheet index.
        isPreserved: boolean - True if the unrecognized smart marker is preserved.
      • getSmartMarkers

        function 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