User manual

Using @aGlance with Excel A-17
SIMATIC PCS 7 OSx 4.1.1 @aGlance
Use the GetAttributes function (Figure A-12) to retrieve a list of attribute
names for a set of tags.
 ServerName field — the prefix osx must appear in front of the OSx
station name.
 TagRange field — select the range of cells that contain the tag names
for which you need attributes.
 MatchString field (optional) — enter a text search string. You can use
the standard wildcard * (match any) and ? (match single) characters.
 StartIndex field (optional) — enter an integer or cell reference with the
integer as the contents of the cell. The server uses the index as a
placeholder when there is more data to return than there are output
cells. The default is zero, which directs the server to return values
starting at the beginning of its database. If you use a cell reference, you
can view the entire list by p ressing
Try-it without having to enter a new
StartIndex every time.
 OutputRange field — select one or more cells to display the data
requested from OSx. A non-zero index value in the upper left corner
indicates that the server has additional data to send. The system uses
this index value in subsequent calls to retrieve additional attribute
names. To take advantage of this feature, you must change the
StartIndex field to reference this cell (for example, B2).
osxstation1
loop1 loop2 ai23
Cells B2--B5 will display the requested attribute names.
B1 shows the index returned by OSx to access further
attributes. Now when you request tag values with the Get
function, you can use cells C2--E5 for the output range.
501
STATUS
UNITS
CHANGE
L_RANGE
A
BC D E F
GH
1
2
3
4
11
12
13
5
6
7
8
9
10
@aGlance/IT Macro Tool
AAG Functions...
ServerName....
TagRange...
[MatchString]..
OutputRange...
T
ry-it Paste-it Help Close
P
aste-it Cell...
Pause
[StartIndex]...
“GetAttributes”
=$A$2
=$C$1:$E$1
=“*”
=$B$1
=$B$2:BE$5
14
Figure A-12 GetAttributes Function
GetAttributes