Excel.ExcelWorksheet Class
Namespace: Nucleus.Extensions.Excel
Assembly: Nucleus.Extensions.dll
Base class for the ExcelReader and ExcelWriter classes.
Properties
RowIndex Property
Current row index.
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.
Fields
MIMETYPE_EXCEL
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.
GetXLDataType (Type) Method
GetXLDataType (Type type)
Return the spreadsheet data type which matches the specified type
Parameters
| Name | Type |
|---|---|
| type | Type |
RemoveColumn (String) Method
RemoveColumn (String name)
Remove the specified column column.
Parameters
| Name | Type |
|---|---|
| name | String |