richard3009 Posted September 23, 2010 Posted September 23, 2010 When extracting attributes to an Excel spreadsheet the drawing title block is generally spread across three columns ie one column per attribute, I can be combined the columns after entering the spread sheet using concatenate, is it possible to automate this. Quote
BlackBox Posted September 23, 2010 Posted September 23, 2010 This may help: http://www.jefferypsanders.com/autolisp.html#CAD2FILE Quote
richard3009 Posted September 23, 2010 Author Posted September 23, 2010 I wish to do hundreds of drawings at a time, autocad 10 extracts attributes for you, im just trying to improve the layout of the results in the spreadsheet. Quote
BlackBox Posted September 23, 2010 Posted September 23, 2010 Start your search here: (defun c:FOO (/ excelApp) (vl-load-com) (if (setq excelApp (vlax-get-or-create-object "Excel.Application")) (progn (textpage) (vlax-dump-object excelApp T) (vlax-release-object excelApp))) (princ)) This will display a list of the properties and methods available to the Excel application. Happy hunting, and good luck! 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.