EXCEL Ungroup columns function

The EXCEL Ungroup columns function in RPA.

Help CentreBuilding Processes

This article describes the RPA Excel functionality to ungroup columns.

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


Description

The EXCEL Ungroup columns function removes the outline (grouping) from one or more columns, so they can no longer be collapsed or expanded.


Setting it up

To use the EXCEL Ungroup columns function, follow these instructions:

{{popups:rpas/add:action=excel-columns-ungroup}}

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 Ungroup columns option
  5. Click "Add" once you are done

Input parameters

ParameterRequiredTypeDefaultDescription
SheetYesText-The name of the sheet
ColumnsYesTextarea-Column names or letters to ungroup, separated by line breaks

Output variables

This action does not produce output variables.


Errors

ErrorDescription
File not openThe Excel file must be open
Sheet not foundThe specified sheet does not exist

Tips

  • If columns are not grouped, this action has no effect

Related functions

See it working on your own data

Everything documented here ships with the platform – try the document tools free, or go live in 7 days.