Issue:
How to link ZWCAD tables with Excel so that data updates in one trigger changes in the other?
Solution:
Data synchronization requires importing Excel tables via Data Link.
Method 1:
- Execute the Table command (TABLE). Select From a data link, click the Launch the Data Link Manager dialog button.
And then right-click Excel link and select Create a new Data Link to name the link. - Select the Excel file, specify the data range, and click OK to insert the table.
- Excel to CAD: When Excel data changes, click the prompt in the bottom right of ZWCAD to update the table.
- CAD to Excel: If cells are locked, right-click to select Unlock.
- After editing, right-click and select Upload User Changes to External Source to update the Excel file.
Method 2:
- Copy the target cells in Excel.
In ZWCAD, right-click and select Paste Special.
Select Paste Link and choose ZWCAD Entities, then click OK.
| CN Solution | ★★中望CAD表格如何实现和EXCEL表格数据关联 |
|---|---|
| JP Solution |
★★How to link ZWCAD tables with Excel data?:https://confluence.zwcad.com/pages/viewpage.action?pageId=315655932






