Read Cells From Excel

Description

Reads targeted cells from a Microsoft Excel file at the specified file path

Input Ports

Name	dataType	sourceType	required	description
File path	text	link-manual	true	The path to the excel file you want to read from
Sheet name	text	link-manual	true	The sheet name inside of the excel file you want to read from
Sheet cells to read	dataField	link-manual	true	The cells inside the sheet you want to read, must be a cell key value, eg. A1, B27

Scenarios

• The user wants to read specific cells from a excel file.

Use case

Inputs

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

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