Importing Data: Difference between revisions

From Eigenvector Research Documentation Wiki
Jump to navigation Jump to search
imported>Jeremy
(Importing text file)
 
imported>Jeremy
(Importing text file)
Line 1: Line 1:
===Importing Data===
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 <a desc="matlab:editds">DataSet Editor</a>.
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 <a desc="matlab:editds">DataSet Editor</a>.
   
   
Line 22: Line 21:
:[[parsemixed]] - Parse numerical and text data into a DataSet Object.
:[[parsemixed]] - Parse numerical and text data into a DataSet Object.
:[[writecsv]] - Export a DataSet object to a comma-separated values (CSV) file.
:[[writecsv]] - Export a DataSet object to a comma-separated values (CSV) file.
(Sub topic of [[Import_View_Data|Import_View_Data]])

Revision as of 16:40, 2 September 2008

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 <a desc="matlab:editds">DataSet Editor</a>.


areadr - Reads ascii data and strips header.
autoimport - Automatically reads specified file. Handles all standard filetypes.
mtfreadr - Read AdventaCT Multi-Trace Format (MTF) files.
parsexml - Convert XML file to a MATLAB structure.
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.


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.
querydb - Executes a query on a database defined by connection string.
getpidata - Uses the current PI connection to construct a DSO from 'taglist'.
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)