Excel.ExcelWriter Class
Namespace: Nucleus.Extensions.Excel
Assembly: Nucleus.Extensions.dll
Non-generic exporter.
Constructors
ExcelWriter
ExcelWriter ()
Constructor, used by the generic ExcelWriter class.
ExcelWriter (IXLWorksheet) Constructor
ExcelWriter (IXLWorksheet worksheet)
Use this constructor if you want to create columns and output rows manually. The generic Excel.ExcelWriter<TModel> class can auto-detect columns.
Parameters
| Name | Type |
|---|---|
| worksheet | ClosedXML.Excel.IXLWorksheet |
Methods
AdjustColumnWidths
AdjustColumnWidths ()
Automatically expand column widths to fit content.
GetOutputStream
GetOutputStream ()
Return the spreadsheet as a stream.
ListToString (IList) Method
ListToString (IList value)
Convert a list of items to a comma-separated string.
Parameters
| Name | Type |
|---|---|
| value | System.Collections.IList |
WriteHeadingRow
WriteHeadingRow ()
Write the heading row.
WriteRow (Object[]) Method
WriteRow (Object[] values)
Write the specified values to the next row of the current worksheet.
Parameters
| Name | Type |
|---|---|
| values | Object[] |
WriteRow (IEnumerable<Object>) Method
WriteRow (IEnumerable<Object> values)
Write the specified values to the next row of the current worksheet.
Parameters
| Name | Type |
|---|---|
| values | System.Collections.Generic.IEnumerable<System.Object> |