
Note:
The instructions in this section assume the use of Microsoft Excel 200 0. Microsoft Excel is
recommended for best compatibility.
Exporting a Spr
eadsheet
To export a spre
adsheet
file:
1. Log in to Remote Web Console, and open the Configuration File Loader window (see
“Configuration File Loader Window”onpage67).
2.
Change to Modi
fy
mode(see“Changing Between View Mode and Modify Mode” on page 39) .
3. Select the p r
ogram product option that you want to export from the Select Sheet drop-down list.
4. Click Expor
t
to open the Expor t d ialog box (for the example of LUN Manager, see
Figure 51 on page 94).
Note:
If you use the Mozilla web browser, the Download Manager dialog box may display
when you click Export. If this occurs, close the Download Manager dialog box and continue
the
operation.
5. You can eit
her
enter the name of the spreadsheet dire ctor y directly in File Name on Client,or
you can click Browse to open the Save dialog box, which allows you to specify the directory for
the
spreadsheet file. The following rules apply for the file name:
•The file extension must be . spd.
•The maxim
um
number of characters including the extension is 32.
• The following symbols cannot be used for the file name: \ / : , ; * ? “ < > | and space.
•The file pa th must be under 255 letters.
6. Once you
have specified the directory and file name, click Save to close the Save dialog box
and
retu
rn to theExportdialogbox. The specified directory is displayed in File Name on Client
and
the Expor t button becomes available.
7. Click Export to export the spreadsheet file and close the Export dialog box. To cancel the
export
ing
operation, click Close on theExportdialog box.
8. After y
ou
have exported the spreadsheet file, you can log out from Remote Web Console if you
want, but it is not required.
Figure 51 The Export Dialog Box
Editing the Spreadsh eet
Note:
The instructions explained in this section assume the use of Microsoft Excel 2000. If you use a
different spreadsheet software, all values must be displayed in text format.
To ed
it a spreadsheet file:
1. Launch Microsoft Excel, click File and Open, then open the exported spreadsheet.
The Text Import Wizard - Step 1 of 3 dialog box is displayed.
2.
Set the original data type as shown in Figure 52 on page 95, and then click Next to continue.
The Text Import Wizard - Step 2 of 3 dialog box is displayed.
3.
Set
the
delimiters as shown in Figure 53 on page 96, and then click Next to continue.
The
Text Import Wizard - Step 3 of 3 dialog box is displayed.
4. Set
the
text data format to all columns in the Text Impor t Wizard - Step 3 of 3 dialog box.
94
Performing Remote Web Console Operations
Comentários a estes Manuais