CAD2Excel

CAD2Excel

Win32 and 64, English

KozMos Inc.
Table conversion between AutoCAD® and Excel

General Usage Instructions

CAD2Excel contains three parts: CAD2XL Project, XL2CAD Project –MTEXTContent and XL2CAD Project –TEXTContent.

CAD2XL Project can automatically analyse the border lines of a real AutoCAD table drawn, and then rebuild a representation table in the active Excel spreadsheet. CAD2XL Project works perfectly with merged cells. Both text and mtext inside the cell region will be treated as cell content. Multiple annotations within one cell will be marked and sorted by their Y coordinate and their contents will be joined by linefeed. We can select the whole table or just part of the table.

XL2CAD Project is designed to import from current active Excel spreadsheet and create AutoCAD table (using normal TEXT or MTEXT and lines).

XL2CAD Project provides two annotation types (TEXT and MTEXT) to show the contents. While importing from Excel, different font size and name will be processed accordingly when MTEXT is used.

More detailed information can be found at Bundle folder/Contents/Resources/CAD2ExcelHelp.docx

Commands

Ribbon/Toolbar Icon Command Command Description

XL2TEXT

XL2TEXT use TEXT as content objects to rebuild the Excel spreadsheet. Multiple line contents will be simulated by multiple text objects. By ignoring the Excel fonts, size settings, XL2TEXT can create a very simple table in AutoCAD.

CAD2XL

CAD2XL Project can automatically analysis the border lines of a real AutoCAD draw table and rebuild a representation table in active Excel spreadsheet. Then can provide data synchronization between AutoCAD and Excel.

XL2MTEXT

XL2MTEXT use MTEXT as content objects to rebuild the Excel spreadsheet and Excel settings such as fonts, color will be imported into AutoCAD.

Installation/Uninstallation

The installer that ran when you downloaded this plug-in from Autodesk App Store has already installed the plug-in. You may need to restart the Autodesk product to activate the plug-in. To uninstall this plug-in, click Control Panel > Programs > Programs and Features (Windows 7/8/8.1/10) or Control Panel > Add or Remove Programs (Windows XP), and uninstall as you would any other application from your system.

Additional Information

Known Issues

Analysis speed on Excel Range:

The analysis speed on Excel Range varies with computer hardware configuration. As XL2CAD Project will scan the cells one by one in order to collect various fonts' settings as well as the merged cells, the analysis speed can be pretty slow for huge Excel spreadsheets. In such situations, the user can select partial contents in Excel and execute selected range only.

Control strings' conversion from Excel to AutoCAD:

There may be some characters used in AutoCAD MTEXT as control flag strings. If these strings are placed into Excel cells as content, the conversion will be a little complex. Even normal "Paste Special" in AutoCAD may cause some errors while facing the control characters (if we enter "\\P" at Excel, AutoCAD will only get "\P" in content and "\A" in Excel will be ignored). XL2CAD Project has all these control characters processed normally while the conversion procedure. 

If you are working with these control characters, XL2CAD Project will be your best choice because XL2CAD Project can save your time in checking the content converted from Excel to AutoCAD. 

Contact

Company Name: KozMos Inc.
Company URL:
Support Contact: kozmosovia@hotmail.com

Author/Company Information

KozMos Inc.

Support Information

Version History

Version Number Version Description

2.5.5

Added latest support Supports Weekly Rental Service in China. Remove Kagi Store link as Kagi has terminated the service.

2.5

Support AutoCAD2017

2.0

2.0 Integrated and published on Exchange Apps

Go top