beautypg.com

4-2-2 editing the spreadsheet – HP StorageWorks XP Remote Web Console Software User Manual

Page 122

background image

Configuration File Loader 122


Figure 5-9

Save Pane

5-4-2-2 Editing the Spreadsheet

These instructions assume the use of Microsoft® Excel 2000. If you use a different spreadsheet software, all

values must be displayed in text format.

1.

Launch Microsoft® Excel 2000 and open the exported spreadsheet.

2.

The Text Import Wizard Pane 1 opens (see Figure 5-10).

3.

Set your chosen parameters, and then click Next to continue. The Text Import Wizard Pane 2 (see Figure

5-11) opens.

4.

Set your chosen parameters, and then click Next to continue. The Text Import Wizard Pane 3 (see Figure

5-12opens. Set your chosen parameters, and then click Finish. The spreadsheet will open with all the values

in the text format.

5.

Edit the spreadsheet in accordance with the allowable parameters. Refer to sections 5-2 and 5-3 for details.

6.

Once you have edited the spreadsheet, you need to save and close the file. Enclose the file name within

quotation marks, with an .spd extension. Click CSV (comma delimited) (*.csv) in the Save as type drop-down

box, then save the file. See Figure 5-13 for an example.