Excel Helper APIs

Magic Model Analyst provides APIs to import data from an Excel file into runtime values, and export the runtime values to an Excel file. Either a «DiagramTableMapToDataSource», an Instance Table linked to an Excel file, or an «ImportMap» can be used as the mappingElement.

The provided APIs in Magic Model Analyst are given in the following pages

• Reading runtime values from an Excel spreadsheet
• Writing runtime values to an Excel spreadsheet
• Setting a cell value in an Excel spreadsheet
• Getting a cell value from an Excel spreadsheet
• Getting the latest row number from a spreadsheet
• Updating fUML runtime value with value from a spreadsheet