Create dynamic blocks using an excel list

[Anonymous]

Hi all,

is there a way how I can automatically generate dynamic blocks in autocad using an excel list? The blocks should be placed at the coordinates (e.g. 10, 13, 201) of the list containing the attriubutes e.g. TAG, WIDTH and HEIGHT.

Example given:

TAG	WIDTH	HEIGHT	x	y	z
A	1	2	10	10	10
B	1	1	10	20	10
C	1	2	10	30	10
D	1	2	10	40	10
E	2	1	10	50	10

I made a few scripts in the past months but this exceeds my knowledge. I would be really thankful if somebody could guide me how to do this.

Kind regards,

Robert

[JBerns]

@Anonymous,

Just to clarify,  when you say "create dynamic blocks" do you mean create the block definition or insert a dynamic block already defined?

If the latter, would you be able to share a drawing that contains your dynamic block?

Regards,

Jerry

[Anonymous]

Create a block definition, the block could be just a circle (e.g. diameter 5) with the named attributes.

If there is no way to create one, then i can define blocks in advance.

Thanks for the help in advance! 

Warm greetings,

Robert

[JBerns · Accepted solution]

@Anonymous,

Does the block have to be a dynamic type? It becomes a bit more complicated to create a dynamic block programmatically.

If it can be a standard block, the X and Y scale can be adjusted to achieve the WIDTH and HEIGHT dimensions from the table. 

Does the table have to be an Excel file? A CSV file, being text, is much easier to read as compared to an Excel file.

Here are other forum posts where users needed to insert blocks by reading data from Excel/CSV files.

     Lisp to insert blocks from csv or excel file - AutoLISP, Visual LISP & DCL - AutoCAD Forums 

     Insert block, but reading from Excel - Autodesk Community - AutoCAD 

     HELP......With Insert Block Lisp From Excel File 

     Read CSV by Lee Mac 

Let us know if you need more assistance to develop the code.

Regards,

Jerry

[Anonymous]

Hi Jerry!

Thank you so much for the links! I actually managed to resolve my issue with an autocad script! Its not elegant but gets the work done!

The links you mentioned helped me alot! I will mark this answer as solution.

Regards,
Robert

[JBerns]

Robert,

You are most welcome. Great to hear you have a solution. Glad to be of service.

Regards,

Jerry