Wb-collection (vlax-get excel-app "workbooks")Īrq (vlax-invoke-method wb-collection "Open" FilePath) (setq excel-app (vlax-get-or-create-object "excel.application") (setq FilePath (getfiled "Select File:" (getvar 'dwgprefix) "xls csv" 2)) (defun ExcelData ( / row col lst vertxldata CellProps CellItem) Here's an example of creating a full sheet datalink through lisp: Still I have to show some people next week how to access Excel using LISP so I' will keep trying. Plus, if I read the docs right, you can make changes either to the table in AutoCAD or to the Excel spreadsheet and all will be updated. That seems like a rather brutal process to go through to end up with the same thing. In fact, it was so easy I don't know why you'd want to use LISP to do it. I did some additional work with this and found it's really quite easy to link a table to an Excel spreadsheet. Hey Fixo, that's pretty cool.Like the way it worked.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |