Whenever you use the @OLE function to export solutions to spreadsheets, you will receive a summary of the results of the export process. This summary is called the export summary report. These reports will be found at the top of the solution report window. There will be one export summary report for each @OLE function in the model used for exporting solutions. Here is the export summary report obtained when we exported the solution of the Wireless Widgets transportation model to Excel using @OLE:

Export Summary Report

---------------------

Transfer Method:  OLE BASED

Workbook:         \LINGO\SAMPLES\WIDGETS.XLS

Ranges Specified:               1

  VOLUME

Ranges Found:                   1

Range Size Mismatches:          0

Values Transferred:            48

The Transfer Method field lists the type of transfer used. @OLE transfers will be listed as "OLE BASED".

The Workbook field lists the name of the workbook the export was performed on.

The Ranges Specified field lists the total number of ranges specified in the export function followed by a listing of the range names.

The Ranges Found figure lists the number of ranges actually found in the sheet from the total number specified.

In general, the spreadsheet range should have one cell for each data value being exported. If a range has too few or too many cells, it gets counted in the Range Size Mismatches field.

The Values Transferred field lists the total number of data values actually transferred into all the specified ranges.