From the course: AutoCAD Electrical Essential Training

Unlock the full course today

Join today to access over 22,400 courses taught by industry experts or purchase this course individually.

Update a project from a spreadsheet

Update a project from a spreadsheet

From the course: AutoCAD Electrical Essential Training

Start my 1-month free trial

Update a project from a spreadsheet

- We're starting this particular video with Microsoft Excel. And you can see I've got the DEMO02.XLS file open. There it is, the name's at the top of the screen. And this is the xls file that we exported out in the previous video. Remember we did it from drawing demo02.dwg, and it was purely component data. Now I'm going to make some changes to the exported spreadsheet and then import those changes back into the drawing via the spreadsheet. So let's go down to the bottom of the spreadsheet and you'll see some motors there. There's a conveyor motor, a hydraulic motor and an indexing motor. We're going to change these values here. So we've got MOT208, MOT212 and MOT216. I'm going to change those, here, like so. So this is going to become 550, this one'll become 600 and this one'll become 650 like that. So we're just changing those values there. Go back up to the top of the spreadsheet, click on that top left cell there and then save it like so. So I've made those changes in the…

Contents