General Resource Loader (GRLoader) › How to Prepare for Loading Spreadsheet Data

How to Prepare for Loading Spreadsheet Data

If the spreadsheet includes instructions, comments, and data that you do not want load into CA SDM, specify the exact area you want to import into GRLoader. To specify the area of the spreadsheet to use as input, use GRLoader to provide the spreadsheet file name, the spreadsheet sheet name, the first and last rows, and the first and last columns, as set by the –i (or -ssf), -sss, -ssfr, -sslr, -ssfc, and –sslc options.

Perform the following tasks before loading CI data from a spreadsheet with GRLoader.

1. Identify the general area of the spreadsheet to use as an input to GRLoader.
2. If necessary, map attribute names and data values using a translation file.
3. Identify parts of the spreadsheet that GRLoader must ignore or skip.

The input examples in the following sections use a fictitious spreadsheet named grloader_spreadsheet_example.xls. This spreadsheet contains nine subsheets, named Sheet1, Sheet2, Sheet3, and so on.

More information:

Spreadsheet Input Options