Exporting a spreadsheet, Editing the spreadsheet, 51 the export dialog box – HP XP20000XP24000 Disk Array User Manual
Page 94
Note:
The instructions in this section assume the use of Microsoft Excel 2000. Microsoft Excel is
recommended for best compatibility.
Exporting a Spreadsheet
To export a spreadsheet file:
1.
Log in to Remote Web Console, and open the Configuration File Loader window (see
Configuration File Loader Window
2.
Change to Modify mode (see “
Changing Between View Mode and Modify Mode
3.
Select the program product option that you want to export from the Select Sheet drop-down list.
4.
Click Export to open the Export dialog box (for the example of LUN Manager, see
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 either enter the name of the spreadsheet directory 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
maximum number of characters including the extension is 32.
• The following symbols cannot be used for the file name: \ / : , ; * ? “ < > | and space.
• The
file path must be under 255 letters.
6.
Once you have specified the directory and file name, click Save to close the Save dialog box
and return to the Export dialog box. The specified directory is displayed in File Name on Client
and the Export button becomes available.
7.
Click Export to export the spreadsheet file and close the Export dialog box. To cancel the
exporting operation, click Close on the Export dialog box.
8.
After you 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 Spreadsheet
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 edit 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
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
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 Import Wizard - Step 3 of 3 dialog box.
94
Performing Remote Web Console Operations