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
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
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
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
Or look for a 3rd party tool which can extract data to an existing xls file.
Sebastian
Or look for a 3rd party tool which can extract data to an existing xls file.
Sebastian
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
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.