Importing Data: Difference between revisions
Jump to navigation
Jump to search
imported>Jeremy No edit summary |
imported>Jeremy No edit summary |
||
| Line 1: | Line 1: | ||
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 [[editds|DataSet Editor]]. | 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 [[editds|DataSet Editor]]. | ||
===High-Level File and Source Readers=== | |||
:[[areadr]] - Reads ascii data and strips header. | :[[areadr]] - Reads ascii data and strips header. | ||
:[[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. | ||
:[[getpidata]] - Uses the current PI connection to construct a DSO from 'taglist'. | |||
:[[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. | ||
:[[querydb]] - Executes a query on a database defined by connection string. | |||
:[[spcreadr]] - Reads a Galactic SPC file. | :[[spcreadr]] - Reads a Galactic SPC file. | ||
:[[xclgetdata]] - Extracts matrix from an Excel spreadsheet. | :[[xclgetdata]] - Extracts matrix from an Excel spreadsheet. | ||
| Line 14: | Line 16: | ||
:[[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=== | |||
:[[lddlgpls]] - Dialog to load variable from workspace or MAT file. | :[[lddlgpls]] - Dialog to load variable from workspace or MAT file. | ||
:[[svdlgpls]] - Dialog to save variable to workspace or MAT file. | :[[svdlgpls]] - Dialog to save variable to workspace or MAT file. | ||
:[[builddbstr]] - Builds a database connection string. | :[[builddbstr]] - Builds a database connection string. | ||
:[[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]]) | (Sub topic of [[Import_View_Data|Import_View_Data]]) | ||
Revision as of 18:05, 3 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 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.
- getpidata - Uses the current PI connection to construct a DSO from 'taglist'.
- 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)