Homepage | About EASA | Contact
Introduction | Session 1 | Session 2 | Session 3 | Session 4 | Session 5 | Session 6 | Session 7 | Session 8
Estimated completion time → 10 minutes.
An EASAP can interact with Microsoft Excel spreadsheets within the USER INTERFACE branch both via cell references in data entry objects and ACTIONS within an EVENT PROCESSING. However, in the PROCESSES branch, only the ACTION mechanism is available. In this case the EVENT occurs on the EASA Server during a batch EASAP submission instead of on the user’s 'client' computer during an interactive user interface session.
In this practical session we write the results of the latest stock search into a pre-formatted Excel spreadsheet to create a report from the EASAP. This spreadsheet will then be made available to the user via a link in the report generated as described in the next practical session.
First we specify the spreadsheet that will interact with the EASAP. On the EASAP Tree,
We are ready to add a WRITE EXCEL ACTION to specify cells in the spreadsheet in which the EASAP will write the current stock data.
Parameter Name | Parameter Value |
---|---|
Sheets: | Results, Results, Results, Results, Results, Results, Results, Results |
Ranges: | A17, B17, C17, D17, E17, F17, G17, H17 |
Types: | COLUMN, COLUMN, COLUMN, COLUMN, COLUMN, COLUMN, COLUMN, COLUMN |
Lists: | Symbol, Company, Industry, SPIndex, Exchange, Price, Sector, repeated_format_Revenue |
Queue: | TRUE |
All four essential parameters of a WRITE EXCEL ACTION must contain the same number of entries. here write_excel_action_Results has eight (8) values in each parameter.
For Type: → 'COLUMN' only the starting cell is specified in the Ranges: parameter as it will write data down a column in the spreadsheet starting at the specified cell and continuing until each of the LIST's specified in Lists: have been completely written.
We will create a similar WRITE EXCEL ACTION to write the financial query filters in the spreadsheet.
Parameter Name | Parameter Value |
---|---|
Sheets: | Named Range, Named Range, Named Range |
Ranges: | FieldName,Exchange,Sector |
Types: | NORMAL RANGE, NORMAL RANGE, NORMAL RANGE |
Lists: | map_Query_Report, inputbox_Exchange, inputbox_Sector |
Queue: | TRUE |
At this point the NAMED RANGE LIST will be generated automatically and the EASAP Tree should look similar to the following,
We have completed Session 6 and either proceed to the next session or take a break and exit out of EASAP Builder.
Introduction | Session 1 | Session 2 | Session 3 | Session 4 | Session 5 | Session 6 | Session 7 | Session 8