Tables

       Ribbon: Home – Annotation –  nanoCAD Table

       Ribbon: Annotate – Tables –  nanoCAD Tables

       Menu: Draw – Tables >  Tables…

       Toolbar: Draw, Tables –

 Command line: TABLE, TB

The command opens the Create table dialog box to insert a new table. The dialog box is divided into 3 parts: the table type selection section, table options and additional insert options:

To create a non-standard table:

1.      Click the Custom table item.

2.      Use the numeric entry fields to set the parameters for the custom table. The number of rows or columns and cell sizes can be altered later when the table is first edited. When filling in the Columns and Rows fields, the first field is the length, the second is the quantity.

To insert a standard table:

1.      Click the Load from base item.

2.      A standard table can be inserted from the nanoCAD library:

3.      Choose the desired table type in the dialog box. All basic standard tables are present in the nanoCAD library.

To insert a table from a file:

1.      Click the Load from file item.

2.      Click the Browse button and select the table file.

Supported formats:

·         tbl             - tables format;

·         dat - data file or text file;

·         mdb, accdb           - Microsoft Access database (for 32-bit Windows only);

·         xls             - Microsoft Office Excel table;

·         xlsx            - Microsoft Office Excel 2007 table;

·         csv - table, cells are divided by commas;

·         txt             - standard text file;

·         xml            - XML document.

When loading a table from *.xlsx, *.xls files, select an Excel document sheet and specify the range in the Query field. By default, the range of all data on the selected sheet is specified. If necessary, you can manually specify your own range or specify a named Excel range.

The Use origin format switch determines whether the cell formatting from the source document should be transferred to the table being created.

When loading the table from an mdb format file, the list of base queries is displayed in the drop-down list:

It is important! The list choice can be carried out after loading the table from a file.

To do this:

1.      In the Source query line, enter the required list from the document.

note: In the table properties, the Source file line displays the path to the initial table file.

2.      Then in the Table edit dialog box click the Update table from external source  icon.

note! To import tables from files, it is possible to drag a file from the browser to the Table edit dialog box.

When dragging a file from the browser into the table field, the imported table is added to the existing table.

When dragging a file from the browser into the dialog box field, the imported table replaces the existing table

To generate an object base report:

1.      Click the Object based report item.

2.      To choose the required objects, click the Select button:

3.      Setting of search conditions is carried out in the Quick Selection dialog box:

4.      Which attributes of the chosen objects the report is based on are also set in this dialog box.

The attributes to be included in the report are switched by tags in the list or switches:

Buttons:

The report with a template of a view is created in the table:

=Iff(Exist(Object."AttributeName");Object."AttributeName";"")

This expression checks the existence of the given attribute line with the AttributeName name and uses its value in the cell. Otherwise, it leaves a cell empty:

The number of columns in the table is defined by the number of chosen attributes.

Note: If the objects group was previously selected on the drawing and the Tables  command is activated, then you will be offered the option to create an object-based report.

To import table from Excel:

1.      Select the Import from Excel item.

Note! The document should be opened to make this item active.

The Use origin format switch determines whether the cell formatting from the source document should be transferred to the table being created.

2.      Click OK and specify the table insertion point in the drawing:

To import a table from the clipboard

To make this option active, a table should be stored in the clipboard (for example, by copying an area from an Excel sheet).

Additional table insertion options

Table insertion point

One of four possible options shall be selected.

The row numbering method:

If the Bottom to top box is checked, the rows will be numbered in reverse order.