how to connect excel sheet in openSTA-need immedia
issue while trying to read the values from excel sheet.
Step 1: Select "Variable...Create" from the top menu of the Script Modeler. Enter the variable name, scope, type and order. Set the Value Source to "Database". Select Next.
Step 2: Change the Data Source value to "Excel Files" and select Next. Select your Excel file using the dialog box that now appears.
Step 3: Select the radio button for "Query" and enter a query in the window that will select the correct column from your Excel workbook.
For example "Select StateCode from ?Sheet1$" and click on Next button.