![Block references to/ from Excel® worksheet package](https://autodesk-exchange-apps-v-1-5-staging.s3.amazonaws.com/data/content/files/images/KPG6RPMYQHRB/5553466964569244773/resized_117f4dfc-45a3-480e-ad8d-b892e03d2f9d_.png?AWSAccessKeyId=AKIAWQAA5ADROJBNX5E4&Expires=1726112233&response-content-disposition=inline&response-content-type=image%2Fpng&Signature=9idharN5YwcKGBrXnrYNktWx0gc%3D)
Block references to/ from Excel® worksheet package
![](../../../Content/images/Digital_Signature_24.png)
![](https://s3.amazonaws.com/apps-build-content/appstore/1.0.0.134-PRODUCTION/Content/images/icons/popupheader.png)
Digitally signed app
Descrizione
September 2024 beta update: https://bit.ly/NTCL_BlockPackage
- 3 mini tools added: Dynamic block converter, advanced block replace and copy across layouts
- App Block (creation) from excel now double the attributes to 24 attributes; block rotation can read from Excel column
- App Enhanced Block info to/from Excel now can export/import attribute fields
*
The ultimate package for batch processing Block references with the assistance of Microsoft® Excel® AutoFill.
The package combines 5 apps with some enhanced features that are not available in the free version:
1. Enhanced Block info to/from the worksheet: 2-way (Read-Write) version of the classic Data Extraction command. Multi blocks per drawing\ multi drawings' info can be exported to just one worksheet, under a unique header row. Best for batch-filling Title block attributes with the help of AUTOFILL. Support Multiple Visibility States dynamic blocks, which may be useful for managing devices' status in a device circuit. Field attributes export/import also supported.
2. Batch attribute block ref. creation from the worksheet: The app can fill up to 24 block attributes, 12 dynamic properties, and clone fields after block reference creation, work with Autodesk® Civil 3D® alignment, deal with alignment station equations, and possibly ignore hidden rows in Excel.
3. Alignment of SONE to worksheet: The app is now able to deal with station equation(s), and an option for blank columns is inserted automatically, the app can be terminated during processing with the ESC key.
4. 2-group intersection with order: Create and assign numbers to intersections between 2 groups of Polylines/Lines/SPLines. Insert block/point/text objects at intersections. Export results to Excel worksheet.
5. Advanced Batch Plot: Plot/ Print multi drawings, multi Layouts, and multi sheets per Layout. The printing configuration of each drawing is automatically saved. Sheets may be auto-combined into one PDF file with Bookmarks. Auto turn on/ turn off paper space Viewports. Auto ignores null content sheets. Read the sheet list from Autodesk® AutoCAD®.DST and . DSD files.
6. More block utilities:
- A Batch dynamic block converter: Convert dynamic blocks of multi drawings to static block. This tool may help users to protect precious, complicated dynamic blocks from unauthorized copy. Detailed instruction
- An advanced version of Block replace tool: Block with attributes and dynamic (custom) properties are replaced properly without errors. Attributes, fields and custom properties of old block can be retained. Only support active drawing. Detailed instruction
- A tool for copy entities across multi layouts: Overlapping entities at destination layouts may be erased at will. Only support active drawing. Detailed instruction
Notes:
- For more information about how to use every single app in the package, please refer to the NTCL Soft website or NTCL published apps.
- Users can use this App package with:
- (a) A simple signing-in parent Autodesk application with a valid Autodesk ID that made the purchase. In this way, the user can run this App package from any computer, provided that an internet connection is available; or
- (b) An offline license file, which is dependent on physical computer hardware. 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.
- While waiting for a new/renewed license file, this app still runs with full functions.
- Renew subscription: For a renewed license purchase, a signing-in Autodesk account is required until an offline license file is sent to the user.
- For purchasing a 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.
- The single app version can still work with the Paid package App. Please manually uninstall a single app version if necessary.
- The app launched from a virtual machine will limit some features. Users will get a message if this app is launched from a virtual machine.
The publisher continues to add more Apps to the package.
The new App Advanced Batch plot is interesting. It helps users who often plot from Model like me.
My first customer, thank you for your encouragement