AvaSoft Application Software - Export to Excel

AvaSoft-XLS is an add-on application that enables Avasoft Full to output history channel data and/or complete spectra to Microsoft Excel.

It uses OLE (Object Link Embedding)-Automation, which is a technology that enables AvaSoft to remotely control Excel, opening sheets and copying data into cells.

With AvaSoft-XLS two different modes are possible:

• 1. Exporting data online in a paste format to Excel workbooks, for each spectra or function output a new column or row is generated. At the end of a predefined number of scans the export is stopped and the Excel sheet(s) can be saved to a file.
• 2. Exporting data to a fixed position in a predefined Excel worksheet. Each spectrum or function output is copied to the same position as the previous spectrum or function output in an overwrite mode. The user can now address those data cells from another application, like Labview or Matlab and do on-line data processing and analyses.

On modern hardware, a data transfer speed to copy complete 2048 pixel spectra to Excel with as little as 50 ms overhead per scan can be reached.

The output functions to be exported can be history channel functions, color parameters (in combination with AvaSoft-COL), irradiance parameters (in combination with AvaSoft-IRRAD) and chemometric parameters (AvaSoft-CHEM).

AvaSoft-XLS can be ordered as add-on to AvaSoft-Full for the AvaSpec.