Somebytes SoftwareSomebytes Software Development

ExcelFileGenSheet

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

This Excel 2007/2010 template makes it possible to generate textbased files from templates automatically. It will create one file by Excel-row.

If you are using AutoCAD (min. version 2002), you can also create AutoCAD drawings from DWG templates, or you can update AutoCAD files with new values. The Excel sheet is using COM automation for its work, so you can't use AutoCAD LT. ExcelFileGenSheet is reading blocattributes to replace its values. It also checks TEXT and MTEXT for placeholders defined on the sheetheader.

How it works:

After Installation of ExcelFileGenSheet you will find a new template if you go to Excel => File => New => My Templates with name FileGenSheet. If you open it, you will find a user interface beside the sheet with tools to create your documents.

To create files you have to define one column with filenames. ( in the sample i use %FILENAME% ) The sheet contains one column which will tell the engine which template to use. ( -in this example I use: %TEMPLATE% ) All other fields are one of the placeholders in the template file.

Excelfilegensheet Dokumente generieren mit Excel

ExcelFileGenSheet is very convenient to:

  1. Create documentations.
  2. Generate code files.
  3. Create configuration files. (xml,ini usw.)
  4. Create control loop schemas, used in automation industry. (see an example).
  5. Create drawings without using AutoCAD. In this case you can try it with dxf files which are text based.
  6. Update many AutoCAD drawings with new attributes. (see an example)
  7. Create HTML files. (see an example)
  8. Productdescriptions with different dimensions for example. ( eBay )

Here you can download your copy of ExelFileGenSheet (to use it, you need Excel 2007 or up.)

Respectively you can use the offline install package as well.

Since Office 2013 you may not find the template. You can do the following in order to find your personal templates like ExcelFileGenSheet.

  1. In Windows 10, copy and paste the following in the Cortana Ask me anything box, and then press Enter: %appdata%\Microsoft\Templates\ (In earlier versions of Windows, click Start > Run, and paste that in the Open box).

  2. Copy the address that's displayed in the File Explorer address bar.

  3. In your Office program, click File > Options > Save, and then paste the address into the Default personal templates location box.

Make sure you do this for each Office program. After you’ve updated your template location, any new templates will be saved to this default location.


Please register if you use it longer than 30 days.