Combining AutoCAD Data Extraction Tables with Excel Tables

Рет қаралды 136,937

14 жыл бұрын

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

@paulobrito2009 12 жыл бұрын

Thank you so much for the hints. I already created my own standards based upon your video and it´s still working very well.

@jthrilla84 12 жыл бұрын

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!

@sreedharvp5925 6 жыл бұрын

very nice I have worked this many times but this video explained very clearly thanks

@tajammulhussainKhadir 7 жыл бұрын

wow this is what I was searching thank you so much..

@alirashad8260 12 жыл бұрын

hey man ,, thanks for helping keep uploading ur amazing videos

@lindawang314 3 жыл бұрын

thank you so much!

@argenism6 4 жыл бұрын

Very cool, thank you.

@sgs3131 13 жыл бұрын

thank you very good demo

@mitsha01 11 жыл бұрын

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

@danpaano Жыл бұрын

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!

@jonnasdrade 5 жыл бұрын

Nice Video. Question: how can I do If in the same example I need another extra column with a total price of all units?

@brandoneulberg1324 8 жыл бұрын

Can you do this with parts and blocks as well?

@saiavinashrevanur8359 8 жыл бұрын

After adding another multi-leader no.2, does the excel sheet also get updated?

@Mostafa20268 11 жыл бұрын

Thanks

@shrinathingale 6 жыл бұрын

Hey I need to plot excel file to cad as a drawing can we do it if yes then show me how.

@hernandocimadevilla5839 8 жыл бұрын

How can I avoid the count number if I have layers for some of the blocks? Thanks.

@wojtek_sanitarnik 10 жыл бұрын

What about double or triple multileader? Is it will be count as one?

@2002usama 8 жыл бұрын

thanks

@hernandocimadevilla5839 8 жыл бұрын

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?

@elvanovich 12 жыл бұрын

Great! But what happens with the excel sheet? Can you have a "count" column that reloads as well so it is linked both ways?

@arosionut 12 жыл бұрын

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 ?

@shrinathingale 6 жыл бұрын

Take a little complex design as example if yes

@reidjosh 12 жыл бұрын

Is there a way to not add the id if the count is 0?

@58ahmed 13 жыл бұрын

ty vm :)

@inesmarques1892 10 жыл бұрын

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

@mukeshsahani6452 7 жыл бұрын

can you do this vice-versa? ... I mean if i update in excel will it be update in drawing ???

@danstevens9245 6 жыл бұрын

Yes, use the data link command to import your excel table.

@moincad 4 жыл бұрын

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

@rdsamsterdam6430 5 жыл бұрын

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 !

@moincad 4 жыл бұрын

IF I HAVE MULTPLE BLOCKS OF DIFFRENT NAMES ? i tried but not working