(Part 5 – Updating drawing PLC I/O Description and Address text from Excel)
This is the 5th installment of the Excel / AutoCAD Electrical tutorial. The first four were:
- Part 1 – Copy existing project drawing set, export “To Spreadsheet”, edit in Excel, update drawings “From Spreadsheet”
- Part 2 – Ability to not only push edited attribute values from Excel to the drawing set, but do “block swap” as well
- Part 3 – Enhancing the editing capabilities by adding your own custom attribute columns to an existing Excel sheet and having these work with the “From Spreadsheet” update tool
- Part 4 – Editing wire number assignments from Excel and then pushing the edits back into the project drawing set
In “Part 1” we did some simple drawing updates based upon schematic component info held in the “COMP” sheet. But there are sheets for seven other categories of terminals, PLC I/O, wire numbers, and panel components.
5th Installment – Updating drawing PLC I/O Description and Address text from Excel
Repeating here what we did in part 1 of the tutorial, this is how we initiated the dump of key data categories of our active AutoCAD Electrical project out to an Excel spreadsheet.
After the dump above creates the Excel spreadsheet, we open up the PLCIODESC sheet (or SHEET1 if selected the option marked in yellow above). Here’s part of the PLCIODESC sheet (below). There is one row for each I/O point of each I/O module found in the schematic project drawing set.
We can edit the I/O address for each point or we can add in up to five lines of description text for each I/O point, right here in the spreadsheet.
Below is an example where we’ve replaced three “SPARE” I/O points with actual description assignments.
We can enter up to five lines of text for each I/O point.
Then, on the update “From Spreadsheet”, this data will find the proper I/O module (using the “handle” and the “drawing name” link as described earlier) and update the appropriate description text attributes on the I/O module.
Note: See “Step 4 – Trigger the Excel –> Drawing update” in the Part 1 of the tutorial for complete step-by-step of this “From Spreadsheet” update sequence.