Excel Trace Format: Difference between revisions
No edit summary |
No edit summary |
||
| Line 4: | Line 4: | ||
To load MS Excel trace files select Load Data → Excel data format → x-data, or y-data from the Load Data menu bar. <br> <br> | To load MS Excel trace files select Load Data → Excel data format → x-data, or y-data from the Load Data menu bar. <br> <br> | ||
== Data Import & File Formats == | |||
* [[Matlab_Imaging_Format|Import data in the CytoSpec imaging format (CytoSpec/Matlab)]] | |||
* [[Matlab_Trace_Format|Import data in the trace format (Matlab)]] | |||
* [[Format_of_a_2D-COS_Result_File|Format of a 2D-COS result file (Matlab)]] | |||
Revision as of 17:03, 2 April 2023
With version 1.04 of the mat2dcorr toolbox, besides hyperspectral imaging data in the CytoSpec data format and Matlab trace files, spectra data from MS Excel spreadsheets can now be loaded. MS Excel spreadsheets contain spectra series in a 2D data format where the spectra must be arranged as columns and the wavenumber vectors as rows. It is also important that the first row contains the vector with the data entries of the perturbing variable (temperature, pressure, etc.). The first column should contain the y-vector (wavenumber, frequencies, Raman shift vector) starting from row no. 2.
In order to use own data by means of the MS Excel import function, it is recommended to analyze the structure of the example file and to replace the spectral data contained therein with own data.
To load MS Excel trace files select Load Data → Excel data format → x-data, or y-data from the Load Data menu bar.