Parameter Expression string for connecting to Excel

Parameter Expression string for connecting to Excel

It is possible to connect your Parameter to a cell in an Excel spreadsheet by entering this string in the Expression field of the Parameter:

(excel ("C:\Temp\Values.xlsx", "Sheet1", "A1") * 0.0254)

The 0.0254 multiplier at the end is for converting meters back into inches since the Parameter table works in the system units of meters.

There is a video demonstrating this setup located here: https://www.youtube.com/watch?v=O2Oqt-f8-Hc
    • Related Articles

    • Wrong Parameter Error when saving to network drive

      If you encounter an "Wrong Parameter Error" when saving a part to a network drive, and cannot save the file, try going to the Virus & threat protection settings, managing settings, and adding IronCAD.exe (or the product you are using) in the ...
    • Changing the SmartDimension font

      It is easy to change the dimension font size for 3D SmartDimensions in Options, General but if you want a different font (for example bolder) you have to edit the Windows Registry. NOTE: Editing the Windows Registry incorrectly can ruin your ability ...
    • Custom Properties by XML files

      Problem description Provide a customizable way for users to auto-populate text fields in the drawing such as to support auto-fill of titleblock and the like. The process should be customizable without the need to write code. Also, it needs to support ...
    • If encountering issues saving to a network drive (or connected Google Drive for example), Enable Backups of Files

      When using drives like Google Drive, there is a sync process they run. If that sync is happening when saving, then you can run into issues potentially. (Not only with IC but with others as well). We have a registry setting that can save a backup when ...