HP XP20000XP24000 Disk Array - Manual (Page 95)

Note: Each row has a different number of columns in a spreadsheet. When you set the data
format, you need to select the row that has the largest number of columns in the spreadsheet.
If the data format is not set to text, the data might be converted to a numeric number and be
displayed.
To set the text data format:
a. Scroll down to the bottom of the Data preview, and find a row with the largest number of
columns.
b. Select all columns of the row that you found at step a), and select the Text in the Column
data format (see Figure 54 on page 96).
5. Make sure the header of all columns in Data preview is displayed as Text, and then click Finish.
The spreadsheet opens with all the values in the text format.
6. Edit the spreadsheet in accordance with the allowable parameters.
For details, see the document of each program product.
7. 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 (for example,
"spreadsheet1a.spd"). Select CSV (comma delimited) (*.csv) in the Save as type drop-down
list, and then save the file.
Figure 52 Text Import Wizard - Step 1 of 3 Dialog Box
XP24000/XP20000 Remote Web Console User’s Guide 95