Enhanced block info to/from worksheet
With this enhanced version, block reference information from multi drawings can be quickly batch exported to/re-imported from Microsoft® Excel® worksheet.
Processing speed is greatly improved (10x-20x faster) thanks to totally re-coding.
The typical workflow is Export - Edit - Reimport.
For Multi files processing, it's not necessary to open drawing on-screen or manually select Excel data range, just add files to the list, fill in parameters per file, then export or import.
For active drawing processing, the drawing should be active, Excel data range should be pre-selected before export or import.
Exported /imported Information includes:
- Block insertion point (X,Y,Z) & rotation angle (in radian)
- Block attributes
- Dynamic Properties
What's new in this App
- Unlike classic commands (ATTIN, ATTOUT), this app can extract coordinates, and layout names which are useful for sorting block refs.
- Unlike the new powerful DATAEXTRACTION command, this app can re-import values from worksheets to update existing drawing block refs. Also, exporting/importing procedures are minimized to save time.
- The enhanced version now supports multi-file processing with jet speed.
Typical working scenarios are:
Batch numbering, naming .... title block refs: By using attribute blocks as a title block, users can export attributes (drawing number/ name/ title ...) to Excel, edit attributes... with the help of Excel Data sort & Autofill feature. Re-import those updated values and the nightmare manual work of incremental numbering is done with ease.
Rebuild drawing list from existing attribute block (used as drawing title block).
Update coordinate attributes of block references: Export block refs' positions, copy new coordinate values X Cad, Y Cad columns to attribute column; re-import from Excel to update.
Exported block coordinates can be used for inquiry Station- offset, use Station offset for further sorting/editing.
- This app cannot create new block references, just export - edit - reimport to update objects. Block reference objects are recognized by their Handle property (some kind of object ID in a specific drawing).
- To create a new block from Excel data, users can try this App for free, unlimited time: Batch attribute block ref. creation from worksheet
- A paid license is physical computer hardware dependent. After purchasing, please run this App, open the About... panel, and manually copy & send your registration info to the NTCL support email NTCLApp1@gmail.com. For more details, please refer to the License registration Guide.
- During waiting for a perpetual license file, this App still runs with full functions.
- For purchasing volume of 50 or more licenses, assuming that all PCs work in the same local domain network, a specific domain-based license may be distributed instead of an individual license if required and such a domain-based license is technically feasible.
- Users will get a message if this App package is launched from a virtual machine. App launched from a virtual machine will be limited in features like the free version.