Write CSV

In the body of the activity

• Resource CSV file - Click Plus on the right side of the field to toggle between using a local path or a Resource file (of type CSV). We recommend using relative folder paths to accommodate the file structure variations between Windows and Linux during project execution. For example, newFolder or otherFolder.

• What to write - Select an Excel file and use the available options to choose a table, a sheet, or indicate a range in Excel.

• How to write - From the dropdown menu, choose one of the following options:
  • Write - Copies and pastes to the specified CSV file saved for later table data or data from an Excel file, Excel range, table, or sheet.
  • Append - Append to the end of the file; headers are excluded. Select a parent Excel file, and then a named range, table, or sheet, or indicate a range in Excel. If the activity is inside an Excel For Each Row activity, you can select CurrentRow to copy data from the current row in the iteration.
• Include headers - If enabled, the column headers are copied to the CSV file.

• Delimiter - Select the delimiter used in the CSV file: Tab, Comma(','), Semicolon(';'), Caret('^'), or Pipe('|').
• Encoding - Select the encoding type to be used. You can find the complete list of codes for each character encoding here. If no encoding type is specified, the activity searches for the file's Byte Order Marks to detect the encoding. If no Byte Order Marks are detected, the system ANSI code page is selected by default.

• You can download a sample automation project that, among others, includes a Write CSV activity here.
• To learn how to use this activity in a StudioX project, see Tutorial: Comparing Excel Files and Emailing Reconciliation Errors.