WorkbookDesigner
WorkbookDesigner class
Encapsulates the object that represents a designer spreadsheet.
public class WorkbookDesigner
Constructors
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
