Features



  • Read, write, and bulk load CSV files

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

  • 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

  • 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