Write DataTable to Excel

UiPath.Excel.Activities.Business.WriteRangeX

Writes a data table that was saved for later to an Excel file. The activity can be used with Excel files selected for parent Use Excel File activities or with the Project Notebook.

Important: This activity takes data from a DataTable type in memory and writes it into Excel. If you need to move data from one Excel location to another Excel location, use the Copy/Paste Range activity.

Configuring the Activity

In the Body of the Activity

• What to write - Select the plus sign, then use one of the options in the menu to indicate the data to write:

  • Select an Excel file, and then a named range, table, or sheet. To open the file and select a range directly from the file, select Indicate in Excel. Alternatively, you can select Custom Input to enter the range manually.
  • Use Saved Value - Select a data table value that you previously saved for later use in the project.
  • Open in Advanced Editor to enter a VB expression.
• Destination - Select the plus sign, then, from the menu, select the Excel file and then a named range, table, or sheet where to write the data, Indicate in Excel to open the file and select a range directly from the file, or Custom Input to enter the destination range manually.
• Append - If selected, the data is added starting with the first blank row in the destination range. If not selected, the data is added starting with the first row in the destination range, replacing any existing data. This option is not selected by default.
• Exclude headers - If selected, the header row or the first row in the source range is not written in the destination range. This option is not selected by default.

Properties Panel

Common

• DisplayName - The name displayed for the activity in the Designer panel.

Input

• See What to write in the body of the activity.

Misc

• Private - If selected, the values of variables and arguments are no longer logged at Verbose level.

Options

• See the options in the body of the activity.

Output

• See Destination in the body of the activity.

Important:

There is a known limitation where an out-of-memory error occurs while trying to write a data table in Excel using the Write DataTable to Excel activity. The issue happens when attempting to read values with the = or '= prefix characters from Excel documents.

As a solution, replace the = or '= prefixes with other characters.