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 ...

    • How to insert an Excel spreadsheet into an ICD Drawing.

      In the ICD: 1. Go to the Main Menu. 2. Create, Object. 3. Select From file. 4. Browse to the file, OK to insert into the drawing. Note: Selecting the option to "Link" will allow the inserted document to update when edited outside of IronCAD. Once ...

    • IronCAD Public Access SDK Technical Manual for Non-Runtime Access to IronCAD Data

      The IronCAD Public SDK allows a user to access information about their IRONCAD file without needing to open the software itself. The user will have access to information such as file properties, file GUIDs, part/assembly properties, and file ...

    • 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 ...