Communiquez avec les autres et partagez vos connaissances professionnelles

Inscrivez-vous ou connectez-vous pour rejoindre votre communauté professionnelle.

Suivre

Is there any way to link data from Excel to AutoCAD Table? It should work both ways.

user-image
Question ajoutée par Abdul Kareem Chala Mohammed , Senior Designer , iSmarthome
Date de publication: 2016/04/07
Elke Woofter
par Elke Woofter , Project Assistant , American Technical Associates

Yes it can be done ... I found this on AutoDesk.com

A table can be linked to data in a Microsoft Excel (XLSXLSX, or CSV) file. You can link to an entire spreadsheet, individual row, column, cell, or cell range in Excel.

Note:

Microsoft Excel must be installed to use Microsoft Excel data links. To link to the XLSX filetype, Microsoft Excel 2007 must be installed.

You can bring data from Microsoft Excel into a table in the following three ways:

  • As formulas with supported data formats attached.
  • As calculated data from formulas calculated in Excel (supported data formats not attached).
  • As calculated data from formulas calculated in Excel (with data formats attached).

A table that contains data links displays indicators around linked cells. If you hover your cursor over the data link, information about the data link is displayed.

If a linked spreadsheet has been changed, such as adding a row or column, the table in your drawing can be updated accordingly using the DATALINKUPDATE command. Likewise, if a change is made to a table in your drawing, then you can update the linked spreadsheet using the same command.

By default, a data link is locked from editing to prevent undesired changes to the linked spreadsheet. You can lock cells from data changes, format changes, or both. To unlock a data link, click Locking on the Table ribbon contextual tab.

Related Concepts

Related Tasks

Related Reference

 

 

Mohamed Sharaf Sharaf
par Mohamed Sharaf Sharaf , construction site manager , MAJAL ALENJAZ CONTRACTING CO.

Agree with Mr. Vaqar Ali Sayyed answer

thanks for the invite

Amr Gamal Anwar Hassan
par Amr Gamal Anwar Hassan , مهندس حاسب كميات , Shurfah Real Estate Development and Investment

I agree with Mrs. Elke Woofter

Vaqar Ali Sayyed
par Vaqar Ali Sayyed , AutoCad Opertator , Carlo Gavaazzi Arabia Co. Ltd.

By linking to an Excel spreadsheet, you can include information from an entire worksheet, or part of a worksheet, referred to as a named range. Using the Link External Data dialog box, you can:

Abu Bakar Ashfaq
par Abu Bakar Ashfaq , Senior Consultant , PricewaterhouseCoopers Middle East

No idea, but Alke answer seems to be good one.

Mushreq Abdulmajeed
par Mushreq Abdulmajeed , Senior Project Supervisor , Lagoon Spring Company

I agree with the answer of Mrs.Alke

Ahmed Mohamed Ayesh Sarkhi
par Ahmed Mohamed Ayesh Sarkhi , Shared Services Supervisor , Saudi Musheera Co. Ltd.

i didn't have experience on AUTOCAD sorry

 

More Questions Like This