NCtable (NedCAD Table) is a tool set to make it easier to work with tables by linking real spreadsheets to CAD table entities. The workflow is as follows:
- With command
NCTableInyou can insert part of an external spreadsheet as a table in BricsCAD. That table also knows the file location of the spreadsheet.
NCTableEditcommand opens the spreadsheet to make changes to the linked spreadsheet.
NCTableRefreshrereads the spreadsheet associated with a table and refreshes the table in the drawing.
The supplemented standard summary given, when using the commands, is as follows, press F2 in the CAD program to make it visible.
Make sure you understand the basics. Below is a quick reference, issue command
NCTableHelp for details.
How it works
NCTableLib – the software library – contains spreadsheet table commands:
- Importing parts of an external sheet as a drawing table – command
- Selecting an imported drawing table for editing the external sheet – command
- Updating the drawing table with the external sheet data – command
The drawing table contains a copy of a range of cells from a spreadsheet and knows the file location of the sheet.
NCTableRefresh reward the value of
CANNOSCALEVALUE. In other words: Tables are scaled according to this value.
Please make sure you have…
- LibreOffice, LO, installed – https://www.libreoffice.org/.
- Told file NCTableLib.cfg where to
findLO and checked other settings – command
- CAD table data in the sheet between tags and as explained below.
- Tags only in first column and data (multiple columns) in between.
1 2 3 4 5
<tabledata var="value" more="" less="" vars="" from="" config=""> CAD-table-cell CAD-table-cell CAD-table-cell ... CAD-table-cell CAD-table-cell CAD-table-cell ... ... </tabledata>
- The selected cells become the table entity.
- The start tag
<tabledata ...>is in cell A7:
cols=3means that 3 columns are imported to CAD.
cell-width=(22 16 16)means that the columns are 22, 16 and 16 drawing units wide respectively.
- The end tag
</tabledata>is in cell A12.
Valid spreadsheet tags are:
cols=2, meaning that 2 columns are exported.
cell-width=(o p q ...)for each column defined or
cell-width=mfor uniform column widths. Reals. Example:
cell-width=(25 15.5 20)or
cell-height=has general height for cells in drawing units. A smaller than text height value makes it “fit”. Reals. Example:
table-style=string. Applied table style. Example:
Working with tables: NCTable