Autodesk Civil 3D / Help Document
Batch attribute block ref. creation from worksheet

Batch attribute block ref. creation from worksheet

Win64, English
NTCL Soft
Batch create attribute content with Microsoft® Excel® autofill, batch convert Excel content into Attribute Block references Maintain data integrity with Excel worksheet.

General Usage Instructions

The procedures of block creation, in brief, can be divided into 4-5 steps:

1. Define block(s) (with or without attributes) then run this App;

2. Pre-selected data range (rows & columns) in Excel worksheet. Press "Activate Excel" to find out which instance is linked (usually the last open worksheet);

3. Select a block name or  an Excel column that contains multi-block names;

4. Select macro mode (A) and match block refs. positioning parameters with Excel columns (B);

5. (Optional) Match attributes with Excel columns (C);

Click "Insert block references" to see the results.

Screenshots

Commands

Ribbon/Toolbar Icon Command Command Description

NTCLP_BlockFromExcel

Batch creates new Autodesk® AutoCAD® block references from Excel worksheet data.

NTCLP_PolylineReverse

Reverse direction of a selected polyline (2D, 3D, and LightWeight polyline types are supported).

Installation/Uninstallation

The installer that ran when you downloaded this app/plug-in from Autodesk App Store will start installing the app/plug-in. OR, simply double-click the downloaded installer to install the app/plugin. You may need to restart the Autodesk product to activate the app/plug-in. To uninstall this plug-in, exit the Autodesk product if you are currently running it, simply rerun the installer, and select the "Uninstall" button. OR, click Control Panel > Programs > Programs and Features (Windows 7/8.1/10/11) and uninstall as you would any other application from your system.

Additional Information

  1. If no Excel worksheet is opened before, this app will try to open a blank worksheet. Your input must be copied to this blank worksheet. In case you want to use input values from an existing worksheet, close the app and the blank worksheet, and pre-open the existing worksheet before running this app;
  2. This app only works with desktop versions of Excel. In case multiple Excel versions are installed, this app may work with the default version;
  3. Users can terminate the app during the Excel interaction process by pressing the ESC key (key press event only works with the App dialog, not works with the Excel interface);
  4. When inserting multi-block types at once, it is recommended that those blocks have the order of the same attributes. Attribute tags are not necessarily to be the same, but attributes of the same contents should be placed in the same order in each block definition. Use BATTMAN built-in command to arrange attributes order, and click SYNC to update existing block references.

Known Issues

1. In some case, this App cannot connect Excel® in Microsoft® 365 (Office® 365).  The NTCL Error message: "Cannot open Microsoft® Excel®" may appear right after App is called.

This error can be fixed by running "Quick repair" on Microsoft® 365 (Office® 365). For more information, please refer to: https://www.NTCLSoft.com/home/troubleshooting

Contact

Company Name: NTCL Soft
Support Contact: NTCLApp1@gmail.com

Author/Company Information

NTCL Soft

Support Information

For questions/comments/suggestions/bug reports etc please send an email to NTCLApp1@gmail.com 

For more information about the license, please visit: https://www.ntclsoft.com/home/license-registration-guide

Version History

Version Number Version Description

1.1.0.0

Bugs fixed: - Fix the bugs when merged cells appear in the Excel selection range, only the upper left cell of the merged area has value; Improvements: - Users can now create different block types in one click. Block names are also retrieved from an Excel Column, - Add a button to delete block references, filtered by block name. - Add an option to create multi-block references by X, and Y coordinates, through all Layouts (except Model space). - Add an option to declare a universal block scale before the creation. - Add an option to show External references in the block name drop-down list. - More compacted interface.

1.0.0.2

Bugs fixed: - Extremely slow processing speed if user select entire column(s) in Excel as input data; Improvements: - Users can now terminate the app during excel interaction process by press ESC key (key press event only works with the App dialog, not works with Excel interface); - Users no longer need to check the first active AutoCAD/ AutoCAD vertical instance of any versions;

1.0.0.1

Bugs fixed: - Message "Unknown Error" or "Method not found..." shows in 2021 version when call the App; - Message "This App will NOT work properly if it is called from a Non-Active instance..." shows when running the App with a drawing which has Data shortcuts; - App may not work when another version of AutoCAD/Civil 3D/ AutoCAD Map 3D/AutoCAD Architecture opens at the moment before App call and after the first Autodesk application open (application which call the App and is version different) ; - Block list shows with a click then disappear after mouse button releases.

1.0.0.0

Initial version
Go top