EXCEL Append workbook function

This article describes the RPA Excel functionality to append data from another workbook.

For a full list of available functions, please read EXCEL functions.

Description

The EXCEL Append workbook function appends data from another workbook into the current workbook. You can optionally specify which sheets to import and whether to skip headers from the source workbook.

This is useful for consolidating data from multiple files into a single workbook, especially when the source files share the same structure.

Setting it up

To use the EXCEL Append workbook function, follow these instructions:

{{popups:rpas/add:action=excel-append-workbook}}

Once on a process map:

1. Navigate to the process where you would like to add the function
2. Click on the green button’s drop-down
3. Click on “+ Activity”
4. Select the EXCEL Append workbook option
5. Click "Add" once you are done

Input parameters

Output variables

This action does not produce output variables.

Errors

Tips

• Turn off Skip headers if you want to include the header row from the source workbook
• When appending data, rows are added after the last row with data in the matching sheet
• If a sheet in the source does not exist in the current workbook, it will be created
• Use this in a loop to consolidate multiple files with the same structure

Related functions

• Merge workbooks
• Copy sheet
• Paste sheet