Excel link

 

 

 

Links/Videos:

 

 

This command allows you to import or export values from or to an Excel document.

 

Creation stages / Use:

 

Select the Construction > Parameters > Excel link... command from the drop-down menu.

 

  1. Select the Excel document:

  2. Click the Open button.

  3. Select the mode :

  4. Validate with the button.

 

The command result is displayed in the Parameters area.

 

 

The parameter types must be real, integer, boolean, text, enumeration, user enumeration or code.

Excel supported versions are : 2003, 2007, 2010 and 2013.

 

 

Modifications / Additional information:

 

To be usable, Excel document cells have to be named by adding prefix TOP_ in front of the parameter name is shown below:

 

Example: The named cell TOP_a allows you to drive the a or A parameter in TopSolid.

 

 

Excel does not manage some characters used to name columns, especially space character. In this case TopSolid will use double underscore '__' instead of the space character (example with parameter named 'd 1': 'TOP_d__1'). Prohibited characters into Excel are spaces and all special characters except ' \ '.

Furthermore, Excel does not differentiate case (capital and non-capital letters). Link with D and d parameters will not work properly.

 

 

To be able to use some parameters in Excel,like for example, the code parameter, you have to:

  1. retrieve its system name without the '$' character and copy it.

  2. paste this name to name the Excel cell as for a common parameter, but by replacing the '$' character by 'TOP__'. (There are 2 underscores).

 

Example: The named cell TOP__TopSolid.Kernel.TX.Properties.Code allows to drive the code parameter in TopSolid.

 

 

 

In an Excel document, the Formula context allows you to modify the cell names.