Importing Data: Difference between revisions
Jump to navigation
Jump to search
imported>Scott |
imported>Donal |
||
Line 15: | Line 15: | ||
:[[querydb]] - Executes a query on a database defined by connection string. | :[[querydb]] - Executes a query on a database defined by connection string. | ||
:[[spcreadr]] - Reads a Galactic SPC file. | :[[spcreadr]] - Reads a Galactic SPC file. | ||
:[[snabsreadr]] - Reads Stellarnet ABS XY files. | |||
:[[xclgetdata]] - Extracts matrix from an Excel spreadsheet. | :[[xclgetdata]] - Extracts matrix from an Excel spreadsheet. | ||
:[[xclputdata]] - Write matrix to an Excel spreadsheet. | :[[xclputdata]] - Write matrix to an Excel spreadsheet. |
Revision as of 15:26, 8 March 2011
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 Hamilton Sundstrand 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.
- 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.
- 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
- 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)