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:

  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.
  2. Select the Excel file, specify the data range, and click OK to insert the table.
  3. Excel to CAD: When Excel data changes, click the prompt in the bottom right of ZWCAD to update the table.
  4. CAD to Excel: If cells are locked, right-click to select Unlock.
  5. After editing, right-click and select Upload User Changes to External Source to update the Excel file.

Method 2:

  1. Copy the target cells in Excel.
  2. In ZWCAD, right-click and select Paste Special.

  3. Select Paste Link and choose ZWCAD Entities, then click OK.



★★How to link ZWCAD tables with Excel data?https://confluence.zwcad.com/pages/viewpage.action?pageId=315655932