Excel Import Wizard

Optimumcut-1D v3 Product Development

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

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 from 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 ready to undertake linear material optimization and produce optimized cutting lists.