The Unscrambler® - Functional FAQ

How to import Lotus file format into Unscrambler?

  1. Open Unscrambler select menu File - Import - Lotus
  2. Lotus files can be created in Excel also.


    D19

  3. The Lotus worksheet import handler accepts both WK3 and WK4 files

    D22

  4. Give the range in the Import Worksheet.

    D23

  5. The data will be imported according to the range given in the Worksheet.

    D24

How to import Excel file format into Unscrambler?

  1. To import data from Excel into The Unscrambler, you have three possibilities:

    i. Use the File - Import - Excel or File - Import 3D - Excel functions (see The Unscrambler help system for a detailed description)
    ii. Use copy/Paste functionality (data only)
    iii. Use drag and drop functionality (data, sample names and variable names must be handled separately in three steps)

    D25

    D26

    D27
  2. To import Non-numeric data, proceed as above and select the relevant option given in the dialog.

    D28

    D29


How to import JCAMP-DX file format into Unscrambler?

  1. Use menu File - Import - JCAMP-DX or File - Import 3D - JCAMP-DX. For JCAMP-DX files, the standard file browser is replaced by the dialog JCAMP-DX Import where you may select one or several source files for the import.

    D30
  2. No additional parameters need to be specified since all relevant information is stored with the JCAMP-DX format.

  3. Browse the folder and select the file to be imported.

    D31

  4. If relevant, click OK to access the next dialog "Import 3-D" where you will specify your 3-D table layout (see the Unscrambler help, Import 3-D Dialog for a detailed description).

[ BACK | TOP ]