Thứ 5 - 07/08/2014

Tạo bảng liên kết động giữa excel và Autocad

Linking an Excel spread sheet to an AutoCAD drawing and displaying the excel table as an AutoCAD “Table” is very helpful depending on how you “link” the Excel file to the AutoCAD table.

In this post, I describe how to make an AutoCAD “Data Link” first, and then inserting a table using this Data Link.

I have seen a few examples where using other methods have cause issues. So after testing various ways, I think that this method is a solid method.

In this scenario, we have engineers who need to update a drawing list that happens to be an excel file (.xlsx) and they would like to link this to AutoCAD so that when they make changes to the table, those changes are included in the AutoCAD file.

client_net

First we need to make a “Data Link”

Click the “Data Link” button on the “Linking & Extraction” panel of the “Insert” tab of the ribbon.

Data Link 1

  • When the “Data Link Manager” opens, click “Create a new Excel Data Link
  • Give the Data Link a unique name
  • Then click OK

Data Link 2

  • Now link the “Data Link” to an excel file by clicking the ellipsis button ( 3 dot button)
  • Navigate to the Excel file and select it
  • Then click “Open

Data Link 3

 

The dialog box called ” New Excel Data Link” will display and an additional preview is now shown in the bottom portion.

One very important thing to note about this Dialog Box is to expand it by clicking the right arrow. This allows for additional formatting options for the AutoCAD Table.

Data Link 4

 

Now you will insert an AutoCAD Table (shown below)

When the “Insert Table” dialog box displays, click “From a data link

Select the Data Link that you named earlier from the drop down list

Then click OK

Data Link 5

 

Place the table in the drawing

After the table has been placed, you should be good to go.

Lets say that an engineer updates the Excel spreadsheet. You will either get the below notification when the person has saved and checked in the file or the next time you open the drawing.

Data Link Update

 

The AutoCAD table will not update by itself, you will need to update it manually.

To do this:

  • Place the cursor in a cell of the table
  • Click the “Download from Source” button in the ribbon

Data Link 6

 

There are many other options available while placing a Data-Linked table so please look further in to this topic to meet your needs. This is a high-level look at adding a data link table to a drawing.

~enjoy

(http://autocadtips.wordpress.com/)

==========================================================================================
CÁC HÌNH THỨC ĐÀO TẠO
1- Học online, thông qua file video có thuyết minh tiếng Việt, thời gian học mọi lúc, mọi nơi;
2- Học offline tại địa chỉ 15Bis, Nam Quốc Cang, Phường Phạm Ngũ Lão,Q.1, tp. HCM, thời gian linh động;
3- Học tại văn phòng các công ty tư vấn, nhóm học viên, thời gian linh động.
===========================================================================

Liên hệ: Th.S. Phạm Ngọc Sáu Email: sauphampham@gmail.com hoặc sau.phamngoc@uah.edu.vn Phòng C402, khoa kỹ thuật đô thị, trường đại học Kiến Trúc Tp.HCM Thành viên nhóm KD Training

Biên soạn: Phạm Ngọc Sáu

Lượt xem: 3215

Thảo luận
Viết thảo luận
0 Thảo luận
    Pham Ngoc Sau 0902534019
    Pham Ngoc Bay 0972290107
    Le Khanh Trinh
    Luong Thanh Anh
    Nguyen Van Hieu
    Nguyen Van Chi Duc
    KYTHUATDOTHI.COM © 2005-2017
    Thiên Đường mua sắm,Đồ gia dụng, Quạt & Máy nóng lạnh, Máy tính và Laptop