How to Link AutoCAD Block Attributes to Excel Sheet with Excellink 2007
If you are using AutoCAD 2007 or any of its vertical applications, such as Map 3D, Mechanical, Architecture, etc., you may want to link your block attributes to an Excel sheet. This way, you can easily update your block data from Excel, or export your block data to Excel for further processing.
One of the tools that can help you achieve this is Excellink 2007, an ARX application developed by CAD Studio. Excellink 2007 allows you to bidirectionally link attribute and block data between an AutoCAD drawing and an Excel 2000/XP/2003 sheet[^1^].
In this article, we will show you how to use Excellink 2007 to link your AutoCAD block attributes to Excel sheet in a few simple steps.
Step 1: Install Excellink 2007
To use Excellink 2007, you need to download and install it from the CAD Studio website[^2^]. You can choose the trial version or purchase the full version. The trial version has some limitations, such as a maximum of 50 blocks per drawing and a watermark on the output.
After installing Excellink 2007, you will find a new toolbar in your AutoCAD interface. You can also access the commands from the command line by typing EXL.
Step 2: Define Your Blocks and Attributes
Before you can link your block attributes to Excel sheet, you need to define your blocks and attributes in AutoCAD. You can use any existing blocks or create new ones. The attributes can be visible or invisible, depending on your preference.
For example, let's say we have a drawing of a floor plan with some furniture blocks. Each furniture block has two attributes: NAME and PRICE. We want to link these attributes to an Excel sheet that contains the furniture inventory.
Step 3: Link Your Block Attributes to Excel Sheet
Once you have your blocks and attributes ready, you can use Excellink 2007 to link them to an Excel sheet. Here are the steps:
Open the Excel sheet that contains the data you want to link to your block attributes. Make sure the sheet has a header row with the same names as your attribute tags. For example, our Excel sheet looks like this:
In AutoCAD, select the blocks that you want to link to the Excel sheet. You can select them individually or use filters or selection sets.
On the Excellink toolbar, click on the Link button. This will open the Link dialog box.
In the Link dialog box, choose the option Link selected blocks to Excel sheet.
Click on the Browse button and locate the Excel file that you want to link to.
Select the sheet name and the range of cells that contain the data. You can also use named ranges or tables.
Click on the Match button to match the attribute tags with the column names in the Excel sheet. You can also manually match them by dragging and dropping.
Click on OK to create the link.
Congratulations! You have successfully linked your block attributes to Excel sheet with Excellink 2007. You will see a confirmation message like this:
Step 4: Update Your Block Attributes from Excel Sheet
Now that you have created the link, you can update your block attributes from Excel sheet anytime you want. Here are the steps: aa16f39245