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

areadr - Reads ascii data and strips header.   [demo]
querydb - Executes a query on a database defined by connection string.
mtfreadr - Read AdventaCT Multi-Trace Format (MTF) files.
spcreadr - Reads a Galactic SPC file.   [demo]
xclgetdata - Extracts matrix from an Excel spreadsheet.   [demo]
xclputdata - Write matrix to an Excel spreadsheet.   [demo]
xclreadr - Reads an ASCII or .XLS file in as a DataSet Object.   [demo]
xlsreadr - Reads .XLS files from MS Excel and other spreadsheets.

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.
parsemixed - Parse numerical and text data into a DataSet Object.
writecsv - Export a DataSet object to a comma-separated values (CSV) file.