A simple library designed to stream-read large Excel files and return batches of strongly-typed class records.
Uses the Simple API for XML (SAX) approach to parse a stream and maps each row to a specified class (ideal for reading from Azure Blob storage). Records are returned in batches of a specified size for efficient processing.
Handles columns in any order but assumes the first row is made up of the column headers.
Will handle simple lists/collections as comma-separated values.
Returns unmapped columns in a collection of "Extra Properties", useful for additional processing. Failed mapping values will have entries in a list of warnings - for example, properties of type "class" are not currently mapped.
Please see the unit tests for examples of usage. Documentation will come later.
(Work-in-progress - intended to be published to NuGet.)