Community
AutoCAD Forum
cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 

AutoCAD Data Extraction to Excel - Live Link

4 REPLIES 4
Reply
Message 1 of 5
kieran.leadbetter
826 Views, 4 Replies

AutoCAD Data Extraction to Excel - Live Link

kieran.leadbetter
Advocate
Advocate

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

0 Likes

AutoCAD Data Extraction to Excel - Live Link

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

Labels (4)
4 REPLIES 4
Message 2 of 5
cadffm
in reply to: kieran.leadbetter

cadffm
Consultant
Consultant

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.

Sebastian

0 Likes

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.

Sebastian

Message 3 of 5
cadffm
in reply to: kieran.leadbetter

cadffm
Consultant
Consultant

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

 
 

 

 

Sebastian

0 Likes

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

 
 

 

 

Sebastian

Message 4 of 5

imadHabash
Mentor
Mentor

Hi,

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

 

Imad Habash

EESignature

0 Likes

Hi,

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

 

Imad Habash

EESignature

Message 5 of 5

kieran.leadbetter
Advocate
Advocate

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

0 Likes

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

Can't find what you're looking for? Ask the community or share your knowledge.

Post to forums  

AutoCAD Inside the Factory


Autodesk Design & Make Report