HP XP20000/XP24000 HP StorageWorks XP24000/XP20000 Remote Web Console User Gui - Page 127

Spreadsheets, Spreadsheet File Conventions

Page 127 highlights

Operands Operand input-file-name output-file-name Description Specifies the name of the spreadsheet that you want to verify, including a relative path or an absolute path. The maximum length of the file name is 240 characters. Specifies the output file name of the spreadsheet, including a relative path or an absolute path. The maximum length of the file name is 240 characters. This output file includes the execution result. If you specify the same name as the input file, the input file will be overwritten. Example When the following example for Windows is executed, the file ExtStorage_VolumeOperation.spd is applied and the execution result is saved in the file ExtStorage_VolumeOperation_Result.spd. CFLSET ExtStorage_VolumeOperation.spd ExtStorage_VolumeOperation_Result.spd For UNIX, add .sh to CFLSET (that is, CFLSET.sh). Spreadsheets This section explains general conventions for creating spreadsheets for use with CFL Extension. Spreadsheet templates are provided with Remote Web Console for your use. Make a copy of a template and edit it to write a spreadsheet. For details about the template file names, see the documentation for program products that support CFL Extension. Spreadsheet File Conventions Table 33 Spreadsheet Conventions Item File type File name Conventions Text file. The extension must be .spd. The maximum number of characters for the file name is 32, including the extension. The following symbols cannot be used for the file name and space The maximum length of the file path is 240 characters. Maximum number of rows 65,536 rows, including comment rows. in a spreadsheet End-of-line symbol Add a linefeed code at the end of each line. Maximum number of letters 512 bytes, including the linefeed code at the end. in a row Case sensitivity Case insensitive. Format • Separate each parameter with a comma (,). • Add a semicolon (;) at the end of the line where a parameter is written. • Tab codes and a series of spaces before or after comma are ignored. Spreadsheets 127

  • 1
  • 2
  • 3
  • 4
  • 5
  • 6
  • 7
  • 8
  • 9
  • 10
  • 11
  • 12
  • 13
  • 14
  • 15
  • 16
  • 17
  • 18
  • 19
  • 20
  • 21
  • 22
  • 23
  • 24
  • 25
  • 26
  • 27
  • 28
  • 29
  • 30
  • 31
  • 32
  • 33
  • 34
  • 35
  • 36
  • 37
  • 38
  • 39
  • 40
  • 41
  • 42
  • 43
  • 44
  • 45
  • 46
  • 47
  • 48
  • 49
  • 50
  • 51
  • 52
  • 53
  • 54
  • 55
  • 56
  • 57
  • 58
  • 59
  • 60
  • 61
  • 62
  • 63
  • 64
  • 65
  • 66
  • 67
  • 68
  • 69
  • 70
  • 71
  • 72
  • 73
  • 74
  • 75
  • 76
  • 77
  • 78
  • 79
  • 80
  • 81
  • 82
  • 83
  • 84
  • 85
  • 86
  • 87
  • 88
  • 89
  • 90
  • 91
  • 92
  • 93
  • 94
  • 95
  • 96
  • 97
  • 98
  • 99
  • 100
  • 101
  • 102
  • 103
  • 104
  • 105
  • 106
  • 107
  • 108
  • 109
  • 110
  • 111
  • 112
  • 113
  • 114
  • 115
  • 116
  • 117
  • 118
  • 119
  • 120
  • 121
  • 122
  • 123
  • 124
  • 125
  • 126
  • 127
  • 128
  • 129
  • 130
  • 131
  • 132
  • 133
  • 134
  • 135
  • 136
  • 137
  • 138
  • 139
  • 140
  • 141
  • 142
  • 143
  • 144
  • 145
  • 146
  • 147
  • 148
  • 149
  • 150
  • 151

Operands
Description
Operand
Specifies the name of the spreadsheet that you want to
verify, including a relative path or an absolute path. The
maximum length of the file name is 240 characters.
input-file-name
Specifies the output file name of the spreadsheet, including
a relative path or an absolute path. The maximum length
of the file name is 240 characters.
This output file includes the execution result. If you specify
the same name as the input file, the input file will be
overwritten.
output-file-name
Example
When the following example for Windows is executed, the file
ExtStorage_VolumeOperation.spd
is applied and the execution result is saved in the file
ExtStorage_VolumeOperation_Result.spd
.
CFLSET ExtStorage_VolumeOperation.spd ExtStorage_VolumeOperation_Result.spd
For UNIX, add
.sh
to
CFLSET
(that is,
CFLSET.sh
).
Spreadsheets
This section explains general conventions for creating spreadsheets for use with CFL Extension.
Spreadsheet templates are provided with Remote Web Console for your use. Make a copy of a
template and edit it to write a spreadsheet. For details about the template file names, see the
documentation for program products that support CFL Extension.
Spreadsheet File Conventions
Table 33 Spreadsheet Conventions
Conventions
Item
Text file.
File type
The extension must be
.spd
.
The maximum number of characters for the file name is 32, including the extension.
The following symbols cannot be used for the file name:
\ / : , ; * ? “ < > | and space
The maximum length of the file path is 240 characters.
File name
65,536 rows, including comment rows.
Maximum number of rows
in a spreadsheet
Add a linefeed code at the end of each line.
End-of-line symbol
512 bytes, including the linefeed code at the end.
Maximum number of letters
in a row
Case insensitive.
Case sensitivity
Separate each parameter with a comma (,).
Add a semicolon (;) at the end of the line where a parameter is written.
Tab codes and a series of spaces before or after comma are ignored.
Format
Spreadsheets
127