There are two types of text output files, both of which are readable by Excel. The value of TXT for OutputFileFormat in the script file indicates a tab-delimited text file with a file extension of .txt; the value of CSV for OutputFileFormat in the script file indicates a comma-delimited text file with a file extension of .csv. The first row of the data will be column names, which are selected from the keyword list in the table above.
The following is a partial output from the OpcHdaRaw.xml sample script in comma-delimited output file format (*.csv).
DataValue,TimeStamp,Quality
12.345,December 23 2004 8:30:00,192
12.346,December 23 2004 8:31:00,192
12.347,December 23 2004 8:32:00,192
12.348,December 23 2004 8:34:00,192
The following is a partial output from the OpcHdaProcessed.xml sample script in tab-delimited output file format (*.txt).
DataValue TimeStamp Quality
12.345 December 23 2004 8:30:00 192
12.446 December 23 2004 8:40:00 192
12.547 December 23 2004 8:50:00 192
12.648 December 23 2004 9:00:00 192
The following is the output from the OpcHdaAttr.xml sample script showing a comma-delimited output file of the current data type.
AttributeValue,TimeStamp
5,December 24 2004 8:30:00