
Sharing data with other Windows applications 16–19
Tag name
Creating a pivot table in Microsoft Excel
Use a pivot table to display and analyze data from any narrow–format
.dbf log file.
The basic steps for creating a pivot table are:
Open Microsoft Excel and start the PivotTable
®
Wizard
Select the data source
Join tables and select data
Organize the pivot table
This column Contains SQL Data Type Length
TagName The tag name. SQL_VARCHAR or
SQL_CHAR
255
TagIndex The index number assigned to the tag
name.
SQL_SMALLINT
or SQL_INTEGER
2
TagType The tag type:
2—analog tag
3—digital tag
4—string tag
SQL_SMALLINT 1
TagDataType The tag data type:
0—long
1—float
2—string
SQL_SMALLINT 2
Kommentare zu diesen Handbüchern