TAST tool Menu
TAST Adaptors
Adaptors examples
TAST Integrations
Interesting features
Documentation of technical administration
Modeling recommendations
Training in the TAST tool
Sidebar
excel_file_adaptor
This is an old revision of the document!
Table of Contents
Excel File Adaptor
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
excel_file_adaptor.1537355990.txt.gz · Last modified: 2018/09/19 11:19 by tast
Except where otherwise noted, content on this wiki is licensed under the following license: CC Attribution-Noncommercial-Share Alike 3.0 Unported
