How to use Excel with ExcelFileGenSheet  to generate AutoCAD dwg's from template.

Here you will learn how you can use ExcelFileGenSheet to generate AutoCAD documents from excel. To use it you need as minimum AutoCAD version 2002.

Here you see a function schema which I will use as template for all other drawings.

The task is to load the template from Excel, find the attributes in the drawing, write the values and save the file with name from Excel sheet.

The program knows which attributes it should use from the header on the excel sheet.

No we have to define in which column the program should read the filename for the template.

 Here you see how it is working.

Here we have an example with the attributes written from ExcelFileGenSheet.