Jump to content
pvsvprasadcivil

Importing Excel data and draw lines (Data is "From" "To" ponts of Line or length

Recommended Posts

pvsvprasadcivil

Dear All my well wishers...please solve my typical problem..please..my data as below(From Excel)

 

S.No. Length(m)

From To Remarks

1. 10 11.5 soil

2. 13 14 soil

3. 10 11.5 concrete strata

4. 10 12 Bitumen Strata

 

 

How to draw lines from above data(From Excel) by importing, using visual lisp.PLEASE RESPOND POSITIVELYY.PLZZZZ

BAR CHAR INPUT DATA.xlsx

GRAPH FINAL OUTPUT.dwg

Share this post


Link to post
Share on other sites
eea123

I looked at your sample data set and don't see how that easily imports into CAD. Take a look at some of the available utilities and see if you couldn't manipulate the Excel source data into a format that can be imported and drafted with reduced effort. Jeffery Sanders http://www.jefferypsanders.com/autolisp_XL.html comes to mind.

Share this post


Link to post
Share on other sites
eea123

Another consideration on connecting linework. I have used some commercial products in the past for connecting linework from survey points using linecodes. I have found that if you are able to import the data sorting the descriptor onto layers, then you can just turn layers on and off that you want to connect the linework using the line commend with Osnap by node very fast!

Share this post


Link to post
Share on other sites
BIGAL

Your data and dwg really dont explain what you want is it the hatching that your trying to produce on a std dwg template ?

 

You could just use excel to create a column that defines the hatch area as a simple pline command then hatch it and you just copy that column onto the autocad command line. Just type -hatch and follow the prompts write down all the steps that what you need for excel.

 

eg column L = -hatch la Concrete B 100,150 200,150 ansi31

 

Check here by searching for excel "Concatenate" examples.

Share this post


Link to post
Share on other sites
pvsvprasadcivil
I looked at your sample data set and don't see how that easily imports into CAD. Take a look at some of the available utilities and see if you couldn't manipulate the Excel source data into a format that can be imported and drafted with reduced effort. Jeffery Sanders http://www.jefferypsanders.com/autolisp_XL.html comes to mind.

 

Dear sir,

my Concept is not Importing table excel to cad (not draw table in cad)..I want draw Lines by from to points from excel data..Please suggest suitable soft or lisp.

I am having From to points for line forming, with different line weight, color,level based upon data...so please respond :(

Share this post


Link to post
Share on other sites
pvsvprasadcivil

Dear sir,

my Concept is not Importing table excel to cad (not draw table in cad)..I want draw Lines by from to points from excel data..Please suggest suitable soft or lisp.

I am having From to points for line forming, with different line weight, color,level based upon data...so please respond :(

Share this post


Link to post
Share on other sites
fixo

Please do not post message on my old e-mail address,

currently it's not mine now

Also I could not hep you further

Share this post


Link to post
Share on other sites
BIGAL

To draw a line from a column of input in excel this is the simplest way! Just copy column G to the command line. Using a lisp requires a knowledge of lisp to customise for your use. You have to edit the lisp to say which cells are to be used.

 

Anyway if you want to have a go google GETEXCEL.LSP

 

excelline.jpg

Share this post


Link to post
Share on other sites
pvsvprasadcivil

Dear all my well wishers,

please suggest suitable visual lisp for Draw lines with Excel data in the form of From ,To points of lines, with different colors based upon data.

pleasesssss provide...Iam attached required modified output sample.

 

plzzzz

BAR CHAR INPUT DATA.xls

GRAPH FINAL OUTPUT2.dwg

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.


×
×
  • Create New...