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:
Worksheet Design displays all fields, including fields that are hidden in the worksheet.
You will need to enter the correct password before you can proceed.