DataStreams

The framework can handle Excel XLS, Excel 2007 XLSX, fixed width, and XML files as well.

Bulk insert capability for Microsoft SQL Server has been added for use with SqlBulkCopy under the .Net 2.0 framework.

Stream based parsers allow for ultimate performance, low resource usage, and nearly unlimited versatility scalable to any size data file, even tens or hundreds of gigabytes.

Event based data manipulation and validation allows total control over the flow of data during the bulk insert process.

What is new in this release:

• Disabled DTD downloads within XML files read through the various libraries to prevent possible XML External Entity attacks.

What is new in version 5.22:

• Added logic to prevent FileNotFoundException on OpenXML created XLSX files.
• Added logic to prevent NullReferenceException on XLSX files containing chart sheets.

What is new in version 5.21:

• Modified XlsxReader to handle files generated by some third party tools.

What is new in version 5.18:

• Modified XlsxReader to handle files generated by Excel 2013.

What is new in version 5.17:

• Corrected handling of cell text for some Excel documents when ran on a non English culture OS.

What is new in version 5.15:

• Added functionality to XlsxReader to read some OpenXML documents not generated by Excel.
• Updated XlsxReader to fix a bug where an empty row in the spreadsheet might cause parsing to stop.
• Updated header case sensitivity handling in CsvReader, XlsReader, and XlsxReader to match across all readers.

What is new in version 5.14:

• Updated XlsReader to fix a bug where extremely large cell contents were causing an ArgumentOutOfRange exception in constructor.