Enhanced block info to/from worksheet

Enhanced block info to/from worksheet

Win64, English

NTCL Soft
Multi files batch Export/Import block references to position, attributes, and dynamic properties directly to/from Microsoft® Excel® worksheet.

General Usage Instructions

  1. Start by opening a Excel worksheet (Active drawing processing option only: remember to reserve 1 blank column at the active cell (values will be written downward));
  2. Press Alt+Tab to return to Autodesk® AutoCAD® or its vertical products, and invoke the NTCL_BlockToExcel command. The user form will appear;
  3. For the Active drawing processing option, on the user form, open a drawing;
  4. For the Multi files processing option,  load the drawing list from folder/ from files/ from Excel files .... to the table;
  5. Select macro mode: 1 (Cad Block info => Excel worksheet) or 2 (Excel info => Cad Block update). Select additional options (block name, where to get block refs from, which information to export, and import). Mode 1 should run before Mode 2 unless you saved and re-use the results of Mode 1 before;
  6. If you select mode 1, the block information will be exported to Excel. For the first export action, blank columns will be automatically added to the right side of the active cell;
  7. If you select mode 2, the block information will be imported from Excel. For the Active drawing processing option: Be sure to pre-select the data range in Excel first. The selected range must include a header row & a handle column.  For Multi files processing option:  Be sure you have to write permission for drawings in List;
  8. Be aware that, this app CAN NOT create new block references, so the workflow is often: Export block data - Edit data in Excel - Import block data to update AutoCAD drawing.;
  9. If you have multiple Excel instances already open, this App may tie to the last activated Excel instance but sometimes it does not. In such case, please close all opening Excel instances; close (end task) any invisible Excel.exe process by Task manager, and re-open only one Excel instance;

Commands

Ribbon/Toolbar Icon Command Command Description

NTCL_BlockToExcel

Info of block references can be quickly batch exported to/re-imported from the Excel worksheet. Info including insertion point (X, Y, Z), rotation, attributes, and dynamic properties. Multi-file processing 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. Be aware that unsaved values that are overwritten in the Excel worksheet by this app cannot be undone in Excel. It is recommended to save an Excel worksheet & reserve enough blank columns/ or check the "Auto insert blank columns before exporting" before running this app.
  2. If no results are returned to Excel, please check: (a) Input values are correct, sometimes a block is defined but no block reference is placed in the drawing (b) the App is being tied to an invisible running Excel.exe process. In such cases, please close all Excel instances, including those invisible Excel.exe processes.
  3. If no Excel worksheet is opened before, this app will try to open a blank worksheet.
  4. Press ESC during processing to terminate App.
  5. In Multi-file processing mode, when successfully importing data from Excel, drawing files will be auto-saved.  The previous version is backed up in the same folder.BAK2 extension.
  6. This app only works with desktop versions of Excel. In case multiple Excel versions are installed, this app may work with the default version.

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 

Version History

Version Number Version Description

2.0.1.0

Bugs fixed: - Parent application crashes when run in Multi-file processing mode without an opening draw. - Attributes do not move/ rotate properly together with block references; - Dynamic properties do not export in some cases; Improvements: - Add an option "Single worksheet" for Multi-file processing mode to combine all drawing files and export results in one worksheet. Best fit for single sheet drawings title block;

2.0.0.0

Major improvements from the free version (version 1.0). - Increase processing speed by 10-20 times. - Add a Multi-file processing option. - Allow the user to terminate the app during processing by pressing the Esc key. - Add a reload last state button to return the last form parameters. - Add the select All option for selecting all block references in drawings. - Add a button for Select block name on the screen. - App can now run from any Autodesk® AutoCAD®/ AutoCAD verticals instance. No need to keep track of the first active instance of AutoCAD/ AutoCAD verticals.
Go top