Instructions for Loading1. Add the dependencies that allow the usage of the component
2. Understand the configurations
- Encode: Encode of Binary File. (Default is utf-8, see here for available encode names)
- IsSkipHeader: Whether skip first head line (Default is true)
- IsIgnoreColumnChange: Whether ignore or raise error if # of fields changed (Default is true)
- FieldDelimiter: Delimiter of the field (Default is comma, use Chr(9) for tab)
- IsDisableDoubleQuote: Disable double quote enclose/escape.(Default is true). Set to false ONLY IF your data DO NOT contain comma/CR/LF/double quote
- IsDropCommentRow: Whether drop the row that started with # (Default is true)
- CustomHeader: Custom Header Row. Use this if your CSV has No Header or Need Override JSON Property3. Convert CSV to JSONCall CsvToJson Action to convert CSV to JSON4. Deserialize JSON to List
Instructions for Exporting
1. Add the dependencies that allow the usage of the component
- Encode: Encode when exporting Binary. (Default is utf-8, see here for available encode names)
- HasBOM: BOM when exporting Binary. (Default is false, Learn more here)
- IsShowHeader: Whether export head line (Default is true). If CustomHeader specified,export CustomHeader as head line. Otherwise, export the name of Attributes as the headline..
- EncodeMode: Mode of escape special characters (Default is auto) auto: Automatically escape if need quote: ALWAYS escape noquote: DO NOT escape but will throw exception if there are special character included noquote_nocheck: DO NOT escape
- LineSeparator: Line separator (Default is CRLF)
- CustomHeader: Custom head row when IsShowHeader is enabled
3. Serialize List to JSON
You MUST set [Serialized Default Values] to Yes4. Convert JSON to CSVCall JsonToCsv Action to convert JSON to CSV