Importing Data

From Eigenvector Research Documentation Wiki
Revision as of 14:41, 7 November 2013 by imported>Scott (→‎Other Reading and Writing Utilities)
Jump to navigation Jump to search
The printable version is no longer supported and may have rendering errors. Please update your browser bookmarks and please use the default browser print function instead.

In addition to the Matlab functions to read various file types, PLS_Toolbox provides various functions for reading common data formats into DataSet Objects. Also see the DataSet Editor.

High-Level File and Source Readers

areadr - Reads ascii data and strips header.
autoimport - Automatically reads specified file. Handles all standard filetypes.
asdreadr - Imports data from Analytical Spectral Devices (ASD) Indico (Versions 6 and 7) data files.
asfreadr - Reads AIT ASF files.
experimentreadr - Read an Experiment file and import corresponding files.
getpidata - Uses the current PI connection to construct a DSO from 'taglist'.
hjyreadr - Reads HORIBA Jobin Yvon files.
hrmethodreadr - Converts HoloReact method into preprocessing structure.
jcampreadr - Reads a JCAMP file into a DataSet object.
mtfreadr - Read AdventaCT Multi-Trace Format (MTF) files.
opusreadr - Read Bruker OPUS files.
parsexml - Convert XML file to a MATLAB structure.
querydb - Executes a query on a database defined by connection string.
pereadr - Read PerkinElmer files.
spcreadr - Reads a Galactic SPC file.
snabsreadr - Reads Stellarnet ABS XY files.
xclgetdata - Extracts matrix from an Excel spreadsheet.
xclputdata - Write matrix to an Excel spreadsheet.
xclreadr - Reads an ASCII or .XLS file in as a DataSet Object.
xlsreadr - Reads .XLS files from MS Excel and other spreadsheets.
xyreadr - Reads one or more ASCII XY or XY... files into a DataSet object.

Other Reading and Writing Utilities

autoexport - Exports a DataSet object to a file of the specified format.
importtool - GUI for designating column/row data types in incoming data.
lddlgpls - Dialog to load variable from workspace or MAT file.
svdlgpls - Dialog to save variable to workspace or MAT file.
builddbstr - Builds a database connection string.
parsemixed - Parse numerical and text data into a DataSet Object.
autoexport - Exports a DataSet object to a file of the specified format.
writecsv - Export a DataSet object to a comma-separated values (CSV) file.
writespc - Export a DataSet object to a Galactic SPC file.

(Sub topic of Import_View_Data)