topic AutoCAD Data Extraction to Excel - Live Link in AutoCAD Forum

AutoCAD Data Extraction to Excel - Live Link

kieran.leadbetter — Wed, 08 Mar 2023 15:28:06 GMT

I was wondering if anyone would know how to create a live data extract from autocad, then into excel?

My current plan is the following:
- Create a data extract of hatches to calculate area (Done)
- Create a live link from autocad into excel to allow for further excel calculations to be updated quicker (Issue)
- Relink this data into a 2nd table on AutoCAD to state further information based on hatch area

I Know how to link excel to autocad, but i need to link autocad to excel.

Thank you

Betreff: AutoCAD Data Extraction to Excel - Live Link

cadffm — Wed, 08 Mar 2023 15:36:41 GMT

DATAEXTRACTION

https://help.autodesk.com/view/ACD/2023/ENU/?guid=GUID-5A39FFE8-10AC-4AE5-8EF4-D097C8261D1A

But this is not live, you need to update the excel file

by your .DXE file (onced created, you can use command _-DATAEXTRACTION

Use 2 excel files and link the content of the dataextraction created xls into your other xls file.

Betreff: AutoCAD Data Extraction to Excel - Live Link

cadffm — Wed, 08 Mar 2023 15:37:47 GMT

Or look for a 3rd party tool which can extract data to an existing xls file.

Re: AutoCAD Data Extraction to Excel - Live Link

imadHabash — Wed, 08 Mar 2023 15:38:42 GMT

Hi,

Would you please try this Link and see if it'd help ?

Re: AutoCAD Data Extraction to Excel - Live Link

kieran.leadbetter — Wed, 12 Apr 2023 08:13:49 GMT

Spent a while trying to resolve this with work

our best solution was

_ Create a data extract for Hatch Areas (This is the only manual aspects)
_ Export the data extract as a csv file (This is the only manual aspects)
_ Link excel to the csv file and use the information as required
_ Import that information back into excel
_ Then the new autocad table was put in paperspace as was completely linked to the excel sheet

With this we linked about 50 different csv files together for 1 fully automatic area calculator which we could then format in unique ways as it was in excel