Registering Tables
Excel spreadsheet
To register a table with data from an Excel spreadsheet, follow these steps:
- 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.
- Click Browse to search for the appropriate Excel spreadsheet.
- When you locate the desired spreadsheet, click Open.
- 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.
- If the first row to be included is column headers, click Yes.
- 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: