MATLAB: Working in international team causes problems reading csv files

MATLABxlsread

Hi We are an international team of Matlab users working on a project. Every user has its own notebook, some with European, some with American local settings. Reading csv-files using xlsread is causing problems, as the formatting of figures is different. Is there another fast way of reading csv-files with numbers and strings without running in this problem? The solution as proposed in this forum of adjusting the region settings is a no-go-option. Thanks Renger

Best Answer

As seen in the folwoing link 'xlsread' only supports 7-bit ASCII in xlsx files https://www.mathworks.com/help/matlab/ref/xlsread.html#btjfnq9-7 and hence the discrepancy! As a work around you can use the 'textscan' function in MATLAB- https://www.mathworks.com/help/matlab/ref/textscan.html?searchHighlight=textscan&s_tid=doc_srchtitle

I believe this should solve the issue. Let me know if you face any issues.

Related Solutions

MATLAB: Saving data in .dat files

There is no specific format for a .dat file. You can use writematrix(): https://www.mathworks.com/help/releases/R2020a/matlab/ref/writematrix.html or dlmwrite(): https://www.mathworks.com/help/releases/R2020a/matlab/ref/dlmwrite.html in older versions.

For example,

writematrix(sr, 'filename.dat') % or dlmwrite('filename.dat', sr);

MATLAB: How to read and work with a csv file (.csv)

Or, more easy way is to use Import tool, especially the data file contains not only numbers like your case.

Import tool:

https://www.mathworks.com/help/matlab/ref/importtool-app.html

Best Answer

Related Solutions

MATLAB: Saving data in .dat files

MATLAB: How to read and work with a csv file (.csv)

Related Question