Excel Import Wizard

Optimumcut-1D v3 Product Development

A common requirement of our customers in Optimumcut-1D is the ability to import data from Excel. This data will typically come from other software packages like Autodesk Inventor, that are used to design complex curtainwall or window systems. Typically the data is exported from the other software in a Microsoft Excel format and would be tedious to enter manually in Optimumcut-1D.

The Excel import feature is available via a right-click menu on the Linear Cuts, Sheets and Accessories sub items of a component.

After selecting the "Import" menu item, the import dialog appears.

The import dialog first requires that you select the worksheet that contains the data to be imported. This can be done with the drop-down list at the top of the dialog. After selecting the worksheet, the data form the worksheet is displayed.

It is common for worksheets to contain header information that should not be imported. Optimumcut-1D attempts to automatically determine which row contains the first row of data to be imported. If Optimumcut-1D gets this wrong, the first row of data can be changed by clicking on the row header in the left-hand column. The numbered rows should then match the rows to be imported.

Each column in the worksheet then needs to be associated with a field within Optimumcut-1D. This is accomplished with the drop-down list within each column header. Once all the columns are associated with Optimumcut-1D fields, clicking OK imports the data directly into Optimumcut-1D,