Search the Community
Showing results for tags 'datalink'.
Found 5 results
Excel Data linking; Table wrapping text format issues
DataLinkQ posted a topic in AutoCAD 2D Drafting, Object Properties & InterfaceHi everyone, Setup; OS: Win 7 Pro X64 Product: AutoCAD 2015 Electrical CPU: i7 Graphics: AMD FirePro M6100 FireGL V Ram: 16GB Problem; I've created a datalink table to an Excel spreadsheet, and I'm only having issues with tables that required a break (table wrapping). Once I break the table and setup text properties; text height, alignment, headers, cell widths. Everything looks okay until I close and open the drawing. The first half of the table remembers the settings, but the second half always reverts back to .5 text height and top center alignment (headers and cell width are still in place on the 2nd part of the table) Solutions I've tried; I've tried to do the formatting before I break the table, I've tried after its broken. I right clicked on the tables and "Remove All Property Overrides" which makes the text all crazy, so I setup text properties, qsave and close. once I open the drawing text height and alignment changes again. If I try to "Remove All Property Overrides" the text doesn't change, so I think that function worked correctly. Summary; How can I get the 2nd half of the datalinked table to remember all property settings? I'm out of ideas Does anyone have some other solutions to try? Thanks for your time. -DataLinkQ
Script to add many Data Links without using the Data Link Manager
akyc115 posted a topic in AutoLISP, Visual LISP & DCLHi, Is there a way to add datalinks without doing it manually using the Data Link Manager? I need to insert a lot of data links to a CAD file and was wondering if there is a way to streamline the process. Excel Setup: In my Excel workbook, I have many worksheets and each worksheet have 2 "Named Range" to be data linked in CAD. Does anyone know how I can do this? If I had to add the data link manually, the step would be: 1) Data Link Manager > Create a new Excel Data Link 2) Choose an Excel File 3) Set Path Type: "Relative Path" 4) Select Excel sheet to link to: "Worksheet Name" 5) Link to a named range: "Named Range" 6) Uncheck "Use Excel formatting" Thanks so much!
Datalink table insertion with TBL.LSP crashes second time
shailujp posted a topic in AutoLISP, Visual LISP & DCLHi all, I'm using a datalink table insertion utility tbl.lsp from Juan Villareal. It allows me to insert the table for the first time in the drawing without any issues. But when I want to insert the table (different table though) for the second time in the same drawing, AutoCAD crashes giving me unhandled exception error. Few questions related to this, 1) Can the tbl.lsp be fixed (if there is any error) 2) Is there a better known utility that I should be using instead of tbl.lsp (with all due respect to J.Villareal for his great lisp) Please suggest. Thanks all Tbl.lsp
Datalink: Excel not installed properly
Seann posted a topic in AutoCAD 2D Drafting, Object Properties & InterfaceSo I just started at a new firm and they are using datalinks for the attic vent calculations. The table is in Excel and once filled out it should populate in the drawing. My CPU was an old employee's so it isn't new installed software but my datalink button says that Excel is not installed properly and will not let me edit the datalink in Autocad. I can however open the Excel file from the reference manager just fine and it opens. I have tried hard pathing and softpathing with no luck. Other people can insert it for me which they did in one file but I want to be operating at 100% like they are. Any ideas?
Excel DataLink not showing in model space
Wil posted a topic in AutoCAD Drawing Management & OutputHi, I am simply trying to insert an excel datalink into my drawing. However once i complete the process using the datalink manager and click 'OK' nothing happens, i return to my model space window with nothing appearing. I have checked my layers are on and check the extents..... Any help is greatly appreciated