TAST DokuWiki

This page is read only. You can view the source, but not change it. Ask your administrator if you think this is wrong.

===== Excel File Adaptor =====

{{:TAST-icon.png?nolink&70|}}

==== Setup ====

In the initialization process, the Excel adapter will try to read and analyze the Excel sheet indicated by the NumSheet parameter.

The adapter will call the GetExcelSheet function, in this way the user can operate on the data without drawing a GetExcelSheet message in the diagram.

==== Initialization Parameters ====

  * **FilePath:** Represents the full path and name of the Excel file that represents this instance of the Excel adapter.
  * **NumSheet:** Indicates the number of the sheet within the Excel workbook on which we want to work.

==== Functions ====

  * **getExcelSheet(SheetNum):** Reads the Excel worksheet indicated by the NumSheet parameter and returns the results as a variable of type TastTableData to the executor to allow working with the data in later steps of the diagram.

  * **getNumColumns():** Returns the number of columns of the TastTableData generated when reading the Excel sheet.

  * **getNumRows():** Returns the number of rows of the TastTableData generated when reading the Excel sheet.

  * **getTableValue(RowNum, ColNum):** Returns the contained value of the cell indicated by the RowNum and colNum parameters.

  * **getTableValue(RowNum, ColNum):** Returns the value contained in the cell indicated by the Position parameter that is filled with the values row,column. In the same function, the values of several cells can be obtained

TAST DokuWiki

User Tools

Site Tools

Page Tools