7/28/2009 6:00 AM | |
Joined: 10/7/2005 Last visit: 9/23/2024 Posts: 3021 Rating: (1054) |
Hello lalit you are right, extensive DB editingcan sometimes be "painful" in Step7 and while you cancopy from aDB into Excel, you can unfortunately NOT copy back from Excel into the DB. Siemens does however have a tool (chargeable via the Automation value card) that allows usage of Excel (e.g. for easy for mass data and comment creation) and then creates thecorrectly formatted source fiele so the DB can be compiledfrom it. The link to it is: Automatic generation of an S7 data block (DB) from an MS Excel table Alternatively, should you be familar with Excel macros, you can create your own DB source file creation macro. I hope this helps. |
Cheers |
|
This contribution was helpful to1 thankful Users |
7/28/2009 6:17 AM | |
Joined: 12/20/2008 Last visit: 8/12/2024 Posts: 556 Rating: (236) |
Fritz, Thanks once again for answering my query. 1. My question is why siemens has a tool which is chargable, can it be used for any other purpose other than Siemens Tag generation. 2. I am familier with macro, but did not understand how can I create my DB file, could you send any example or similar things? Thanks
|
7/28/2009 8:57 AM | |
Posts: 8946 Rating: (999) |
For such cases Iuse the very powerful program SEARAREP,
http://www.weepee.biz/de/seararep/srdownloads.html Sorry, only in german laguage |
This contribution was helpful to3 thankful Users |