ابدأ بالتواصل مع الأشخاص وتبادل معارفك المهنية

أنشئ حسابًا أو سجّل الدخول للانضمام إلى مجتمعك المهني.

متابعة

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

user-image
تم إضافة السؤال من قبل Abdul Kareem Chala Mohammed , Senior Designer , iSmarthome
تاريخ النشر: 2016/04/07
Elke Woofter
من قبل 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
من قبل 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
من قبل Amr Gamal Anwar Hassan , مهندس حاسب كميات , Shurfah Real Estate Development and Investment

I agree with Mrs. Elke Woofter

Vaqar Ali Sayyed
من قبل 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
من قبل Abu Bakar Ashfaq , Senior Consultant , PricewaterhouseCoopers Middle East

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

Mushreq Abdulmajeed
من قبل Mushreq Abdulmajeed , Senior Project Supervisor , Lagoon Spring Company

I agree with the answer of Mrs.Alke

Ahmed Mohamed Ayesh Sarkhi
من قبل Ahmed Mohamed Ayesh Sarkhi , Shared Services Supervisor , Saudi Musheera Co. Ltd.

i didn't have experience on AUTOCAD sorry

 

المزيد من الأسئلة المماثلة

هل تحتاج لمساعدة في كتابة سيرة ذاتية تحتوي على الكلمات الدلالية التي يبحث عنها أصحاب العمل؟