MATLAB: Reading an Excel File (Excelfinlename.dvd) with decimal comma instaed of decimal point

decimal commadecimal pointdecimal radixexcelMATLABradix pointxlsread

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?

Best Answer

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 :)

Related Solutions

MATLAB: How to add a new line in the middle of a text file

There is no "smart" way. One has to read the existing file and write the new. If the file isn't too large this could be a starting point.

    fid = fopen( old_filespec );
    cac = textscan( fid, '%s', 'Delimiter','\n', 'CollectOutput',true );
    fclose( fid )
    fid = fopen( new_filespec, 'w' );
    for jj = 1 : insert_here
        fprintf( fid, '%s\n', cac{jj} );
    end
    fprintf( fid, '%s\n', new_line );
    for jj = insert_here+1 : length(cac)
        fprintf( fid, '%s\n', cac{jj} );
    end
    fclose( fid );

MATLAB: Import txt file with header and convert to excel

datatable = readtable(name, 'headerlines', 1, 'readvariablenames', false, 'delimiter', '\t');
[filepath, filebase, ext] = fileparts(name);
newname = fullfile(filepath, [filebase, '.xlsx']);
writetable(datatable, newname, 'writevariablename', false);

Best Answer

Related Solutions

MATLAB: How to add a new line in the middle of a text file

MATLAB: Import txt file with header and convert to excel

Related Question