Jump to content
saiid

Locating of Instruments with coordinations in Excel to CAD

Recommended Posts

saiid

Dears;

 

could anybody help me to have macro for locating lots of instruments with coordination (E,N,) and Name from Excel to AUTOCAD.

attached is sample excel file that required to locate in CAD.

Coordination Report.xls

 

Tanx

Share this post


Link to post
Share on other sites
saiid

Dears;

 

could anybody help me to have macro for locating lots of instruments with coordination (E,N,) and Name from Excel to AUTOCAD.

attached is sample excel file that required to locate in CAD.

 

Coordination Report.xls

 

tanx

Share this post


Link to post
Share on other sites
MSasu

What is the meaning of first column? Are about some blocks? Those reside in your drawing or were stored on a disk?

You may build by yourself a script from that Excel file, don't need a dedicated tool.

 

By tha way, don't need to duplicate your thread, please ask a moderator to remove one of them.

Share this post


Link to post
Share on other sites
BIGAL

Search here for excel & Contactenate command what you want is real easy like MSasu says

 

excel column = insert AIT-17007 3468299,4509976 1 1 0

use =CONCATENATE("insert ",A6," ",C6,",",E6," 1 1 0")

just copy column and paste directly into command line

 

Share this post


Link to post
Share on other sites
saiid

Hi Kev

 

Tanx so much, i loaded above mentioned lisp file in my outocad, but i need some explanation for importing and indicating data such as name, E, N for each point from excel file to CAD.

would you please help me.

 

Tanx so much indeed.

Share this post


Link to post
Share on other sites
KevUK

As I mentioned before, do a search, this topic has been covered numerous times previously.

Share this post


Link to post
Share on other sites
Tiger

Saiid, I merged your two threads - please do not ask the same question multiple times across the forums.

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×