在實(shí)際中， 過程數(shù)據(jù)是最重要的。項目激活或去激活時，我們都需要對指定格式的數(shù)據(jù)進(jìn)行處理。Wincc v6是一款功能強(qiáng)大的HMI 系統(tǒng)。它可以組態(tài)界面并且可以對數(shù)據(jù)進(jìn)行歸檔。但是由于Wincc v6 中的歸檔數(shù)據(jù)是會被壓縮的，并且不保存在主數(shù)據(jù)庫中，因此我們需要將歸檔數(shù)據(jù)導(dǎo)出，以方便進(jìn)行數(shù)據(jù)處理。Wincc v6 提供VBS 的開發(fā)環(huán)境，用VBS，我們就可以方便得修改數(shù)據(jù)格式。本文提供了一種解決方案，將歸檔數(shù)據(jù)導(dǎo)出到Excel 中。
關(guān)鍵詞：歸檔數(shù)據(jù)；WinCC；數(shù)據(jù)庫

Archiving data processing of WinCC V6 ZHEN Li-dong，WEI Jin，NIU Wen-yong, LI Jian-ping （The State Key Lab of Rolling and Automation，Northeastern University，Shenyang110004，China） Abstract：In practice, the process data is the most important. We need to manage the data with the certain format in both Online and Offline. Wincc V6 is powerful HMI system. With it, we configure the interface and archive the process data. Due to the archives in Wincc V6 are compressed and not stored in the main memory, so we must export the data of the archives. With version 6, Wincc offers the design environment of Visual Basic Script(VBS). Use VBS, we can change the data format to needed format easily. This paper offers a solution to export data of archives into Excel.
Key words：archiving data; WinCC; Excel