Home > Features

Features



  • Read and bulk load Excel XLS and Excel 2007 XLSX spreadsheet files natively without external dependencies like having Office installed

  • Read, write, and bulk load CSV files

    • Standard comma and tab delimited data

    • End of records using Mac, Unix, or Windows end of line markers

    • Text qualified fields using double quotes

    • Alternate field delimiters, pipe, tab, etc

    • Alternate text qualifiers, single quote, etc

    • Occurrences of field delimiter within text qualified field

    • Occurrences of text qualifier within text qualified field

    • Occurrences of any character, including record end delimiters, inside text qualified fields

    • All encodings, ANSI, UTF-8, Unicode, ASCII, etc

    • First record with or without field names

    • Parsing from raw Stream in addition to files

  • Read, write, and bulk load fixed width files

  • Read and bulk load XML files

  • Stream based file parsing allowing for parsing of large files without storing the entire file contents in memory

  • Simple reader pattern movement through file

  • Simple access to field data by index or by field name

  • Compatible with medium trust environments

  • Is not dependent on any others drivers like Jet/OLE/ODBC

  • All features work in a full 64 bit environment