HCBBS Forum (English)
Submit Chemical Projects / Find Solutions
Amplify Your Requirements on a Broader Chemical Platform *Engineering · Technology · Equipment · Solutions*
Submit Request

【CAD+EXCEL】A powerful combination to take control of it!

2020-09-17View Original

Thread Content

In their daily design work, designers are certainly familiar with CAD-based drawing creation, but they often find complex table data analysis tasks to be quite challenging. Table data, as an important output of the design process, is essential. Therefore, the siege lions always sigh that it would be great if creating tables in CAD software could be as convenient as it is in EXCEL. Next, the editor will share with you the expert tips for quickly creating tables in HaoChen CAD software, so that you can create tables more efficiently and become an expert in this area. Method 1: Insert a table by using the TABLE command (shortcut key TAB), then enter the parameters such as the number of columns, column width, number of rows, and row height, and finally click OK. After pulling up the table, fill in the data sequentially, and adjust the alignment and font style of the table data. This is the simplest method for drawing tables. Method 2: Data conversion between EXCEL and CAD – After creating the table in EXCEL, copy the table data to the HaoChen CAD software. Use the “Paste Special” option under the Edit menu, select GCAD elements, and click OK to paste the table created in EXCEL into CAD. Note: EXCEL cannot be used to directly copy and paste tables into HaoChen CAD, as what is copied and pasted is an image rather than a table in proper format; therefore, it is necessary to select GCAD elements. Method 3: Call the TABLE command from the data link, select “From Data Link”, and click the icon on the right to create a new EXCEL data link. In the file preview, select the already created EXCEL spreadsheet file and insert it into the HaoChen CAD software. Notes: This method is similar to the selective paste option in Method 2, but the tables created by it cannot be modified directly in the HaoChen CAD software; modifications must be made in the EXCEL source file. After the modifications are completed, a notification regarding data update will appear in the lower right corner of the HaoChen CAD software interface; alternatively, you can use the DATALINKUPDATE command to keep the CAD data synchronized with the EXCEL data. Method 4: The extension tools for HaoChen CAD software. Of course, these extension tools integrate common table drawing functions. There is no need to switch to EXCEL; the HaoChen CAD software provides the same table editing functions as EXCEL, thereby **overcoming the drawback of traditional CAD software, where its table functions are not convenient or fast enough. Through the table tools in HaoChen CAD software, it is possible to create tables quickly; in addition, functions such as merging tables, splitting tables, and automatically filling in data are available, enabling advanced and customized editing of CAD tables – ensuring accurate content and an attractive layout! Is it full of useful information and practical? Everyone no longer needs to worry about how to create tables and analyze data in the Haochen CAD software!

Submit a Project

**Looking for Chemical Technology, Equipment & Solutions?** No Registration Required Broader Platform Exposure | Global Chemical Service Provider Connections

Submit Request — Free Consultation

Disclaimer

This is an automated machine translation of the original thread. Some technical terms may have inaccuracies; the original text shall prevail. Click "View Original" at the top right to access the source page, which supports IP-based automatic real-time language translation. Please watch out for contact details and sales inducements to prevent fraud. All content and translations are for reference only, representing solely the poster's personal views. For enquiries, email service@hcbbs.com.