topic Re: inserting blocks by using values in excel sheet in AutoCAD Forum

inserting blocks by using values in excel sheet

ebru_kilinc — Tue, 09 Jan 2024 10:40:46 GMT

I am searching a method to insert blocks by using excel sheet which contains coordinate and rotation information. My blocks have rotation, x and y attributes. I would like to insert my blocks with correct coordinate and rotation by using my excel sheet. I managed to insert the blocks with several steps but only with the correct x and y values. I can't rotate the blocks by using the rotation value in the excel sheet. do you have any suggestions/ lisps to do the trick?

Re: inserting blocks by using values in excel sheet

leeminardi — Tue, 09 Jan 2024 12:48:59 GMT

This thread may be helpful (post #8 for syntax). Note the use of CHAR(34) to distinguish between a quote " used in Excel from those needed in AutoCAD if block names include spaces.

Re: inserting blocks by using values in excel sheet

ebru_kilinc — Tue, 09 Jan 2024 13:43:31 GMT

Thank you for the prompt reply. My drawing is in 2D. Unfortunately I couldn't manage the insert blocks with correct rotation. Most probably I am making a mistake somewhere in the concatenate function. I am attaching the drawing and my excel sheet here. You can find the highlighted rotation values in the excel sheet.

Re: inserting blocks by using values in excel sheet

leeminardi — Tue, 09 Jan 2024 14:29:25 GMT

Your Excel sheet does not inlcude your attempt at writing the concatenate command. Take a stab at it and if you get stuck post your question here.

Start by manually entering the command -insert and note the order of prompts you get and your response. If your block name does not include space characters the syntax to the Excel concatenate function is much simpler. Hint, after specifying the cell of the bloack name you need to enter "r" to indicate that the cell listed next will be a rotation value if it is to be referenced from the worksheet.

Does the attribute you named "rot" have anything to do with the rotation you want for the block or do you just wish to rotate all blocks by the same amount when inserted into the drawing?

Re: inserting blocks by using values in excel sheet

ebru_kilinc — Tue, 09 Jan 2024 15:08:18 GMT

ROT is the attribute name for the rotation. The blocks has to be rotated based on those value

Re: inserting blocks by using values in excel sheet

leeminardi — Tue, 09 Jan 2024 15:16:03 GMT

ok then, just reference the rot cell after you specifu "r" in the concatenate command.

Re: inserting blocks by using values in excel sheet

ebru_kilinc — Tue, 09 Jan 2024 15:54:59 GMT

Unfortunately, I am not an expert in excel 🙂 You mean like this?

Re: inserting blocks by using values in excel sheet

ebru_kilinc — Tue, 09 Jan 2024 15:56:22 GMT

Unfortunately, I am not an expert in excel 🙂 You mean like this?

Re: inserting blocks by using values in excel sheet

ebru_kilinc — Tue, 09 Jan 2024 15:57:53 GMT

that is not working

Re: inserting blocks by using values in excel sheet

leeminardi — Tue, 09 Jan 2024 17:07:26 GMT

Reading through the link I referenced it should be noted that the AutoCAD variable ATTDIA should be set to 0 (not the default 1) to keep the dialog box for attributes from appearing. Do this before pasting in the commands from Excel.

Here's the syntax for the command that you can fill down to other rows. I'll admit that it is a bit cumbersome.

=CONCATENATE("(command ",CHAR(34),"-insert",CHAR(34)," ",CHAR(34),C2,CHAR(34),CHAR(34),F2,",",G2,CHAR(34)," ",CHAR(34),1,CHAR(34)," ",CHAR(34),1,CHAR(34)," ",CHAR(34),E2,CHAR(34)," ",CHAR(34),D2,CHAR(34)," ",CHAR(34),E2,CHAR(34)," ",CHAR(34),F2,CHAR(34)," ",CHAR(34),G2,CHAR(34),")")

I've attached an Excel file that uses it. It adds all 4 attributes.

Re: inserting blocks by using values in excel sheet

ebru_kilinc — Wed, 10 Jan 2024 08:34:04 GMT

Thank you so much!

Re: inserting blocks by using values in excel sheet

Amriya_Exe — Thu, 11 Jan 2024 09:57:53 GMT

(command "-insert" "ASM""145534.15,6614889.10" "1" "1" "182" "+APR.BC=TCL015.E0A" "182" "145534.15" "6614889.10")

Can you explain me this like first is block name, coordinates(x,y), ?, ?, rotation, ?, ?, ?

I am looking to create commands with insert block with block property distace1 of my dynamic block.

my question link is here

Re: inserting blocks by using values in excel sheet

leeminardi — Thu, 11 Jan 2024 14:26:06 GMT

@Amriya_Exe first set ATTDA to 0 to ensure that the dialog box for entering attrbutes does NOT appear.

Enter the command -insert The hyphen (-) keeps the initial dialog box from appearing. Note the sequenceo f prompts. That is,

block name
insertion point
x scale
y scale
rotation angle
attribute values (if there are any. Note the order of prompts if more than one attribute)

Note that in the Excel concatenate command a quote character " is used to tell Excel to use the text as noted. Without quotes Excel assumes that a cell is being referenced.

For example,

B6 means get the value in cell B6

"B6" means output the text B6

Char(34) is used to pass to the LISP statement a quote mark

Looking at the begnning of the Excel statement:

=CONCATENATE("(command ",CHAR(34),"-insert",CHAR(34)," ",CHAR(34),C2,CHAR(34)

that yields:

(command "-insert" "ASM" ...

We want to output:

(command

without quotes that is followed by

"-insert"

with quotes. The char(34) before and after "-insert" add the needed quote marks for the LISP statement.

The CHAR(34) before and after C2 insures that the cell name found in cell C2 will have quotes before and after. Using a LISP statement also helps to insure the ability to deal with block names that may have space characters.

Re: inserting blocks by using values in excel sheet

Amriya_Exe — Thu, 11 Jan 2024 20:03:42 GMT

In my case I want to insert block name "5mslab" On different coordinates. Rotation 102 and in dynamic block properties options distance 1 should change from excel like 4.890

Re: inserting blocks by using values in excel sheet

leeminardi — Thu, 11 Jan 2024 20:24:00 GMT

If you are asking for help please clearly state your question and attached a sample AutoCAD file with the block and the Excel file with a few rows of sample data.

Re: inserting blocks by using values in excel sheet

Amriya_Exe — Fri, 12 Jan 2024 05:24:33 GMT

https://forums.autodesk.com/t5/autocad-forum/insert-dynamic-block-with-custom-proprties-input/m-p/12482672/highlight/true#M1122197

This is my topic link bro. someone there refer me to this topic

Re: inserting blocks by using values in excel sheet

leeminardi — Fri, 12 Jan 2024 16:19:58 GMT

@Amriya_Exe Sorry, I cannot help you with this.

Re: inserting blocks by using values in excel sheet

Amriya_Exe — Fri, 12 Jan 2024 20:12:12 GMT

yha its seems to like not possible.

Re: inserting blocks by using values in excel sheet

ВeekeeCZ — Fri, 12 Jan 2024 21:47:05 GMT

@Amriya_Exe

This is what you need to create in Excel. That needs to be pasted into the command-line (with F3 OFF). It's called a script. And anyone who can read and follow commands in a command-line can do it.

10 mins job.

-insert myblock scale 0.001 rotate 102.476 291193.147055,2314274.47573 (setpropertyvalue (entlast) "AcDbDynBlockPropertyDistance1" 4.857) -insert myblock scale 0.001 rotate 102.476 291192.083785,2314279.281515 (setpropertyvalue (entlast) "AcDbDynBlockPropertyDistance1" 4.987) -insert myblock scale 0.001 rotate 102.476 291191.006475,2314284.150765 (setpropertyvalue (entlast) "AcDbDynBlockPropertyDistance1" 4.987)

Re: inserting blocks by using values in excel sheet

Amriya_Exe — Tue, 16 Jan 2024 06:28:36 GMT

I Tried to add this block using your method but its not getting aliened with blue line and dimension not getting changed as per the lengths.

Please check below images.