Reading an Excel File (Excelfinlename.dvd) with decimal comma instaed of decimal point?
8 visualizaciones (últimos 30 días)
Mostrar comentarios más antiguos
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?
2 comentarios
Respuesta aceptada
Más respuestas (1)
per isakson
el 31 de Jul. de 2013
Editada: per isakson
el 1 de Ag. de 2013
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
Ver también
Categorías
Más información sobre Text Files en Help Center y File Exchange.
Productos
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!