topic Re: Place Objects with X Y and Rotation Values from Excel to Autocad in AutoCAD Forum

Place Objects with X Y and Rotation Values from Excel to Autocad

Anonymous — Wed, 04 May 2016 20:56:37 GMT

I have an excel spreadsheet with X, Y, and Rotation values (see example). I want to place the base point of a defined block at each point and rotated. My spreed sheet contains ~1000 X,Y, rotation values, so I need a LISP or Scipt that does this automatically.

I have tried finding and running codes I have found online but with no luck. What is the best/easiest way to do this? I am a novice at understanding/running LISP, so the simplier the better. Any help will be greatly appreciated.

Thanks,

Danny

Re: Place Objects with X Y and Rotation Values from Excel to Autocad

Alfred.NESWADBA — Thu, 05 May 2016 11:25:08 GMT

Hi,

you can use excel formulas to create a script like list of commands and then just do a copy & paste.

Please find the attached XLSX (basically yours + formulas and:

Start AutoCAD with a new drawing
Make sure to set ATTREQ to 0 in case your block has attributes (or modify the XLS to fill the requested attributes)
In XLS select K2 to Q12
right mouse click ==> copy
change to AutoCAD
make sure your mouse selected the command line
right mouse click ==> paste

ready.

Within the XLS I have prepared:

in E2 ... type in your block name
in column G to H ... converted decimal seperator from comma to point (in case your Windows is set to use comma as decimal seperator
in column K to Q ... a lisp command to insert a block with your blockname at the coodinates/scaling 1/your rotation

What you need when you have other data:

copy your new X/Y/Rotation data to columns A to C, starting with row 2
select the range K2 to Q2 ==> right-click ==> copy
select range K3 to Q<rows depending on the number of rows your new data has> ==> right-click ==> paste

HTH, - alfred -

Re: Place Objects with X Y and Rotation Values from Excel to Autocad

Anonymous — Thu, 05 May 2016 14:46:50 GMT

First off, I want to thank you for your help on this project. I really apprciate it!

So I have a few problems when trying to get this to work. First off, I had to delete column "O" from your example, giving only 1 scale instead of 2. Otherwise, this would not work. (I have attached new excel showing).

The main problem I am having is somtimes the block are inserted at the wrong coordinates. I can delete all the blocks I just inserted in autocad then and paste the same script, and it will give me a slightly different layout. Only occasionally (maybe 1 in 10 tries) will it insert all the blocks at the correct coordinates. There could not find a pattern to this madness either!

It is so close to working perfectly! Do you know what I could be doing wrong? I have set attreq to 0 and tried following you directions as closly as posssible.

Best Regards,

Danny

Re: Place Objects with X Y and Rotation Values from Excel to Autocad

Alfred.NESWADBA — Thu, 05 May 2016 15:09:02 GMT

Hi,

>> First off, I had to delete column "O" from your example, giving only 1 scale instead of 2

Then your block is set to "scale uniform only".

>> somtimes the block are inserted at the wrong coordinates

Turn OFF object snap before starting the script

- alfred -

Re: Place Objects with X Y and Rotation Values from Excel to Autocad

Anonymous — Thu, 05 May 2016 15:23:39 GMT

Alfred, thank you very much. This works perfectly now! You are a smart man.

Re: Place Objects with X Y and Rotation Values from Excel to Autocad

tim.garrison8XZPQ — Fri, 17 Sep 2021 22:00:06 GMT

It took me a second to get what the excel sheet was doing. Brilliant - thanks so much.

Re: Place Objects with X Y and Rotation Values from Excel to Autocad

hootan2003 — Sun, 23 Jan 2022 16:57:52 GMT

Hi,

Does anybody know how I can insert Blocks in a specific layer based on my excel data?

I have an Excel file that contains Block names, X, Y, Rotation, and layer data. I used your method for inserting my Blocks, but all of them are in the 0 layer. I want each of them to be in their own layer based on their excel data.

Thank you for your help.

Re: Place Objects with X Y and Rotation Values from Excel to Autocad

Alfred.NESWADBA — Sun, 23 Jan 2022 17:11:51 GMT

Hi,

>> I used your method for inserting my Blocks, but all of

>> them are in the 0 layer

Your Excel-file does not show your script content, so I can't see where you tried to set the layer and so I can't tell you where/why your trial failed.

- alfred -

Re: Place Objects with X Y and Rotation Values from Excel to Autocad

chrisjune1994 — Mon, 12 Sep 2022 09:36:28 GMT

Hi, hope someones still here to help !

Awesome work this. However, is there a way to have a column in excel which contains the attribute required for each symbol then when you paste into Autocad, the symbols will be automatically populated with the relevant atrribute? Hope this makes sense.

Thanks !!

Re: Place Objects with X Y and Rotation Values from Excel to Autocad

kitwing_kai — Fri, 07 Feb 2025 04:58:33 GMT

Why some block need X, Y scale but some don't need?

Re: Place Objects with X Y and Rotation Values from Excel to Autocad

cadffm — Fri, 07 Feb 2025 08:39:14 GMT

Hi,

if you create a Block(definition), there is an option "Scale uniformly".

For Automation with AutoCAD Commands,

Use the INSERT option SCALE !

Insert

Blockname

SCALE

.. and so on.

This way the workflow is the same for all blocks - forced to uniformly scaled or not.