Actions14
- Sheet Actions
- Table Actions
- Workbook Actions
Sheet → Get Columns
AI-generatedSummary
Return the list of column headers from a specified worksheet in a Nextcloud-hosted spreadsheet file.
Inputs
- From (required) — Specify the spreadsheet file to use either by selecting from a list of files within a specified folder or by providing the file path as an expression.
- Folder — If selecting from a list, choose the folder in Nextcloud to filter the available spreadsheet files.
- File — Select the spreadsheet file from the list of files found in the chosen folder.
- File Path — Provide the full file path to the spreadsheet file if specifying by path directly.
- Header Row — Specify which row number contains the column headers. Defaults to 1; change if the headers are not in the first row.
- Sheet — Choose the worksheet to retrieve columns from. Options include selecting from a list of sheets, providing the sheet name via expression, or using the first sheet by default.
- Sheet Name — If specifying sheet by name, provide the name of the worksheet here.
Output shape
a list of items each containing a JSON object with the keys: columns (an array of column headers), count (number of columns), sheetName (worksheet name used), filePath (spreadsheet file path), and headerRow (row number used for headers).
Returns a list with a single item representing the sheet's column headers. The operation will throw an error if the specified sheet does not exist or the file path is missing. Supports both files selected from lists and paths specified by expression.
Examples
Example 1: Get column headers from a spreadsheet selected from the file list in the '/' folder, using the first row as headers, from a chosen worksheet
Folder: /, File: selected from list, Header Row: 1, Sheet: selected from list
Example 2: Get column headers from a spreadsheet specified by path, with header row on row 2, and worksheet specified by name expression
File Path: /Documents/data.xlsx, Header Row: 2, Sheet Mode: 'By Name', Sheet Name: 'Sheet1'