Jump to content

autocad excel coordinate to excel


ses4

Recommended Posts

kamciz.jpgKAMÇİZ.dwg

I request you to have a function similar to that of the macro attached. However, your request is appended in the macro kamçiz.dwg painting yellow lines and red color (the cam determines the limit) of the line intersection points (with a circle mark, technical illustration, I wanted to specify that) automatically determine the value of these points automatically revised to an Excel file, can you throw? I would like to wait for your assistance regards to this issue valuable. Excel format may be appendedDid he kamçiz.xls? this cam should be in the drawing of the coordinate values ​​kamçiz.xls file again presented.

Edited by ses4
Link to comment
Share on other sites

the exact coordinates of the points I want to get from the content of autocad windows in order to transfer an excel file.

yellow painted lines kamçiz.dwg file excel file in a sequence that transfers the coordinates of end points for a macro solution P0 istiyorum.İlk marked with the final value of the values ​​which must be marked with the P359.

Link to comment
Share on other sites

KAMÇİZ.dwg

yellow painted lines kamçiz.dwg file excel file in a sequence that transfers the coordinates of end points I would like a macro solution. The first value is marked with the final value P0 of the values ​​must be marked with the P359.

In addition, only these are attached in a similar macro excel macro in order to transfer the data should be used.

http://rapidshare.com/files/456862686/PointList.dvb

Edited by ses4
Link to comment
Share on other sites

please help me this issue!

[ATTACH]26958[/ATTACH]

yellow painted lines kamçiz.dwg file excel file in a sequence that transfers the coordinates of end points I would like a macro solution. The first value is marked with the final value P0 of the values ​​must be marked with the P359.

In addition, only these are attached in a similar macro excel macro in order to transfer the data should be used.

http://rapidshare.com/files/456862686/PointList.dvb

Link to comment
Share on other sites

I am still unclear as to what you exactly want.

 

Looking at the macro and drawing, try contacting

'Suphi TUNALI
'Survey & Civil Technician
'TGO (Tekfen-Gama) Ltd.
'Maritza East-I Power Plant Project
'AES-3C Maritza East-I TPP Site Office
'Industrial Region 6280 Galabovo Bulgaria
'Tel   : ++ 359 42 900100
'Fax   : ++ 359 42 900197
'Gsm   : ++ 359 897 971995
'Email : suphit@gmail.com
'        suphi@tgo-bg.com
'Web   : http://www.maritza-photos.blogspot.com/

 

who seems to be the author of the macro (unless that is you).

Link to comment
Share on other sites

Dear Sir

I have connected Mr.Tunalı He hasn't replied.

To clarify what I want to do exactly.P0 is the highest value and P359 is lowest.When the drawing is chosen in a window and macro is running,we want to value to be exported in to excel (from P0 To P359 in a row)

 

for example

 

excel file adding

 

http://rapidshare.com/files/456875969/kam__iz.xls

Link to comment
Share on other sites

http://www.cadtutor.net/forum/showthread.php?56581-autolisp-extract-atributes&p=383619#post383619

 

I posted a script in the above thread that I think does what you're looking for with the exception that it deals with blocks. It should get you started.

 

I do not get the result I want to give to your page with AutoLISP.

 

I wonder if I wanted to write code to help me in this regard would be grateful if the coordinates of the points I have to choose only one hand.

Edited by ses4
Link to comment
Share on other sites

Please edit this as I want, not lisp blocks Could you put here?

http://rapidshare.com/files/456875969/kam__iz.xls

http://rapidshare.com/files/456862686/PointList.dvb

KAMÇİZ.dwg

 

Function;

- Before you ask us to pick the circle

- Then spline object (cam cross-section) to be selected

- we chose the center of the circle as the origin of the coordinate system to take

- y axis of the spline to be cut off since the peak

- Clockwise (clockwise) for every 1 degree of scrolling through an imaginary line

- Locate the point of intersection with this line, spline

- x and y coordinates with point number to write to the file

Edited by ses4
Link to comment
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
Unfortunately, your content contains terms that we do not allow. Please edit your content to remove the highlighted words below.
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  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...