Batch attribute block ref. creation from worksheet

Batch attribute block ref. creation from worksheet

Win64, English

NTCL Soft
Time-Unlimited trial. Quickly 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 steps:

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

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

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

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

Click "Insert block references" to see results.

Commands

Ribbon/Toolbar Icon Command Command Description

NTCLP_BlockFromExcel

Batch create new AutoCAD block references from Microsoft® 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) 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, just close the app and the blank worksheet, pre-open the existing worksheet before running this app;
  2. This app only works with desktop versions of Microsoft® Excel®. In case multiple Microsoft® Excel® versions are installed, this app may work with the default version;
  3. Users can 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);
  4. For the Free version, the number of attributes whose values can get from Microsoft® Excel® is limited to 3 (three); mode "4. Along Civil 3D alignment" is unavailable; option "Ignore hidden Rows" is unavailable;

Known Issues

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.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