Help Center

Work with MS Excel

Importing a Table from Excel

CAD drafting Work with MS Excel 0    Ribbon: Annotation Tables CAD software Work with MS Excel 1 Import table from Excel

CAD drawing Work with MS Excel 2    Menu: Draw Table > CAD drafting Work with MS Excel 3 Import Table

CAD software Work with MS Excel 4    Toolbars: Tables, Utilities CAD drawing Work with MS Excel 5

CAD drafting Work with MS Excel 6  Command line: TABLEEXCELIMPORT

The command transfers data from an open worksheet in MS Excel:

     

1.    In the open Excel list, select the cell data from which it is required to import to the nanoCAD table.

2.    Click the Import table from Excel  button in the Table Edit dialog box.

3.    The data will be transferred into the table.

Exporting a table to Excel

CAD software Work with MS Excel 7    Ribbon: Annotation Tables CAD drawing Work with MS Excel 8 Export table to Excel

CAD drafting Work with MS Excel 9    Menu: Draw Table > CAD software Work with MS Excel 10 Export Table

CAD drawing Work with MS Excel 11    Toolbars: Tables, Utilities CAD drafting Work with MS Excel 12

CAD software Work with MS Excel 13  Command line: TABLEEXCELEXPORT

 

The command is intended for transferring tabular data to MS Excel. After running the command, a new Excel workbook opens and all table data is transferred to it, preserving the cell formatting set in the table.

note! The following data are not exported to Excel from the nanoCAD tables:

              - nanoCAD blocks;

              - Formatted text;

              - Expression mismatched Excel format.

Info: NanoCAD is a user friendly, inexpensive, and yet powerful, CAD freeware tool for personal computer, that provides a great user experience by providing enhanced performance, full capability, a classic interface and native.dwg format support. nanoCAD has been built to deliver design and project documentation for all industrial purposes. nanoCAD includes a full suite of basic and advanced CAD tools for 2D/3D drawing and creating industry-standard DWG-compatible CAD files. Our software supports groundbreaking, collaborative and customizable features to raise your efficiency, and includes several API's, allowing anything from routine task automation to complex CAD software development. You may try nanoCad for free, using the links below, and purchase later, in case you like it.
We collect Cookies
We use cookies to ensure that we give you the best experience on our website. By clicking “Accept”, you agree to our website’s cookie use as described in our Privacy Statement.