Excel.ExcelWorksheet Class
Namespace: Nucleus.Extensions.Excel
Assembly: Nucleus.Extensions.dll
Base class for the ExcelReader and ExcelWriter classes.
Properties
Workbook Property
Excel workbook being created.
Worksheet Property
Excel worksheet being created.
Remarks
Callers can create multiple worksheets by calling WorkBook.WorkSheets.Add.
WorksheetColumns Property
List of worksheet columns.
RowIndex Property
Current row index.
Fields
MIMETYPE_EXCEL Field
MIME type for Excel (xlsx) format.
Methods
AddColumn (PropertyInfo) Method
AddColumn (PropertyInfo propertyInfo)
Add a column and auto-detect values using reflection.
Parameters
| Name | Type |
|---|---|
| propertyInfo | System.Reflection.PropertyInfo |
AddColumn (String,String,XLDataType) Method
AddColumn (String name, String caption, XLDataType dataType)
Add a column.
RemoveColumn (String) Method
RemoveColumn (String name)
Remove the specified column column.
Parameters
| Name | Type |
|---|---|
| name | String |
GetXLDataType (Type) Method
GetXLDataType (Type type)
Return the spreadsheet data type which matches the specified type
Parameters
| Name | Type |
|---|---|
| type | Type |