【GH】【EXCEL】P2: Read DATA SET from EXCEL into GH

Read

Read Data

Excel Data source

GH process and components instruction

Read Data

---

Read data from Excel

---

Input parameters:

• Worksheet (Generic Data) A Worksheet, Workbook, Range Object, Excel Application, or Text Worksheet Name
• Range (Generic Data) A Range Object or Text Address (ex. A1:B1)
• Activate (Boolean) If true, the component will be activated

Output parameters:

• Range (Generic Data) An Excel Range Object
• Data (Text) The data from the range where the Row is a branch with columns in a list.

• Data can be read from a specific Workbook object and Range object
• Worksheet names and Range addresses can be used if the Worksheet is active.
• If just a Worksheet is given the used Range of that Worksheet will be returned.
• If no Range or Worksheet is provided, the topmost worksheet is used and the full extent of content is returned.

Read Data Live

The Live component will refresh when changes are made to a specifie worksheet.

Live Worksheet

---

Updates when changes are made to the worksheet

---

Input parameters:

• Worksheet (Generic Data) A Worksheet, Workbook, Range Object, Excel Application, or Text Worksheet Name
• Activate (Generic Data) The active status of the component

Output parameters:

• Worksheet (Generic Data) An Excel Worksheet Object