In this part we regulate information for the export of the nomenclatures to the Excel format.

A first tab concerns allows:

  • To specify the folder where your examples (model) of Excel nomenclature are recorded. It is possible to select models with the format “xls” or “xlsx”.


 


Here the 2 examples are in the folder “C:\Programme Files\Axemble\MyCADtools\SmartBom\Fichiers Excel”.

The nomenclature can be inserted starting from a particular position (column-line) if, for example, there is information to reveal before the nomenclature (logo example, date, information company etc…). It should be known that a sheet by nomenclature, specified in the project, will be created automatically in the file of Excel export.


Example :

 


If the option “Addition of a column with the image of the document” is checked, the result will be the following:


 


  • To specify the folder and the name of the file of export of the nomenclature. If you do not modify the noun, this one will be automatically incremented (Example: SmartBom, SmartBom1, SmartBom2 etc…). This folder can be in local or on the network in order to divide it with several work stations.


 


Two solutions are possible for the choice of the site of the files of Excel export   :

  Either one selects a folder, that is to say one specifies to export the Excel file in the folder of the assembly.


The name of the file of export can be personalized:


 

   



  • The file can take same name as the assembly.
  • Name can be indicated.


  • Name can recover the name of a property of the assembly.
  • Name can take the name of the active configuration of the assembly.
  • Name can recover the increment of a counter defined with the tool SmartProperties.


The ''Name of the file'', can be made up by using the characters ''&'' in order to concatenate of the values.

Example :

 


One can ask so that this dialog box open during the recording of the file in order to modify the noun of it, the folder or quite simply to update an already extracted nomenclature .

  • To check some additional options.


 


Title of the nomenclature: Poster, in heading of the nomenclature, the name of that defined in the project.

To keep the police for export in Excel: When the bill of character was modified this police can be preserved by checking this box, if not it is the font face defined in the Excel model which will be applied.

To display this window at the time of Excel export: One can ask so that this dialog box open during the recording of the file.

Not to export the name of the columns: If this option is checked the name of the columns will not be displayed in the Excel nomenclature.

Not redimensionner columns in Excel: If this option is checked the dimensioning of the column is not to apply and the columns remains in the state of the model.