Help Centre › Building Processes
Remove every row above the header row so the header lands on row 1.
Runs on: macOS and Windows only.
Add it to a process
In the process designer, open the Add step tab. Find Remove rows above header under Excel › Rows, or type its name in the search box, and drag it onto the canvas.
Fields
| Field | Required | What it does |
|---|---|---|
| File path | No | 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. |
| Max rows to remove | No | Maximum number of rows allowed to be removed. Removing more than this fails the step. Defaults to 10. Default: 10. |
| Header columns (optional) | No | Comma-separated labels that identify the header row. Leave blank to auto-detect the header. |
| Variable | No | Name of the variable where the result will be stored |
See all Excel steps.