SPACECADET Posted February 22, 2011 Posted February 22, 2011 I need to Attout the title block info from multiple layouts into an excel sheet that I can then edit and back populate (ATTIN) my drawing borders. Dataextraction doesn't bring the all important block handle that I need for the attout/in process and It seems I will have to manually attout to txt and import to excel for each layout...150 in total. Can this be automated. or is there a routine that can output to txt the handle for a given block along with it's layout tab number so i can paste it into excel in the correct order. Confused. Any help welcomed. Quote
ubsure Posted March 1, 2011 Posted March 1, 2011 Maybe you can make a lisp getting the atributes, and then writing them to excel like this: (defun c:csv ( / wrkfile ofile name adress phone) (setq wrkfile "C:\\Test.csv") (setq ofile (open wrkfile "a")) (setq name "ubsure") (setq adress "street 22") (setq phone 12345678) (write-line (strcat name ";" adress ";" (rtos phone 2 0)) ofile) (close ofile) ) from there you can use them for your attin. ubsure Quote
Recommended Posts
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.