Difference between revisions of "Importing Data"

From Eigenvector Research Documentation Wiki
Jump to navigation Jump to search
imported>Jeremy
imported>Jeremy
(High-Level File and Source Readers)
Line 5: Line 5:
 
:[[autoimport]] - Automatically reads specified file. Handles all standard filetypes.
 
:[[autoimport]] - Automatically reads specified file. Handles all standard filetypes.
 
:[[asfreadr]] - Reads Hamilton Sundstrand ASF files.
 
:[[asfreadr]] - Reads Hamilton Sundstrand ASF files.
 +
:[[experimentreadr]] - Read an Experiment file and import corresponding files.
 
:[[getpidata]] - Uses the current PI connection to construct a DSO from 'taglist'.
 
:[[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.
 
:[[mtfreadr]] - Read AdventaCT Multi-Trace Format (MTF) files.
 
:[[parsexml]] - Convert XML file to a MATLAB structure.
 
:[[parsexml]] - Convert XML file to a MATLAB structure.
Line 15: Line 19:
 
:[[xlsreadr]] - Reads .XLS files from MS Excel and other spreadsheets.
 
:[[xlsreadr]] - Reads .XLS files from MS Excel and other spreadsheets.
 
:[[xyreadr]]  - Reads one or more ASCII XY or XY... files into a DataSet object.
 
:[[xyreadr]]  - Reads one or more ASCII XY or XY... files into a DataSet object.
+
 
 
===Other Reading and Writing Utilities===  
 
===Other Reading and Writing Utilities===  
 
:[[lddlgpls]] - Dialog to load variable from workspace or MAT file.
 
:[[lddlgpls]] - Dialog to load variable from workspace or MAT file.

Revision as of 14:26, 10 July 2009

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.
asfreadr - Reads Hamilton Sundstrand 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.
parsexml - Convert XML file to a MATLAB structure.
querydb - Executes a query on a database defined by connection string.
spcreadr - Reads a Galactic SPC file.
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

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.
writecsv - Export a DataSet object to a comma-separated values (CSV) file.

(Sub topic of Import_View_Data)