文章目录
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