NextCloud Spreadsheet icon

NextCloud Spreadsheet

Read and write spreadsheet files (.xlsx, .ods, .csv) stored on Nextcloud — includes named Excel table support

Actions14

Table → Get Columns

AI-generated

Summary

Retrieve the list of column headers from a named Excel table stored in a spreadsheet file on Nextcloud.

Inputs

  • filePathMode (required) — Choose how to specify the spreadsheet file: either select from a list within a folder or provide a file path expression.
  • folderPath — Select the folder to filter spreadsheet files when using 'From List' mode.
  • filePathFromList — Select a spreadsheet file from the specified folder when using 'From List' mode.
  • filePath — Specify the full path to the spreadsheet file when using 'By Path' mode.
  • tableMode (required) — Select the named table within the workbook either from a list or by providing its name as an expression.
  • tableFromList — Select a named table from the workbook when using 'From List' mode.
  • tableName — Specify the name of the table when using 'By Name' mode.

Output shape

a list of JSON objects each containing the table name, its column headers array, column count, and the file path used to access the spreadsheet

Returns an array with one object per execution item. Throws an error if no file path or table name is specified or if the table is not found. The output columns correspond to the exact header names of the named table in the spreadsheet.

Links

Discussion