● Font Properties ● Cell Borders ● Fills & Patterns ● Gridlines ● Shapes w/Fill & Text ● Charts & Graphs ● Images ● ClipArt & WordArt ● Controls | ● Merged Rows/Cols ● Hidden 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 |
Function | Description |
---|---|
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 or intermediate files) and then creates the best possible representation of 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: | At any time in an editing session, you can issue this command and choose the tables to update (or simply type ALL). It checks the file dates on the Excel spreadsheets, and only updates if a table is out of date. |
Table Manager: | This dialog displays a list of all Excel spreadsheet references in the drawing and helps you manage them. |
Launch Excel: | Pick a spreadsheet reference in the drawing and this tool instantly opens Excel with the workbook open. The referenced tables sheet is selected, and range highlighted. |
Style Manager: | This dialog controls all the defaults for newly created spreadsheet references. Includes setting for auto update, overrides, factors and other options. |
Annotation Links: | Sometimes you don't need an entire Excel table. This mechanism lets you quickly create new linked annotation or links to existing annotations from single cells in the spreadsheet. When the drawing opens, the text/mtext changes to reflect the data in the spreadsheet. |
Attribute Editing: | Round trip system for editing block attributes in Excel. Select inserts and the attributes are exported to Excel. At any time (even after saving and closing both applications) highlight the content in Excel and recall the changes back to the original blocks. |
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 Bulk: | Quickly extracts all blocks and all attributes from multiple drawings. |
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: | Simply window off an array of text or mtext objects in the drawing, and have them immediately placed into separate appropriate cells in the open spreadsheet. |
Layer Import: | Creates layers in the drawing based on spreadsheet data. Use this dialog to control the import. |
Layer Report: | Generates a layer report of the current drawing in an open spreadsheet. Ther results include icons like CAD's Layer Dialog. |
Point Export: | Exports coordinates from nodal and linear geometry to a spreadsheet. |
Solid Export: | Exports the properties of CAD 3dSolids to an open spreadsheet in Excel. |
Table Export: | Exports an CAD 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. |
Title | Description |
CAD Tables: | Using the latest versions of & Excel we demonstrate why you can't use AutoCAD's table functionality for complex spreadsheets. Here is a large image showing comparative results. |
XL2CAD Tables: | Shows how quick and easy XL2CAD creates an accurate representation of your spreadsheet. |
Block Place: | Using our XL2CAD bonus tool, shows how easy it is to place blocks in drawings based 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. |
Engines: | • AutoCAD 2010-2012 (excluding LT) • AutoCAD 2013-2014 (excluding LT) • AutoCAD 2015-2017 (excluding LT) • AutoCAD 2018-2022 (excluding LT) • BricsCAD v15 Pro Windows • BricsCAD v16 Pro Windows • BricsCAD v17 Pro Windows • BricsCAD v18 Pro Windows • BricsCAD v19 Pro Windows • BricsCAD v20 Pro Windows • BricsCAD v21 Pro Windows • CMS IntelliCAD 8.3,8.4 Windows • CMS IntelliCAD 9.x Windows • CMS IntelliCAD 10.x Windows |
Optional: | • Excel 365 (32/64bit) • Excel 2016 (32/64bit) • Excel 2013 (32/64bit) • Excel 2010 (32/64bit) • Excel 2000-2007 |
Reviews: | CADalyst Labs: Highly Recommended, First Look Review, June 2006 |
Excel Spreadsheets & AutoCAD, Plumbing Systems & Design, Jan/Feb 2004. |
Pricing: |
|