Hi..., Currently i am trying to read an excel files with two different ending . dvd & .sod (From SCADA system). i am using the [Values] = xlsread(File_to_Open) to do so. my question is: In the excel file i have the values so written (Example: 21,1) with comma not point (I am using a German Windows system) and when i am importing those data to matlab i am getting something like 37, I am not sure why!! Can you help me with this problem of importing when using the xlsread() function?
it seems i had the solution all along. I took the third output of xlsread and then change it from cell to matrix using cell2mat and i got me wished output thx for the help anyway :)
I don't recognize these extensions. I assume they are text.
Here are two files, which replace comma by dot. Pick one. Please, make copies of your files before you try these functions.
function fread_( strInFileSpec, strOutFileSpec )
fid = fopen( strInFileSpec, 'r' );
str = fread( fid, inf, '*char' );
fclose( fid );str = strrep( str', '.', ',' );
fid = fopen( strOutFileSpec, 'w' );
fwrite( fid, str, 'char' );
fclose( fid );end
function memmap_( strInFileSpec )
file = memmapfile( strInFileSpec, 'writable', true );
comma = uint8(',');
point = uint8('.');
file.Data(( file.Data==comma)' ) = point;
... delete(file)end
unfortunately that did not work. i am becoming an empty file afterword. Any other suggestion would be appreciated :)
Neither .dvd nor .sod is included in this list: File formats that are supported in Excel
2 Comments
Direct link to this comment:
http://www.mathworks.com/matlabcentral/answers/83610#comment_162339
Any suggestion will be welcomed :)
Direct link to this comment:
http://www.mathworks.com/matlabcentral/answers/83610#comment_162345
I've enabled the decimal dot on my German system to avoid such troubles.