Écrire un fichier CSV (Write CSV)

UiPath.CSV.Activities.AppendWrite.CsvFile

Description

Copies saved for later table data or data from an Excel file, Excel range, table, or sheet, and pastes it after the existing data in a specified CSV file. The copied data replaces any data that already exists in the CSV file. If the CSV file does not exist, it is created when the automation is executed.

Compatibilité du projet

Windows - Héritage | Windows | Multiplate-forme

Configuration multiplateforme

Dans le corps de l’activité

• 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.

Windows-Legacy, Windows configuration

For more details on the configuration, check the Write CSV activity, under classic activities.

Exemple d'utilisation de l'activité Write CSV

• You can download a sample automation project that, among others, includes a Write CSV activity here.
• Pour savoir comment utiliser cette activité, consultez Tutoriel : comparaison des fichiers Excel et envoi par e-mail des erreurs de rapprochement.