This dialog allows you to select multiple input files containing the data
scanned from microarray slides to be opened into a single combined spreadsheet.
File Type
The format of microarray data files to be opened. GenStat opens the files using
the common text based output formats of these file types. Microarray systems are
constantly updating their file formats and subsequently GenStat may
not always be able to read a file format if it has been updated after the
release of this version of GenStat. The file types
currently supported are:
- Genepix GPR - files in Genepix CSV format
- Imagene - pairs of files in Imagene CSV format (one per channel)
- Spot R - Spot files in binary R format
- TIGR MEV - files in CSV format
- ScanAlyze - files in ScanAlyze format
- QuantArray - files in QuantArray format
- Affymetrix CEL
- Affymetrix CHP
- CSV - General files in CSV format
Note: For the Imagene file format, two lists of files (one
for each dye/channel) are required. The files are be opened in pairs, so
the filenames in the two lists must be in the same order to ensure that the two channels
of each slide are matched together correctly.
Filename
The name of a file to be added to the file name list. Clicking the
button
allows you to browse for the files. Multiple files can be selected from the browse dialog by holding down the Ctrl or Shift keys
when selecting the files. Files do not need to be all in the same directory and can be selected from any folder.
Add
Add the filename in the Filename field into the list of files.
Change
Replace the selected the filename in the list with the value in the Filename field.
Remove
Remove the selected the filename(s) from the list.
Up
Move the selected the filename up once place in the list.
Down
Move the selected the filename down once place in the list.
Open
Open the selected files into a spreadsheet.
If opening Affymetrix CEL files you will get the Read Affymetrix CEL file Options
dialog after clicking OK.
Cancel
Close the menu without further action.
Examples
The following dialog shows the selection of 4 Genepix GPR files to be read into
the same spreadsheet.
Windows does not always return the filenames in the expected order.
Using the Up and Down buttons allows you to sort the filenames into
the order you require. Here they have been sorted into numerical order.
The following dialog shows the selection of 2 pairs of Imagene files to be read into
the same spreadsheet.
See Also