Altair® Monarch®


Opening Excel Files in the Worksheet Design Window

This section describes the Worksheet Design window.

You can open an Excel worksheet in Worksheet Design via one of two ways:

  • Drag the Excel worksheet into Monarch Data Prep Studio and select Yes when the Excel Import Options dialog displays:


  • Go to Open Data > Spreadsheet > Excel Worksheet Design in the Start page or Add > Spreadsheet > Excel Worksheet Design in the Prepare window.


  • If you open a password-protected worksheet, Worksheet Design displays the Enter Password dialog:


    You will need to enter the correct password before you can proceed.

  • Worksheet Design displays all fields, including fields that are hidden in the worksheet.