Sheet set to/from Excel - PRO

Sheet set to/from Excel - PRO

Win64, English

NTCL Soft
Use Excel Autofill to batch edit Sheet properties (built-in and custom) and Sheet drawing paths. Advanced edits of Sheet Set DST file. Multi-language support.

General Usage Instructions

The procedure for batch editing File path, Sheet Number and Sheet Title in an existing Sheet set file is as follows: 

  1. Use this App to open an existing sheet set file.
  2. Click the Export button to partially export sheet set content to Excel.
  3. In Excel, only edit the 3 columns with blue text: File path, Sheet Number, and Sheet Title.
  4. Return to the App, and click the Import button to update the sheet set file with a new File path, Sheet Numbers and Sheet Titles read from Excel columns. Edited sheet set file will be overwritten with backup, or saved as a new sheet set file.

 

The procedure for cloning a project from the source to the destination folder is as follows:

  1. Open the Clone Project wizard.
  2. Select the source sheet set file. Drawing paths will be collected from the source sheet set file.
  3. Select a destination folder to which the drawings will be copied.
  4. Select a location to save as the edited sheet set file.

 

The procedure to fix the Sheet drawing path in a Sheet set file is as follows:

  1. Open the DST fixes drawing file path wizard.
  2. Select the source sheet set file and search for the missing drawing path.
  3. Choose an option: (1) Replace all drawing paths if found in a new location or, (2) Replace only the missing drawing path.
  4. Select a parent folder that contains missing drawings and replace the original Sheet drawing paths. Drawings may be in subfolders.
  5. Save as the edited Sheet set file.

Commands

Ribbon/Toolbar Icon Command Command Description

NTCL_SSE

Use Excel Autofill to batch edit Sheet properties (built-in and custom) and Sheet drawing path. Advanced edits of Sheet Set DST file. Multi-language support.

Installation/Uninstallation

The installer that ran when you downloaded this app/plug-in from the 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 plugin, 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

- App interfaces support 7 languages.  However, progress messages are in the text box, and some message boxes are in English.

- Not all characters can be used in the Sheet title and Sheet number. 

These characters are not supported by Autodesk® AutoCAD® if users input from the "Rename and Renumber Sheet" dialog: \ < > /? " : ; * | , = `

If users edit the Sheet title and Sheet number from Excel, these characters are still allowed.  However, users should carefully check if any errors may occur for the Sheet set.

Known Issues

In some cases, this App cannot connect Excel® to Microsoft® 365 (Office® 365). The NTCL Error message: "Cannot open Microsoft® Excel®" appears right after the 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.0.5

Improvement: - App now can extract sheets from complicated sheet set file with nested subsets Bug fix: - Fix a bug that causes some sheet properties not to update as expected

1.0.0

Initial version.
Go top