《使用ole将wincc归档数据导出到excel》由会员分享，可在线阅读，更多相关《使用ole将wincc归档数据导出到excel（46页珍藏版）》请在金锄头文库上搜索。
1、 Application for Process Automation Export of WinCC / CAS Archive Data to Excel using the WinCC OLE DB Provider Export of WinCC / CAS Archive Data to Excel using the WinCC OLE DB Provider Application Note Warranty, liability and supportExport of WinCC / CAS Archive Data 35840700V1.0 08.10.2009 2/46C
2、opyright Siemens AG 2009 All rights reserved Note The Application Examples are not binding and do not claim to be complete regarding the circuits shown, equipping and any eventuality. The application examples do not represent customer-specific solutions. They are only intended to provide support for
3、 typical applications. You are responsible for ensuring that the described products are used correctly. These application examples do not relieve you of the responsibility to use sound practices in application, installation, operation and maintenance. When using these Application Examples, you recog
4、nize that Siemens cannot be made liable for any damage/claims beyond the liability clause described. We reserve the right to make changes to these application examples at any time without prior notice. If there are any deviations between the recommendations provided in these application examples and
5、 other Siemens publications e.g. Catalogs the contents of the other documents have priority. Warranty, liability and supportExport of WinCC / CAS Archive Data 35840700V1.0 08.10.2009 3/46Copyright Siemens AG 2009 All rights reserved Warranty, liability and support We do not accept any liability for
6、the information contained in this document. Any claims against us based on whatever legal reason resulting from the use of the examples, information, programs, engineering and performance data etc., described in this Application Example shall be excluded. Such an exclusion shall not apply in the cas
7、e of mandatory liability, e.g. under the German Product Liability Act (“Produkthaftungsgesetz”), in case of intent, gross negligence, or injury of life, body or health, guarantee for the quality of a product, fraudulent concealment of a deficiency or breach of a condition which goes to the root of t
8、he contract (“wesentliche Vertragspflichten”). However, claims arising from a breach of a condition which goes to the root of the contract shall be limited to the foreseeable damage which is intrinsic to the contract, unless caused by intent or gross negligence or based on mandatory liability for in
9、jury of life, body or health. The above provisions do not imply a change of the burden of proof to your detriment. Copyright 2009 Siemens I IA. Any form of duplication or distribution of these application examples or excerpts hereof is prohibited without the expressed consent of Siemens I IA. For qu
10、estions about this document please use the following e-mail address: online- Table of ContentsExport of WinCC / CAS Archive Data 35840700V1.0 08.10.2009 4/46Copyright Siemens AG 2009 All rights reserved Table of Contents Warranty, liability and support. 3 Table of Contents. 4 Preface. 5 1 Introducti
11、on. 7 1.1 Background. 7 1.2 Structure of the documentation. 7 1.3 Runtime environment. 8 1.4 Test results. 8 2 Structure, Function and Application . 10 2.1 First call of the application. 10 2.2 Setup of the application window. 11 2.2.1 Toolbar design. 14 2.2.2 Table view. 14 2.3 Operation of the Application. 15 2.3.1 Application call . 15 2.3.2 Making the basic settings. 16 2.3.3 Making the filter settings. 17 2.3.4 Adapting the message structure . 21 2.3.5 Rea
