WorkbookDesigner Class |
Namespace: Aspose.Cells
The WorkbookDesigner type exposes the following members.
Name | Description | |
---|---|---|
![]() | WorkbookDesigner |
Initializes a new instance of the WorkbookDesigner class.
|
![]() | WorkbookDesigner(Workbook) |
Initializes a new instance of the WorkbookDesigner class.
|
Name | Description | |
---|---|---|
![]() | CalculateFormula |
Indicates whether formulas should be calculated.
|
![]() | CallBack |
Gets and sets callback interface of processing smartmarker.
|
![]() | LineByLine |
Indicates whether processing the smart marker line by line.
|
![]() | RepeatFormulasWithSubtotal |
Indicates whether repeating formulas with subtotal row.
|
![]() | UpdateEmptyStringAsNull |
If TRUE, Null will be inserted if the value is "";
|
![]() | UpdateReference |
Indicates if references in other worksheets will be updated.
|
![]() | Workbook |
Gets and sets the Workbook object.
|
Name | Description | |
---|---|---|
![]() | ClearDataSource |
Clears all data sources.
|
![]() | Equals | (Inherited from Object.) |
![]() | Finalize | (Inherited from Object.) |
![]() | GetHashCode | (Inherited from Object.) |
![]() | GetSmartMarkers |
Returns a collection of smart markers in a spreadsheet.
|
![]() | GetType | (Inherited from Object.) |
![]() | MemberwiseClone | (Inherited from Object.) |
![]() | Process |
Processes the smart markers and populates the data source values.
|
![]() | Process(Boolean) |
Processes the smart markers and populates the data source values.
|
![]() | Process(Int32, Boolean) |
Processes the smart markers and populates the data source values.
|
![]() ![]() | SetDataSource(DataSet) |
Sets data source of a DataSet object.
|
![]() | SetDataSource(DataTable) |
Sets data source of a DataTable object.
|
![]() | SetDataSource(DataView) |
Sets data source of a DataView object.
|
![]() | SetDataSource(OleDbConnection) |
Sets data source of a OleDbConnection object.
|
![]() | SetDataSource(SqlConnection) |
Sets data source of a SqlConnection object.
|
![]() | SetDataSource(String, ICellsDataTable) |
Sets data source of a ICellsDataTable object.
|
![]() | SetDataSource(String, DataView) |
Sets data source of a DataView object and binds it to a data source name.
|
![]() | SetDataSource(String, Object) |
Sets data binding to a variable.
|
![]() | SetDataSource(String, IDataReader, Int32) |
Sets data source of a IDataReader object.
|
![]() | ToString | (Inherited from Object.) |
[C#] //Create WorkbookDesigner object. WorkbookDesigner wd = new WorkbookDesigner(); //Open the template file (which contains smart markers). wd.Workbook = new Workbook("SmartMarker_Designer.xls"); //Initialize your data from data source //DataSet ds = new DataSet(); //... //Set the datatable as the data source. //wd.SetDataSource(dt); //Process the smart markers to fill the data into the worksheets. wd.Process(true); //Save the excel file. wd.Workbook.Save("outSmartMarker_Designer.xls");