Somebytes SoftwareSomebytes Software Development



ExcelFileGenSheet, is an Excel tool which can create textbased files or AutoCAD dwg's from a template.

ExcelProGen is a template engine, controlled from Excelsheet, which can create AutoCAD/BricsCAD oder textbased files from templates. It  can import attributes from AutoCAD to Microsoft Excel as well as export the data to AutoCAD.

With this tool you are able to generate text files from templates like xml, html, txt, dxf. ini.

Each of the Excelrows will create one new file from a template by using placeholders.

With the Add-In you can create AutoCAD files from template in .dwg, or update these files with new values. We are using COM automation, so you can't use AutoCAD LT here. Beside AutoCAD you can use BricsCAD as well.

These functions are available:



DXF,DWG or tiextgeneration from Excel

After Installation of ExcelProGen you will find a new group in your Add-Ins ribbon. With this you can control the generator. 

How it works (AutoCAD):

As you can see in the screenshot, there are new menu items in Add-Ins tab like Import, Export, Generate and Settings.

ExcelProGen - AutoCAD DXF generation by template

You can import your DWG attributes via CAD import. For each block or "block selector" a line is created in the Excel table. To use the function, you need AutoCAD or BricsCAD on your computer.

With the "Generate" button you create files from a template. To do this, you need the "Template" and "File" fields in your Excel spreadsheet, which on the one hand represent the template and the output file. To set attributes, the block name may be specified if the attribute is to be replaced in only one block, and a "block selector" which describes the block by an attribute. Furthermore, you can replace text passages within attribute values, here you must set the appropriate check mark in the settings. It is also possible to provide the fields TEXT and MTEXT with placeholders, which are then replaced by "Generate". Again, you will find a checkbox in the settings.

With the export button you can replace values in attributes of the DXF files, the export button works similar to the "Generate" button, with the exception that the field TEMPLATE is not used.

How it works (text):

Your text templates contain placeholders, which are defined as header fields in the Excel spreadsheet. After you have filled the fields FILE and TEMPLATE with the templates and the file names to be created, you can start the process by "Generate".


Use Cases:

  1. Creation of documentation in which some data changes per generated file.
  2. Generate Sourcecode.
  3. Creation of configuration files. (xml,ini usw.)
  4. Mass-generating of technical drawings, circuit diagrams, measuring and control technology together with AutoCAD (Example).
  5. Generating drawings without AutoCAD using dxf as a template - DXF is text-based, so you can work with your placeholders.
  6. Update attributes of AutoCAD files with new values.
  7. Automatically generate HTML files. (Example)
  8. Generate test logs in bulk.
  9. Product descriptions with different information of dimensions

Minimum system requirements: Excel 2010 oder höher.