Importing Data

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>.

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.