Exporting Data from Excel

You can export data from one or more worksheets using the optiSLang Export wizard.

To export data:

  1. On the Excel Ribbon, switch to the Add-ins tab.

  2. Click Export.

    The optiSLang Export dialog opens.

  3. On the worksheet, select the cells to export data from.

    Note:  If you already have cells in the worksheet selected that you want to export, click Use current selection.

    The Input parameters pane is dispayed and the Data range field displays the selected cell range.

  4. Select an option from the Data layout drop-down menu.

    • Horizontal (One row per design): Select this option if the data is organized horizontally.

    • Vertical (One column per design): Select this option if the data is organized vertically.

  5. Select an option from the Parameter names drop-down menu.

    • Automatic (first row): Select this option if the active selection contains the parameter names in the first row or column.

    • Manual range: Select this option if the automatic parameter name detection can not be applied (for example, the cells containing the parameter names are not adjacent to the data array).

      After selecting this option, select the range of cells containing the parameter names and click  .

  6. You can add more than one selection range with input data. This can be useful when input parameters do not form one single rectangular array but are divided up into different blocks.

    To add multiple ranges:

    1. From the Available Ranges drop-down menu, select Empy range.

    2. Select a new range of cells from the same or a different worksheet.

    3. To the left of the Data range field, click   to save the new range.

      The range is added to the list of Available Ranges.

      To remove a range from the list, select the range from the Available Ranges drop-down menu, and click Remove.

  7. To switch to the Output parameters pane, click Next.

    The pane is displayed.

  8. Repeat steps 4-6 to define the output parameters.

  9. To switch to the Design numbers pane, click Next.

    The pane is displayed.

  10. Select an option from the Design enumeration drop-down menu:

    • Continuous (starting with 1): Select this option if there are no design numbers inside the worksheet.

    • From range: Select this option to select a range of cells containing design numbers.

      After selecting this option, select the range of cells containing the design num bers and click  .

  11. To complete the wizard, click Finish.

  12. Browse to the specific location to save the data, rename the file as required, and click Save.