Mport data into, Xcel, 4 import data into excel – ChemoMetec NC-100 User Manual
Page 46: 4 import data into excel)
6 Utilities tab
36
C:\Nucloeview\Export data
The file names of the viability reports are constructed in the same manner as the result
lists. The first part is a prefix, Viability list -, the middle part is the date of the session from
which the viability report is derived, YYMMDD. The last part is “XLS” to indicate that the
file can be imported into e.g. MS Excel. The exported viability reports are tabulator -
separated txt files.
An example of a filename of an exported viability report is:
Viability list – 021030 XLS.txt
The message box, which shows the location and filename of the viability reports, is shown
above in figure 29.
6.4
Import data into Excel
To import the exported files into Excel follow the directions below. The directions are
identical for result lists and viability reports.
Before importing the first files make sure that the decimal symbol is set to
“.” (period). If the decimal symbol is “,” (comma) then Excel cannot use the
imported data for calculations. See chapter 6.4.1 Set decimal symbol for
directions of how to change the decimal symbol.
1. To import a report first open Excel and activate the “Open…” function e.g. through
the file menu. The dialogue shown in figure 31 appears.