Read Excel File

Description

Reads a Microsoft Excel .xlsx file at the input path and outputs the file content as a data-list

Input Ports

Name	dataType	sourceType	required	description
Header options	text	manual-only	true	Header options will keep or remove the first row
Fields	dataField	link-manual	true	If the sheet contains 4 columns, you are required to add 4 fields
File path	text	link-manual	true	The path to the excel file you want to read from
Worksheet name	text	link-manual	true	The sheet name inside of the excel file you want to read from

Scenarios

• The user wants to read 4 columns from an excel file as a data-list

Use case

Inputs

• Header options: Include headers
• Fields: {Month, text; BROKER, text; CLIENT, text }
• File path: C:/Users/admin/Desktop/example.xlsx
• Worksheet name: Sheet1

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 amount of pages that exist inside a pdf