Nucleus .Net Core CMS

Excel.ExcelReader Class

Namespace: Nucleus.Extensions.Excel
Assembly: Nucleus.Extensions.dll
Non-generic exporter.

Constructors

Nucleus.Extensions.Excel.ExcelReader Constructor

Nucleus.Extensions.Excel.ExcelReader (System.IO.Stream)
Constructor, used by the generic ExcelReader<T> class.

Nucleus.Extensions.Excel.ExcelReader Constructor

Nucleus.Extensions.Excel.ExcelReader (IXLWorksheet worksheet)
Use this constructor if you want to create columns and output rows manually. The generic Excel.ExcelReader<TModel> class can auto-detect columns.
Parameters
Name Type
worksheet ClosedXML.Excel.IXLWorksheet

Methods

SetInputStream (Stream) Method

SetInputStream (System.IO.Stream)
Return the spreadsheet as a stream.

ReadHeadingRow

ReadHeadingRow ()
Read the heading row and reset the row index to the first data row.

ReadRow

ReadRow ()
Write the specified values to the next row of the current worksheet.