Combining AutoCAD Data Extraction Tables with Excel Tables
Ғылым және технология
The CAD Geek, Donnie Gladfelter, discusses how to create a dynamic AutoCAD table using block attributes, Extract Data tool, and an Excel spreadsheet. Using this procedure a comprehensive table including block attribute data, data extraction data, and Excel table data will be combined into a single AutoCAD table. Be sure to visit Donnie at thecadgeek.com for more tips and tricks just like this one.
----------
Subscribe to AutoCAD LT: thecadgeek.com/link/autocad-lt/
Subscribe to AutoCAD: thecadgeek.com/link/autocad/
For the latest AutoCAD Tips, Tricks, industry insights, and more visit thecadgeek.com
Пікірлер: 36
Thank you so much for the hints. I already created my own standards based upon your video and it´s still working very well.
Thanks man! this is exactly what ive been looking for! I really didnt catch it all in a class I was taking last semester but this video explained it clearly!
very nice I have worked this many times but this video explained very clearly thanks
wow this is what I was searching thank you so much..
hey man ,, thanks for helping keep uploading ur amazing videos
Very cool, thank you.
Thanks for this video. Can you share how to properly add a formula column to multiply the cost column from the external excel datalink with the count column. I keep getting an 'invalid data' error when I try it. Thanks in advance!
thank you very good demo
I loved you video, explains data extraction very well... my question is can I add blocks to the data extraction table?... it will help me to show the block, the description of the block, the count, and extracted attributes of the block
thank you so much!
Nice Video. Question: how can I do If in the same example I need another extra column with a total price of all units?
Thanks
After adding another multi-leader no.2, does the excel sheet also get updated?
Can you do this with parts and blocks as well?
thanks
How can I avoid the count number if I have layers for some of the blocks? Thanks.
What about double or triple multileader? Is it will be count as one?
Is there a way to use this but with also layers? I need to create the table easily but with layers because I need to show somethings sometimes and I just turn on/off the layers to see them or not in Autocad, but how can I link the autocad layers with Excel? Do you know how can do it? or Another way to create an Autocad Table with specific views depending of layers or options to only see in the table the items that I just need to see?
Hey I need to plot excel file to cad as a drawing can we do it if yes then show me how.
Great! But what happens with the excel sheet? Can you have a "count" column that reloads as well so it is linked both ways?
Hello, did u know how connect xcel with autocad ?? I mean, when u click in autocad a text, to make link between autocad and excel data base ?
Take a little complex design as example if yes
ty vm :)
How to link cad attribute tag with excel same tag no with having multiple sub items. For MTO. Supposed cad have 1 no id. But in excel 1 tag having multiple sub items i need to take out all mto with it
hey!I'm having problems with this...I create a new excel data link as you explain, but then in the next step when I browse for it I can't find it. Can you help?thanks a lot
This looks awsome , I tried it myself and all went well.....until I "link External Data".... I select the ID columns drawing & External ; after "Check Match" I get a error-message... "The data column in the external data does not contain unique values" Tried eveything but somehow I can't solve this. I bet it is something very simple. Any suggestions perhaps ? Thanks !
Is there a way to not add the id if the count is 0?
IF I HAVE MULTPLE BLOCKS OF DIFFRENT NAMES ? i tried but not working
can you do this vice-versa? ... I mean if i update in excel will it be update in drawing ???
@danstevens9245
7 жыл бұрын
Yes, use the data link command to import your excel table.
ta dando ruim!!!!!!
long and complicated :(