Next: 10.1.2 Loading XLS Spreadsheets
Up: 10.1 Importing Data into
Previous: 10.1 Importing Data into
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:
- NExS stores all internal values as double-precision
floating point numbers, whereas some spreadsheets
store numbers as 16-bit integers. NExS converts
integers to double-precision floating point numbers as
they are imported.
- Some spreadsheets have built-in functions that are not
present in NExS. If NExS encounters an unfamiliar
function, it stores the text of the function in the
cell as a text entry. You can then use NExS Edit
features to modify the formula to work under NExS.
- Some spreadsheets support cell formats that NExS does
not recognize. If NExS encounters an unfamiliar cell
format while importing a file, it assigns the default
cell format and default number of decimal places.
- Some spreadsheets use blank cells to hold a format for
empty cells, whereas NExS uses the Format Range
function for this task. When importing WKS/WK1 files,
NExS ignores blank cells.
To load an existing WKS or WK1 Spreadsheet:
- Select Open... from the File menu and display its
submenu.
- Click the File Format option button and select WKS or
WK1.
- 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.
- 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.
- 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:
- the Import/Cells operation, which imports data that
has been stored in an intermediate file by a prior
Export/Cells operation. This operation does not
require that two spreadsheets be active.
- using the Paste operation, which transfers data
between two active spreadsheets.
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: 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