TablesĪutomatically take on changed style parameters when updated. This allows multiple styles to be defined and chosen during table placement. The table willįlow to the designated height, then move up and to the right to continue until done. Users can specify the maximum column height and gap distance.
Automatically updates changed Excel spreadsheets on drawing open, even those embedded in xreferences.Recipients of your drawings (especially on other CAD systems) may have problems with the OLE representation.OLE Objects can 'bleed through' multiple layouts in CAD, showing up in places where they don't belong.Drawings with embedded OLE objects make huge multi-megabyte files.If the drawing is plotted rotated, the OLE does not rotate.Plotting problems in which OLE appears 'grainy', 'fuzzy', etc.Linked OLE won't grow/shrink as you add/delete rows and columns.OLE Size is limited to 'a page worth' meaning large spreadsheets lose rows and columns.OLE has it's limitations, XL2CAD doesn't! We also merge adjacent fills and hatches resulting in the smallest block possible. If the same lineweight is used across the entire row, we create one line, not one for each cell. That's why we optimize the geometry we create. We understand that you want to keep your CAD drawing size small and regens fast. Our fast Excel read engine means most sheet sized tables process in less than one second! The example above processed in 1.1 seconds, even with 147 hatched areas! Having an accurate useable representation of your spreadsheet does not mean a compromise on speed. So when you reopen your drawing, XL2CAD quickly evaluates the tables in the drawing(including xrefs) and automatically updates only those that have changed!
Since the date and time of creation (along with the spreadsheet file name) is stored, it can easily determine when the table representation needs updating. When XL2CAD creates the table in the drawing, it stores extended data on the insert. Tools that output content can push into an active Excel session or write a XLSx file and open it in your default spreadsheet application. This has been the default file format since Excel 2007 and is available as a file format in OpenOffice (or LibreOffice) so you have a choice. New Release: Having Microsoft Excel installed is now an option! XL2CAD's new dual mode operation allows it to communicate with Excel to obtain the spreadsheet information, or read the XLSx (OpenXML) format directly.
The results are lines, fills and mtext that can plot without problems and is highly portable to others. It instantly draws the Excel spreadsheet in CAD using native geometry and links it. XL2CAD overcomes the limits and problems associated with OLE placement of Excel spreadsheets inside AutoCAD, BricsCAD and IntelliCAD.