写入 CSV

UiPath.CSV.Activities.AppendWrite.CsvFile

描述

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.

项目兼容性

Windows - 旧版 | Windows | 跨平台

跨平台配置

在活动正文中

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

“写入 CSV”活动使用示例

• You can download a sample automation project that, among others, includes a Write CSV activity here.
• 如要了解如何使用此活动，请参阅 教程：比较 Excel 文件和电子邮件对帐错误。