Hi everyone,

I want to fill in an MS-Excel file with fields Address, Declaration, Name, Type, Initial Value, Actual Value and Comment of a DB, Data Block. I select and copy the whole line of DB specification table, in DB editor in LAD/FDL/STL, and paste it to the MS-Excel sheet, all of but Address field does paste. Please let me know if it is possible to paste the address field, and if yes, how?

I am using Siemens S7 with Wincc v6.2. When you need to use the "WinCC Configuration tool", a macro is added to MS-Excel when you install WinCC on your computer. I want to know if there is a simpler way to do it than the one above.

Best regards,

k.zonouzi ahmad

 

Open the DB in the STL editor and print it to a PDF file, then copy-paste from PDF file to Excel. You can find a complete article here (look for "Import Step7 datablocks into Excel"):
http://www.runmode.com/usefulstuff.html

Regards,
Luca Gallina

 

Hi Luca Gallina,

Thank you for the reply, I got my answer. But the site you mentioned was even more useful, thank you for this site also.

Best regards,
k.zonouzi ahmad