View source for Excel Trace Format

[[File:excel-format.jpg|400px|thumb|Screenshot of the Excel spreadsheet ''linescandata.xlsx'']]

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 should 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. <br>

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 ''linescandata.xlsx'' and to replace the spectral data contained therein with own data. <br>

To load MS Excel trace files select Load Data &rarr; Excel data format &rarr; x-data, or y-data from the Load Data menu bar. <br> &nbsp; <br>

== Download test file  ==

Download MS Excel test file ''linescandata.xlsx'': [http://www.peter-lasch.de/2dcorr/linescandata.xlsx https://wiki2dcos.microbe-ms.com/linescandata.xlsx]<br>

== Related links  ==

* [[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)]]