 | | XL2CADovercomes the limits and problems associated with OLE placement ofExcel spreadsheets inside AutoCAD. It instantly draws the Excelspreadsheet in AutoCAD using native geometry and links it to thespreadsheet. The results are lines, fills and mtext that can plotwithout problems and is highly portable to others. |
Smart Linking & Updating
When XL2CAD creates the table in the drawing, it stores extended dataon the insert. Since the date and time of creation (along withthe Excel spreadsheet file name) is stored, it can easily determinewhen the table representation needs updating. So when you reopenyour drawing, XL2CAD quickly evaluates the tables in the drawing(including xrefs) and automatically updates only those that havechanged! Amazing Speed
Having an accurate useable representation of your spreadsheet does notmean a compromise on speed. Our fast Excel read engine means mostsheet sized tables process in less than one second! The example above processed in 1.1 seconds, even with 147 hatched areas! Optimized Results
We understand that you want to keep your AutoCAD drawing size small andregens fast. That's why we optimize the geometry we create. If the same lineweight is used across the entire row, we create oneline, not one for each cell. We also merge adjacent fills andhatches resulting in the smallest block possible. OLE has it's limitations, XL2CAD doesn't! - OLE Size is limited to 'a page worth' meaning large spreadsheets lose rows and columns.
- Linked OLE won't grow/shrink as you add/delete rows and columns.
- Plotting problems in which OLE appears 'grainy', 'fuzzy', etc.
- If the drawing is plotted rotated, the OLE does not rotate.
- Drawings with embedded OLE objects make huge multi-megabyte files.
- OLE Objects can 'bleed through' multiple layouts in AutoCAD, showing up in places where they don't belong.
- Recipients of your drawings (especially on other CAD systems) may have problems with the OLE representation.
Standard Excel Features Supported: ● Font Properties
● Cell Borders
● Fills & Patterns
● Gridlines
● Shapes w/Fill & Text
● Charts & Graphs
● Images
● ClipArt & WordArt
● Controls | | ● Merged Rows/Cols
● Spillover
● Indents
● Center Across Selection
● Conditional Formatting
● Mixed Fonts in Cell
● Geometry Layers
● Layer by Lineweight
| | ● Relative Path Option
● Background Mask
● Border Polyline
● Toolbar Driven
● Menu Driven
● Command Execution
● Excel 12 XLSX Format
● Excel 12 TableStyles |
- Automatically updates changed Excel spreadsheets on drawing open, even those embedded in xreferences.
- Uses named ranges, allowing the table to grow/shrink as you to add/remove rows or columns.
- Manage multiple spreadsheet references on multiple sheets easily.
- Exclusive column wrapping. Users can specify the maximum column height and gap distance. The table will
flow to the designated height, then move up and to the right to continue until done. - Style settings. This allows multiple styles to be defined and chosen during table placement. Tables
automatically take on changed style parameters when updated. Style files can be shared and administered. - Full support for images and all shapes (lines, connectors, basic shapes, flowchart, callouts, etc) including
fill colors, patterns, and internal text. - Quickly scan a project folder (or an entire drive) for drawings that need updating, then process them in
batch, unattended. - Uses AutoCAD's TrueColor capabilities for exact color matching from Excel.
Interface Choices
Control the application with your choice of command line entry,pulldown menu, traditional toolbars or ribbon interface (AutoCAD 2010and higher). 
Product DetailsTheXL2CAD Standard Version contains everything you need to import Excelspreadsheets into AutoCAD. The Professional Version comes with anexcellent collection of additional tools, see the table below. Function | Description | Std | Pro | | Toolbar & Menu Driven: | Initiate the tools in AutoCAD with your choice of the toolbars, pull down menu, or commands. | √ | √ | | Create New Tables: | Simply highlight the desired area in your spreadsheet, then launch our table creation tool. It talks to Excel through the ActiveX channel (no clipboard orintermediate files) and then creates the best possible representationof your spreadsheet, including solid fills and truetype fonts. The resulting geometry is bound into a block insert for easy movement, erasure, etc. | √ | √ | | Change Properties: | After an Excel table has been placed, you can easily change all of the properties. | √ | √ | | Update Selection: | Atany time in an editing session, you can issue this command and choosethe tables to update (or simply type ALL). It checks the filedates on the Excel spreadsheets, and tells you if a table doesn't need updating. | √ | √ | | Table Manager: | This dialog displays a list of all Excel spreadsheet references in the drawing and helps you manage them.
| Count: | Number of references found. | | Details: | Excel file name, sheet, range, current file date. | | Zoom: | Zooms and centers the selected table on the screen. | | Update: | Updates the selected table from the spreadsheet file. | | Delete: | Removes the selected table from the drawing. |
| √ | √ | | Launch Excel: | Picka spreadsheet reference in the drawing and this tool instantly opensExcel with the workbook open. The referenced tables sheet isselected, and range highlighted. | √ | √ | | Style Manager: | This dialogcontrols all the defaults for newly created spreadsheetreferences. Includes setting for auto update, overrides, factorsand other options. | √ | √ | | Annotation Links: | Sometimes you don't need an entire Excel table. This mechanismlets you quickly create new linked annotation or links to existingannotations from single cells in the spreadsheet. When thedrawing opens, the text/mtext changes to reflect the data in thespreadsheet. | | √ | | Property Expressions: | Push properties of objects into specific Excel spreadsheet cells. The Expression Manager lets you push and link (system variables, areas, lengths, dimension measurements, text strings, block counts, etc) to Excel. At any time you can update specific cells, or have all expressions automatically updated when you open the drawing. | | √ | | Block Count: | Exports selected block names with the count of its inserts. Use this dialog to prepare the export. | | √ | | Block Place: | Highlight a range of block data with coordinates in Excel and choose this tool. Totally data driven, allowing control over each field and all attributes populated. | | √ | | Block Scan: | Scan multiple drawings, extracting blocks/attributes to an open Excel spreadsheet. Use this dialog to prepare the export. | | √ | | Annotation Export: | Simplywindow off an array of text or mtext objects in the drawing, and havethem immediately placed into separate appropriate cells in the openspreadsheet. | | √ | | Layer Import: | Creates layers in the drawing based on spreadsheet data. Use this dialog to control the import. | | √ | | Layer Report: | Generatesa layer report of the current drawing in an open spreadsheet. Theresults include icons like AutoCAD's Layer Dialog. | | √ | | Point Export: | Exports coordinates from nodal and linear geometry to a spreadsheet with total control. Use this dialog to setup which fields to export, and in what order. | | √ | | Table Export: | Exports an AutoCAD 2005+ table object to an open spreadsheet in Excel. | | √ | | Path Find/Replace: | When projects move to different drives or folders, use this tool to quickly repath all linked references in multiple drawings. | | √ |
XL2CAD Demonstrations
The following Flash Movies demonstrate portions of the application. | | Title | Description | Std | Pro |  | AutoCAD Tables: | Usingthe latest versions of & Excel we demonstrate why you can't useAutoCAD's table functionality for complex spreadsheets. Here is alarge image showing comparative results. | √ | √ | | XL2CAD Tables: | Shows how quick and easy XL2CAD creates an accurate representation of your spreadsheet. | √ | √ | | Block Place: | Usingour XL2CAD bonus tool, shows how easy it is to place blocks in drawingsbased on coordinates and attributes in a spreadsheet. | | √ | | Anno Export: | Using our XL2CAD bonus tool, shows export of an array of text/mtext to the active spreadsheet. | | √ |
Easy Implementation
You can add XL2CAD to any AutoCAD system, no matter how heavilycustomized. The installation changes no AutoCAD files. Since it does not have any windows DLL dependencies, its easy for CADManagers to add XL2CAD to server based systems* without having toinstall XL2CAD on the workstation. * Low cost site licenses are available for large groups and server systems. System Requirements: Requires full AutoCAD 2007 or higher, LT not supported. | AutoCAD: | 2010 | | Excel: | 2007 | | Windows: | 2000 | | | 2007-2009 | | | 2003 | | | XP | | | | | | 2002 | | | Vista | | | | | | 2000 | | | |
Legacy: For AutoCAD 2000-2006, see XL2CAD 5.0. Product Support: Email Support Only Product Demo: Available on Request
| Price: | Standard Version, $95. Professional Version, $145 | | | For differences, see the rightmost columns on tables above. |
|
