Help Centre › Building Processes
Remove columns from a sheet.
Runs on: macOS and Windows only.
Add it to a process
In the process designer, open the Add step tab. Find Sort columns under Excel › Columns, or type its name in the search box, and drag it onto the canvas.
Fields
| Field | Required | What it does |
|---|---|---|
| File path | Yes | Enter the file path, or use a variable such as {folder::desktop::path}\file.xlsx. |
| Sheet | Yes | Name of the sheet in the Excel file. Supports wildcards: * matches any characters. |
| Columns | Yes | The column header(s) to use as key(s) for matching |
See all Excel steps.
Errors
| Error | Description |
|---|---|
| File not open | The Excel file must be open |
| Sheet not found | The specified sheet does not exist |
Tips
- Rearranges columns to match the specified order
- Columns not listed are placed after the listed ones