RSS
people

Link the Excel cell to AutoCAD Text

There are two ways to import the data of Excel into AutoCAD. If you want to import a whole worksheet or the selected range into AutoCAD with the formats in Excel, you can try AutoTable. It can import a whole worksheet or the selected range from Excel to AutoCAD perfectly. If you want the cells of Excel only (without the formats), it’s a more flexible way to link the cells of Excel into AutoCAD as a field. Field can exist in any Text, MText or Attribute. Let’s see how to do it with AutoField.

1. Use the Insert menu or right click to choose Insert ->Field.

2. Select “AF Excel Cell” in the left panel of the Field dialog.

3. Open an Excel file and select the cell you want to import.

4. Click “Get Active Cell” to get the active cell address.

image

5. If you want to use the relative path, please choose “Relative Path”.

image

6. Click OK to insert a field.

No Comments | Tags: ,

Calculate the length of multiple AutoCAD objects

AutoCAD Field is a great tool for AutoCAD 2005 or later. Fields are a really nice addition that give you quick access to various types of information via TEXT, MTEXT or an Attribute.

You can calculate the length of a single AutoCAD object (Line, Circle, Polyline etc.) with AutoCAD Object Field. But you can’t calculate the length of multiple AutoCAD objects. AutoField provides an additional field to do it.

1. Use the Insert menu or right click to choose Insert ->Field.

2. Select “AF Objects Length” in the left panel of the Field dialog.

3. Select the objects (supports LINE, POLYLINE, CIRCLE, ARC) to calculate.

image

4. Click OK to insert the field to the drawing.

4 Comments | Tags: ,

Calculate the area of multiple AutoCAD Objects

AutoCAD Field is a great tool for AutoCAD 2005 or later. Fields are a really nice addition that give you quick access to various types of information via TEXT, MTEXT or an Attribute.

You can calculate the area of a single AutoCAD object (Circle, Polyline etc.) with AutoCAD Object Field. But you can’t calculate the area of multiple AutoCAD objects. AutoField provide an additional field to do it.

1. Use the Insert menu or right click to choose Insert ->Field.

2. Select “AF Objects Area” in the left panel of the Field dialog.

3. Select the objects (supports POLYLINE, CIRCLE, ARC) to calculate.

image

4. Click OK to insert the field to the drawing.

8 Comments | Tags: ,

Count the AutoCAD blocks as a Field

AutoCAD Field is a great tool for AutoCAD 2005 or later. Fields are a really nice addition that give you quick access to various types of information via TEXT, MTEXT or an Attribute.

AutoField provides some useful additional AutoCAD fields. Let’s see how to insert the count of the specific INSERT (block reference) as a Field. Then the text of the count will be updated automatically after the block references were deleted or added.

1. Use the Insert menu or right click to choose Insert ->Field.

2. Select “AF Block Count” in the left panel of the Field dialog.

3. Select the block name you want to count. You can select multiple blocks to count their block references.

image

4. Click OK to insert the field.

5 Comments | Tags: ,