Writing and Reading MS-Excel Spreadsheet Information

LANSA

Writing and Reading MS-Excel Spreadsheet Information
Example 82 - Rating: specific
The Things that Make Up this ExampleTo Execute this Example

This example demonstrates a simple scenario where a Visual LANSA form writes employee salary information into an MS-Excel spreadsheet. It can be edited using MS-Excel and then saved. The saved spreadsheet information can then be read back again by the Visual LANSA form (for some unspecified subsequent processing).

This example, by itself, merely demonstrates how information can be written to and read from MS-Excel spreadsheets. However, when this basic techniques is combined with other facilities much more complex business objectives can be achieved.

For example, an employee time sheet could be prepared and written into an MS-Excel spreadsheet. The spreadsheet is then emailed to the employee who fills in some details and emails the resulting spreadsheet back again. The arriving spreadsheet is then read in and used to update a database system.





Keywords
ExcelSpreadsheet
Example 82