help importing an excel file in elect06

[Anonymous]

i need help with the format of an excel spreadsheet that i have created which contains all plc io for a project. where and with what terminology do i specify contact, push button, ect. thanks for any help

[dougmcalexander]

Go to your USER folder and look at the file demoplc.xls. Use that file as a guide for syntax. The best is to copy demoplc.xls and rename it for your project. Then use it as a starting point and edit to match your needs. You must name the PLC I/O the same name as they are called when inserting using the Parametric PLC insert tool. The discrete components must be named according to their block name in the library folder, but you do not have to put the .DWG extension. For example if you want a normally open pushbutton, call for HPB11 under the D1BLK column. The discrete block entries are denoted by red text. If you don't know the name of a block, place one down on a drawing and double-click it. The block name will appear at the top of the Enhanced Attribute Editor dialog popup. You can also type list at the command prompt and click on the block. After you have done this a while you start memorizing your favorites.