How to achieve mutual conversion between CAD tables and Excel tables in CAD software?

Thread Content

When using the HaoChen CAD software to create drawings, tables are often needed, and these tables may also appear as part of project files in Word and Excel. During the CAD design process, these tables are frequently modified as the CAD drawings change. So how can CAD tables be synchronized and converted back and forth with Excel tables? Next, I will share with you how to quickly convert between CAD tables and Excel tables, as well as some points to keep in mind. 1. Where was the table originally created? Although tables in Excel or WPS can be converted to those in CAD, choosing the appropriate tool for initial creation can help you achieve more with less effort. Compared to the table functions in CAD, those in Excel and WPS are more powerful; we can apply various complex styles such as fonts, colors, fills, as well as control the row heights and column widths of tables. Although HaoChen CAD basically supports these formats, the appearance of some table styles after conversion in CAD differs from that in Excel, requiring some adjustments for fine-tuning. The same problem occurs when converting CAD tables to Excel and WPS as well. Therefore, at the initial stage of creation, designers need to consider issues such as the amount of work required for modifications and the frequency of these modifications, and choose appropriate tools to create the tables, with synchronization handled in other places. 2. Conversion between Excel tables and CAD tables: Converting CAD tables to Excel. Those familiar with CAD know that there are actual table objects in CAD, namely real tables, as well as fake tables composed of text and lines. The strength of Haochen CAD lies in its ability to convert both real tables and fake tables, without the need for plugins. For fake tables, we use 【Extension Tools】—【Table to Excel】 to convert them. For a real table, we can expand it into a fake table for conversion. To convert an Excel spreadsheet to CAD, select the area of the spreadsheet that needs to be converted in Excel, then use Ctrl+C to copy it. In HaoChen CAD, under the traditional interface, go to the menu and select [Edit] – [Paste Special]. Among them, the GCAD elements paste actual tables, and this application is used the most. There are also those formatted as Microsoft Excel worksheets; the advantage is that double-clicking on the pasted table allows for editing and modification in Excel. You can try the other effects by yourself. GCAD element effects, Microsoft Excel worksheet effects. The above are the detailed procedures for converting between CAD tables and Excel tables while using the Haochen CAD software to create CAD drawings; I hope this will be helpful to everyone.