Importing an XLS format file

Data can be imported from an .xls or .xlsx file created using Microsoft Excel or another spreadsheet program. The imported data fills a new table that is created automatically during import, and the new table is formatted automatically to match the format of the original spreadsheet.

To import an XLS format file

   1   Do one of the following to choose XLS In ():

    On the ribbon, choose Insert > XLS In (in Data).

    On the menu, choose Insert > XLS In.

    Type xlsimport and then press Enter.

   2   Choose the .xls or .xlsx file that contains the data you want to import.

   3   Click Open.

   4   If the specified file contains more than one sheet, enter the name of the sheet to import. If necessary, type ? and press Enter to see a list of sheet names.

   5   Specify the insertion point for the upper-left corner of the table.