AutoCAD Data Extraction to Excel - Live Link

[kieran.leadbetter]

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

[cadffm]

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.

[cadffm]

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

[imadHabash]

Hi,

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

[kieran.leadbetter]

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