A C# library for extracting data from xlsx files
This uses NPOI in order to read the XLSX file.
Dependencies (NPOI) must be downloaded via NuGet
- ExcelUploadServices contains the implementation code for the excel reader, including some internal interfaces
- ExcelUploadServices.Interfaces contains publicly exposed interfaces, in addition to the models being used
Excels must have:
- One piece of tabular data per sheet
- Top left cell of the table should be a named cell with the following format: "TableId_"
- Top row is assumed to be a columns row
- The data reader terminates once the leftmost column is left blank
Returns the following data:
- A list of columns, with the name provided being used as the column name
- A list of rows (with a row being represented as a List of Objects with the index of the object corresponding to the index within the list of columns, so the 4th item in row x is referenced by the 4th column)