LINGO allows you to place interface functions in a model's data section to automatically perform exports to Excel each time your model is solved. In this section, we will focus on how to place interface functions in your model to export your model’s results to Excel.

The Importing Data from Spreadsheets section demonstrates how the @OLEinterface function can be used to import data from Excel. As demonstrated in the Using @OLE to Export Solutions to Excel and Exporting in a Transportation Model with @OLE sections, these functions may also be used to send solutions back out to Excel. As with imports, @OLE uses OLE technology to interface with Excel.