Registering Tables

Excel spreadsheet

To register a table with data from an Excel spreadsheet, follow these steps:

  1. Select View to an existing Excel Spreadsheet if you have data in a Microsoft Excel spreadsheet that you want HR Vision to convert to a table.
  2. Click Browse to search for the appropriate Excel spreadsheet.
  3. When you locate the desired spreadsheet, click Open.
  4. In the Number of Skipped Rows field, enter the number of rows that you want to exclude before your data is imported.
    Depending on the options that your administrator has set, this field might not be available.

  5. If the first row to be included is column headers, click Yes.
  6. Click Next.
The values for the column headings can contain only valid SAS characters, colons, commas, and dashes. If the values for the column headings in the Excel spreadsheet contain other characters, such as a forward slash or backslash, then the spreadsheet cannot be registered correctly.

In order to complete your new table, you must provide the following types of information: