Skip to main content

Get Sheets

Retrieves all the sheets of an excel file

Common Properties​

  • Name - The custom name of the node.
  • Color - The custom color of the node.
  • Delay Before (sec) - Waits in seconds before executing the node.
  • Delay After (sec) - Waits in seconds after executing node.
  • Continue On Error - Automation will continue regardless of any error. The default value is false.
info

If the ContinueOnError property is set to true, errors will not be caught when the project is executed, even if a Catch node is used.

Input​

  • Excel File Descriptor - The excel file descriptor ID as a message. This ID is generated by the Open Excel or the Create Excel node.

Output​

  • Sheets - The list of the sheet names of the specified excel file as a string array (e.g. ["Sheet1","Invoices","Summary"])