Create a JAVA Excel Workbook
The Excel model is an Excel workbook with a formula for execution and a list of input/output cells (mapping) used in the formula.
 |
• Excel workbook would need to have only two sheets.
• Formulas spanning across sheets are not supported. You would only use the supported formulas listed while building the Excel JAVA agent. See Configure the Microsoft Excel JAVA Agent for more information.
|
Required Excel file structure
The examples below provide instructions to create an Excel workbook that can be used during model creation.
1. Example 1 - Create an Excel sheet to add two numbers and show output in third cell.
◦ Sheet 1 - Formula Evaluation sheet.
Value of cell A3 = Sum of cells A1, A2.
◦ Sheet 2 - Input/Output list (mapping) sheet.
Cell A1 and A2 provide input for calculations, and the output is shown in cell A3.
A list of input and output cells should be provided in the mapping sheet (Sheet2) as shown in the image below.
2. Example 2 - Calculating the average of cells from different columns.
a. Sheet 1 - Calculation sheet.
▪ Value of cell D1 = Average of cells A1, B1, C1.
▪ Value of cell D2 = Average of cells A2, B2, C2.
▪ Value of cell D3 = Average of cells A3, B3, C3.
b. Sheet 2 - Input/Output list (mapping) sheet
▪ In the first row, cells A1, B1, and C1 are used as input, and the output is shown in cell D1.
▪ In the second row, cells A2, B2, and C2 are used as input, and the output is shown in cell D2.
▪ In the third row, cells A3, B3, and C3 are used as input, and the output is shown in cell D3.
A list of input and output cells should be provided in the mapping sheet (Sheet2) as shown in image below.
