Spiegel6 Spiegel2 Spiegel14
OptiLayer:  Your Partner in Design and Post-Production Characterization of Optical Coatings


Import Data from Excel and Import from Multiple Files

Import Spectra from Excel. This command first opens File Open dialog, where you need to select a corresponding MS Excel file with measurement data. 

OptiChar performs smart scan of Excel file layout and represents all extracted data in the Import Spectra from Excel window. On the bottom all worksheets are listed and can be changed using tabs similar to Excel file, each extracted spectrum is represented in the list to the left with specification of column name, cell range and future measurement file name.

import measurement data in Excel

The names can be adjusted if necessary editing cells in the Measurement Name column. Import column allows to deselect some spectra excluding them from Import operation.

It is important to use Options dialog in order to set correct types of spectra, incidence angle and X- and Y-axis units.

import spectral data from Excel

Import Multiple Files option greatly simplifies measurement data import. Using this option you can import many files in one simple operation. File format is recognized automatically by OptiChar/OptiRE.

Import Multiple Files command opens the corresponding window. On the top of the window the currently opened folder is presented, it could be changed using a Browse button  at the right side. Reload button initiates reloading of all files in the current folder, it may be useful, if new files were added, or some files were deleted in this folder by some other program.

Instead of using Browse button it is possible to use drag-and-drop operation. Simply select the files of interest or a folder containing these files and drop it onto the right part of the window.


 Import multiple measurements

Easy to start

Icons 100x100 1OptiLayer provides user-friendly interface and a variety of examples allowing even a beginner to effectively start to design and characterize optical coatings.        Read more...

Docs / Support

Icons 100x100 2Comprehensive manual in PDF format and e-mail support help you at each step of your work with OptiLayer.



Icons 100x100 3If you are already an experienced user, OptiLayer gives your almost unlimited opportunities in solving all problems arising in design-production chain. Visit our publications page and challenge page.


Go to top