next up previous contents index
Next: 10.1.2 Loading XLS Spreadsheets Up: 10.1 Importing Data into Previous: 10.1 Importing Data into

10.1.1 Loading WKS and WK1 Spreadsheets

     

NExS loads and saves WKS/WK1 format spreadsheets just as it does its own format. Use the Open... and Save... operations and specify the desired file type for the spreadsheet.

When loading WKS/WK1 files, NExS clears the current spreadsheet and loads the entire WKS/WK1 spreadsheet, along with its default characteristics such as column width and format. Note that there are differences between spreadsheet programs, so you may have to modify certain formulas or cells to get the spreadsheet to work properly in NExS.

You can import most spreadsheets without any difficulty, but those with complex interactions that use macros or certain functions will require some modification. Here are some principal differences between typical WKS/WK1 spreadsheet programs and NExS:

To load an existing WKS or WK1 Spreadsheet:

  1. Select Open... from the File menu and display its submenu.

  2. Click the File Format option button and select WKS or WK1.

  3. Click on the Selection entry box and type the name of the spreadsheet you wish to import, or select a spreadsheet by highlighting its name in the Files list.

  4. To select a different directory, double-click on the directory name in the Directories list. NExS then displays the names of files in that directory in the Files list.

  5. Click OK to load the spreadsheet.


By default, the File Filter box usually contains a file filter of *.[Ww][Kk]1 if you specified File Format WK1 and a file filter of *.[Ww][Kk][Ss] if you specified File Format WKS.


Remember that NExS clears the current spreadsheet and imports the entire WKS/WK1 file, along with default characteristics such as column width and format.

To load only part of a WKS/WK1 file, create a temporary spreadsheet that contains only the desired data, and import the temporary spreadsheet instead of the full original.

To load the data into an existing NExS spreadsheet with other data, import the data into a blank spreadsheet, then copy or move it from this NExS spreadsheet to the target spreadsheet.

Of course, an NExS spreadsheet can import data stored in NExS format, using either of two options:

Both methods transfer formats, fonts and formulas. For both methods, NExS updates cell references as appropriate. However, if the exported range contained references to cells outside the range, it will create error messages when imported into another spreadsheet.


next up previous contents index
Next: 10.1.2 Loading XLS Spreadsheets Up: 10.1 Importing Data into Previous: 10.1 Importing Data into

NExS User's Guide, Version 1.4.5
Grey Trout Software
11 April 1999