WinCC 3.16 read/write data from/to Excel

[Stefan_Schiestl]

Hello,

does anybody know a future-proof way to read/write data from WinCC OA to Excel?
The Reason i'm asking is, that the 3.16 releasenotes say "com Manager" and "OLEDB" will not be supportet for the future.

thanks for your replay
Stefan

[leoknipp]

The OLE DB Provider can only be used to read data. You cannot write data using a OLE DB connection.

Which kind of data (current, historical, configuration) do you want to read and write?

Best Regards
Leopold Knipp
Senior Support Specialist

[Stefan_Schiestl]

i want to write current data from WinCC OA controlscripts to an Excel Sheet. The data could be a timestamp of an datapoint. I also want to Read some kind of data from an Excel Sheet to WinCC OA datapoints.
The Excel sheet i want to Read/Write should work like a "database".

best regards Stefan

[leoknipp]

Is any other program using the data saved in the Excel sheet?
Can you use a different file format, e.g. a Tab separated file?
This type of file you can modify with file functions in WinCC OA and it is also readable in Excel.

Can you please describe the use case in detail.
Probably there are better solution than reading/writing data into a Excel file.

Best Regards
Leopold Knipp
Senior Support Specialist

[Stefan_Schiestl]

It is not possible to use a different format like an Tab separated file, cause the Excel sheet serves normally as a list of datapoints which is the documantation for our customer. My customer's default says that this document must be an appropriately formatted Excel list.
The document has a large number of formatted cells, which should not be lost due to my changes.

My use case is to document :
+ the test timestamp of a WinCC OA datapoint
+ the timestamp when designing of a datapoint have been changed in WinCC OA.


best regards Stefan