Importing Data: Difference between revisions
Jump to navigation
Jump to search
imported>Jeremy (Importing text file) |
|||
(28 intermediate revisions by 6 users not shown) | |||
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 | |||
===High-Level File and Source Readers=== | |||
:[[abbspectrumreadr]] - Imports ABB spectrum file | |||
:[[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. | ||
:[[asdreadr]] - Imports data from Analytical Spectral Devices (ASD) Indico (Versions 6 and 7) data files. | |||
:[[asfreadr]] - Reads AIT ASF files. | |||
:[[brukerxrpdreadr]] - Reads Bruker XRPD RAW files into a DataSet object. | |||
:[[cytospecreadr]] - Reads CytoSpec .cyt files into a Dataset object. | |||
:[[envireadr]] - Reads ENVI image files. | |||
:[[experimentreadr]] - Read an Experiment file and import corresponding files. | |||
:[[getpidata]] - Uses the current PI connection to construct a DSO from 'taglist'. | |||
:[[hitachieemreadr]] - Reads Hitachi EEM files with Rayleigh removal. | |||
:[[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. | :[[mtfreadr]] - Read AdventaCT Multi-Trace Format (MTF) files. | ||
:[[netcdfreadr]] - Reads in netCDF files and outputs a DataSet and or structure. | |||
:[[omnicreadr]] - Reads OMNICix HDF5 image files. | |||
:[[opusreadr]] - Read Bruker OPUS files. | |||
:[[parsexml]] - Convert XML file to a MATLAB structure. | :[[parsexml]] - Convert XML file to a MATLAB structure. | ||
:[[pdf2text]] - Read PDF document into a string array. | |||
:[[pltreadr]] - Imports a Vision AIr .PLT model file as an EVRI model object. | |||
:[[querydb]] - Executes a query on a database defined by connection string. | |||
:[[pereadr]] - Read PerkinElmer files. | |||
:[[rdareadr]] - Read Siemens RDA files. | |||
:[[shimadzueemreadr]] - Reads Shimadzu EEM Files (TXT). | |||
:[[spcreadr]] - Reads a Galactic SPC file. | :[[spcreadr]] - Reads a Galactic SPC file. | ||
:[[spereadr]] - Reads a Princeton Instruments SPE file. | |||
:[[snabsreadr]] - Reads Stellarnet ABS XY files. | |||
:[[spgreadr]] - Reads Thermo Fischer SPG files. | |||
:[[visionairxmlreadr]] - Reads Vision Air XML Data Files (XML). | |||
:[[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. | ||
Line 13: | Line 37: | ||
:[[xlsreadr]] - Reads .XLS files from MS Excel and other spreadsheets. | :[[xlsreadr]] - Reads .XLS files from MS Excel and other spreadsheets. | ||
:[[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=== | |||
:[[autoexport]] - Exports a DataSet object to a file of the specified format. | |||
:[[importtool]] - GUI for designating column/row data types in incoming data. | |||
:[[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. | ||
:[[pdf2text]] - Read PDF document into a string array. | |||
:[[table2dataset]] - Convert Matlab Table Array to DatasetObject. | |||
:[[writecsv]] - Export a DataSet object to a comma-separated values (CSV) file. | :[[writecsv]] - Export a DataSet object to a comma-separated values (CSV) file. | ||
:[[writespc]] - Export a DataSet object to a Galactic SPC file. | |||
:[[writeplt]] - Exports an EVRI model object to a Vision AIr .PLT model file. | |||
(Sub topic of [[Import_View_Data|Import_View_Data]]) |
Latest revision as of 10:31, 25 September 2024
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
- abbspectrumreadr - Imports ABB spectrum file
- 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.
- brukerxrpdreadr - Reads Bruker XRPD RAW files into a DataSet object.
- cytospecreadr - Reads CytoSpec .cyt files into a Dataset object.
- envireadr - Reads ENVI image files.
- experimentreadr - Read an Experiment file and import corresponding files.
- getpidata - Uses the current PI connection to construct a DSO from 'taglist'.
- hitachieemreadr - Reads Hitachi EEM files with Rayleigh removal.
- 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.
- netcdfreadr - Reads in netCDF files and outputs a DataSet and or structure.
- omnicreadr - Reads OMNICix HDF5 image files.
- opusreadr - Read Bruker OPUS files.
- parsexml - Convert XML file to a MATLAB structure.
- pdf2text - Read PDF document into a string array.
- pltreadr - Imports a Vision AIr .PLT model file as an EVRI model object.
- querydb - Executes a query on a database defined by connection string.
- pereadr - Read PerkinElmer files.
- rdareadr - Read Siemens RDA files.
- shimadzueemreadr - Reads Shimadzu EEM Files (TXT).
- spcreadr - Reads a Galactic SPC file.
- spereadr - Reads a Princeton Instruments SPE file.
- snabsreadr - Reads Stellarnet ABS XY files.
- spgreadr - Reads Thermo Fischer SPG files.
- visionairxmlreadr - Reads Vision Air XML Data Files (XML).
- 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.
- importtool - GUI for designating column/row data types in incoming data.
- 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.
- pdf2text - Read PDF document into a string array.
- table2dataset - Convert Matlab Table Array to DatasetObject.
- writecsv - Export a DataSet object to a comma-separated values (CSV) file.
- writespc - Export a DataSet object to a Galactic SPC file.
- writeplt - Exports an EVRI model object to a Vision AIr .PLT model file.
(Sub topic of Import_View_Data)