Read Excel File Worksheets

Description

Reads a Microsoft Excel .xlsx file and returns a list of worksheets within as a text-list

Input Ports

Name	dataType	sourceType	required	description
File path	text	link-manual	true	The path to the excel file you want to read from

Scenarios

• The user wants a text-list of all the sheet names that exist inside of an excel file.

Use case

Inputs

• File path: C:/Users/admin/Desktop/example.xlsx
• Sheet name: Sheet1
• Fields: {a1, text; c1, text;}

Tutorial video

Experienced tips

• If the file path value is empty, the process will stop and provide you with this error Excel file path is required
• When the file path cannot be found, the process will stop and provide you with the error ENOENT: no such file or directory

Output

Search Tags

get targeted cells from excel target cell