Continue to Site

Eng-Tips is the largest engineering community on the Internet

Intelligent Work Forums for Engineering Professionals

Register Log in
  • Congratulations IDS on being selected by the Eng-Tips community for having the most helpful posts in the forums last week. Way to Go!

export multiple point selection to excell

Status
Not open for further replies.
koenwas

koenwas

Mechanical
Jun 16, 2003
1

I would like to export the xy coordinates of multiple points to excell. Has anyone a routine which can do this ? I'm not familiar with either LISP or VBA so if you can give me some guideline how to import and use it this would be great.
 
Replies continue below

Recommended for you

Sort by date Sort by votes
Hi,
first aid:


(DEFUN C:xyz_out ( / datei aws zaehler einfp pstr )
(SETQ datei (OPEN "c:\xyz.txt" "w"))
(SETQ aws (SSGET "x" '((0 . "POINT"))))
(SETQ zaehler 0)
(REPEAT (SSLENGTH aws)
(SETQ einfp (CDR(ASSOC 10 (ENTGET (SSNAME aws zaehler)))))
(SETQ pstr (STRCAT (RTOS(CAR einfp) 2 3) " " (RTOS(CADR einfp) 2 3) " " (RTOS(CADDR einfp) 2 3)))
(WRITE-LINE pstr datei)
(SETQ zaehler (+ zaehler 1))
); ende repeat
(CLOSE datei)
)


You will get a file „xyz.txt“ on c:
regards, Lothar


Win NT4.0(SP6),2000(SP3)
AC 2000i(SP2), ADT 3.0(SP3),
AC 2002, ADT 3.3,
AC 2004, ADT 2004
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

CAD2015
  • Locked
  • Question
Creating a file of multiple components (Assembly) in Auto CAD 2024 1
Replies
2
Views
640
CAD2015
CAD2015
CAD2015
  • Question
AutoCAD file conversion from inch to mm......................... 2
Replies
15
Views
10K
dik
dik
DennisR4
  • Locked
  • Question
Importing PDF to DWG
Replies
1
Views
753
dik
dik
dik
  • Locked
  • Question
Import and Export Plot Styles
Replies
10
Views
389
dik
dik
hassann
  • Locked
  • Question
autocad convert to autocad 1
Replies
6
Views
744
IFRs
IFRs

Part and Inventory Search

Sponsor

Back
Top Bottom