Class WorkbookDesigner
WorkbookDesigner class
Encapsulates the object that represents a designer spreadsheet.
public class WorkbookDesigner
Constructors
| Name | Description |
|---|
| WorkbookDesigner() | Initializes a new instance of the WorkbookDesigner class. |
| WorkbookDesigner(Workbook) | Initializes a new instance of the WorkbookDesigner class. |
Properties
| Name | Description |
|---|
| CalculateFormula { get; set; } | Indicates whether formulas should be calculated. |
| CallBack { get; set; } | Gets and sets callback interface of processing smartmarker. |
| LineByLine { get; set; } | Indicates whether processing the smart marker line by line. |
| RepeatFormulasWithSubtotal { get; set; } | Indicates whether repeating formulas with subtotal row. |
| UpdateEmptyStringAsNull { get; set; } | If TRUE, Null will be inserted if the value is “”; |
| UpdateReference { get; set; } | Indicates if references in other worksheets will be updated. |
| Workbook { get; set; } | Gets and sets the Workbook object. |
Methods
| Name | Description |
|---|
| ClearDataSource() | Clears all data sources. |
| GetSmartMarkers() | Returns a collection of smart markers in a spreadsheet. |
| Process() | Processes the smart markers and populates the data source values. |
| Process(bool) | Processes the smart markers and populates the data source values. |
| Process(int, bool) | 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, DataView) | Sets data source of a DataView object and binds it to a data source name. |
| SetDataSource(string, ICellsDataTable) | Sets data source of a ICellsDataTable object. |
| SetDataSource(string, object) | Sets data binding to a variable. |
| SetDataSource(string, IDataReader, int) | Sets data source of a IDataReader object. |
Examples
[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");
See Also
