Set MsExcel Parameters

Set MsExcel Parameters It allows you to assign the value of cells of Excel files to the parameters of a part.

Set MsExcel Parameters

Operativity

  • Drop the tool on the part,
  • A dialog box appears with the available fields (parameters), click on the Folder or File cell and select the Excel file,
    • A new dialog box appears showing the Excel sheets,
  • Select the cell you want to assign to the parameter and confirm.
  • Repeat for each field you want to assign.

Set MsExcel Parameters < At the end of the operation close the dialog box, an icon with the fx symbol appears near the anchor to indicate that an excel file is associated with the part.

Set MsExcel Parameters

For Show params

Right click on the part and choose Show Parameters Controlled by MSExcel

For Update params

Right click on the part and choose Update Parameters Controlled by MSExcel or use the tool Update MSExcel Parameters.

For Edit MSExcel file

Right click on the part and choose Open MSExcel file that controls Parameters… to open the file directly.

Tip

If the Excel file and the IronCAD file are not in the same directory, add (at the bottom of the dialog) the folders to search for Excel files.

Note

To remove the association with the Excel file, right click on the part choose Show Parameters Controlled by MSExcel and clear the grid, even just the Folder column.