Data Importing Formats

Data can be imported into PLS_Toolbox or Solo from a variety of sources using File>Import Data (or similar) in the Workspace Browser, Analysis, and DataSet Editor windows. Sources include:

• Workspace/MAT file - see Importing .mat Files
• Delimited Text File (CSV,TXT) - see Text Import Settings
• XY... Delimited Text Files (TXT,XY) - see Text Import Settings
• Excel File (XLS,CSV,TXT)
• Experiment File (CSV, TXT, XLS)
• Grams / Thermo Galactic File (SPC)
• Hamilton Sundstrand File (ASF, AIF, BKH, PDF)
• Horiba JY Files (NGS, NGC)
• Analytical Spectral Devices (ASD)
• JCAMP [general] (DX,JDX)
• Extensible Markup Language (XML) - see DataSet XML Format

Additional import methods may be available depending on the specific purchased options and the distributor of your copy of PLS_Toolbox or Solo. See other notes below.

Notes

• Our image processing products MIA_Toolbox and Solo+MIA include additional image-specifc importers. See Constructing_Image_DataSets for more information.

• The Delimited Text File format provides a flexible way to import lots of different text file formats. For details on the format and the options available, see: Text Import Settings

• The Experiment File import method is used to import multiple data files at once along with corresponding reference values. For more information on the Experiment File format and features, see the reference page for experimentreadr.

• PLS_Toolbox users can access the importers through the autoimport command or the file import functions directly.

• In some cases you may have to use the DataSet Editor to add additional information to your dataset. For instance, you may add labels and or axis scales after you've imported the raw data. See Key_GUIs for more information on using the DataSet Editor.

• In cases involving n-way (multidimensional) data you man need to "build up" you dataset. More information about how to do that can be found here.