MATLAB: How to automatically run a matlab script on data in a seperate file on your computer

automatically rundataexcelimporting excel dataMATLABtxtxlsread

Hello,

I have data (.txt file) incoming on an sd-card inserted in my computer. At the moment I open the .txt file on excel and save it as a .xlsx file in my Matlab folder and write an xlsread() line at the top of my script. Is there any way to shorten this process or even make it happen fully automatically?

Thanks

Best Answer

Data from the .txt file can be directly read in MATLAB without converting it to .xlsx file, depending on the kind of data it contains :

If the your data is in the form of tables, you could use readtable, to read the text-file directly,

If the .txt file contains data in csv format or is delimeted by some character, you could use csvread or dlmread. Take a look at these examples in the documentation.

Related Solutions

MATLAB: Seperating strings and numbers using xlsread

Loops are allowed

>> [ str, num ] = cssm0();
>> whos str num
  Name       Size            Bytes  Class     Attributes
  num       33x3               792  double              
  str       33x3             12928  cell

where

function [ str, num ] = cssm0()
    [~,txt] = xlsread('test.xls');
    len = size(txt,1);
    str = cell( len, 3 );
    num = nan( len, 3 );
    for jj = 1 : len
        for ii = 1 : 3
            if not( isempty( txt{jj,ii} ) )
                cac = textscan( txt{jj,ii}, '%s%f', 'Whitespace',')', 'Delimiter','(' ) ;
                str{jj,ii} = strtrim(cac{1}{1});
                num(jj,ii) = cac{2};
            else
                str{jj,ii} = '';
                num(jj,ii) = nan;
            end
        end
    end
end

MATLAB: How to Convert xls file to txt file in matlab

Read ExcelFile.xls data and write that data to text file

Data = readtable('ExcelFile.xls');
writetable(Data, 'textfile.txt');

Best Answer

Related Solutions

MATLAB: Seperating strings and numbers using xlsread

MATLAB: How to Convert xls file to txt file in matlab

Related Question