NextCloud Spreadsheet icon

NextCloud Spreadsheet

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

Actions14

Workbook → Get Sheets

AI-generated

Summary

Return all worksheet names in a specified spreadsheet file stored on Nextcloud.

Inputs

  • filePathMode (required) — Choose how to specify the spreadsheet file: from a list or by a direct path expression.
  • folderPath — If selecting the file from a list, filter spreadsheet files by this folder path.
  • filePathFromList — If using filePathMode 'From List', select the spreadsheet file from this dropdown list of files available in the specified folder.
  • filePath — If using filePathMode 'By Path (Expression)', provide the full path to the spreadsheet file on Nextcloud.

Output shape

a list of items where each item contains a JSON object with the sheet name under the key 'sheetName'.

The operation downloads the specified spreadsheet file, reads its workbook structure, and outputs each worksheet name as a separate item. If no file path is specified, it throws an error. Requires valid Nextcloud API credentials configured in the node.

Examples

Example 1: Get all worksheet names from a selected spreadsheet file in the root folder

Set 'From' to 'From List', choose folder '/' and select a file from the 'File' dropdown. The node outputs all sheet names as individual items.

Links

Discussion