Importing Data: Difference between revisions
Jump to navigation
Jump to search
imported>Donal No edit summary |
imported>Donal |
||
| Line 15: | Line 15: | ||
:[[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. | :[[querydb]] - Executes a query on a database defined by connection string. | ||
:[[pereadr]] - Read | :[[pereadr]] - Read PerkinElmer files. | ||
:[[spcreadr]] - Reads a Galactic SPC file. | :[[spcreadr]] - Reads a Galactic SPC file. | ||
:[[snabsreadr]] - Reads Stellarnet ABS XY files. | :[[snabsreadr]] - Reads Stellarnet ABS XY files. | ||
Revision as of 08:16, 16 April 2013
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.
- asdreadr - Imports data from Analytical Spectral Devices (ASD) Indico (Versions 6 and 7) data files.
- asfreadr - Reads AIT 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.
- opusreadr - Read Bruker OPUS files.
- parsexml - Convert XML file to a MATLAB structure.
- querydb - Executes a query on a database defined by connection string.
- pereadr - Read PerkinElmer files.
- spcreadr - Reads a Galactic SPC file.
- snabsreadr - Reads Stellarnet ABS XY files.
- 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
- autoexport - Exports a DataSet object to a file of the specified format.
- 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.
- autoexport - Exports a DataSet object to a file of the specified format.
- writecsv - Export a DataSet object to a comma-separated values (CSV) file.
- writespc - Export a DataSet object to a Galactic SPC file.
(Sub topic of Import_View_Data)