Skip to main content

Import from Excel

This functionality is designed to automatically create and add labels to the data and fill with content taken from an Excel document.

The Excel sheet must fulfill a few criteria, e.g. it must contain a list with:

  • the spectra (object) names in column A, the only column that must not have a header
  • one or more columns with different headers, corresponding sample name cells filled with content

Note, avoid the following scenarios:

  • two columns with identical header: A warning message for duplicate columns is shown
  • a column without header, except column A. Columns without header will be ignored for import
  • a column with numerical header is not allowed (will be ignored for import)
  • empty columns in between will be ignored for import

Import from Excel command​

To import label information from an Excel sheet and add to spectral data, please follow the instructions below:

  1. Load the spectra for modification

  2. Expand the Tools menu and click Label Editor

  3. Press the Import from Excel button

  4. Select the Excel file, click Open and confirm the information dialog with OK

  5. Use as Data Assignment: Use Spectrum Name

  6. Confirm with OK

 

Below is an example to illustrate the workflow:

  1. Edit the Excel file and insert a new column A. Enter as header: LIMS

  2. Enter valid values in the new column

  3. Open the Label Editor, add a new label LIMS and fill in the same values entered in the Excel

  4. Use as Data Assignment: Use Common Label.

  5. Set Mapping Reference Label: LIMS

  6. Confirm with OK