MATLAB: How can i verify time step of excel files

importing excel dataMATLAB and Simulink Student Suitetime step

Hello,

I have several excel files (.xlsx) with time data how can i check that the time step is th same in all files and that it does not lack ?

Best Answer

After you load the file in to matlab workspace, name the variable for time. Then you can use diff() function to find the difference in consecutive values.

Assume your time variable is t, then if you do

plot(diff(t))

then, the plot will show you the time steps.

Related Solutions

MATLAB: Problem on acessing excel by activeX command in Matlab

Have you tried the below link: http://www.mathworks.com/matlabcentral/answers/2603-add-a-new-excel-sheet-from-matlab

MATLAB: Importing Microsoft Excel data to MATLAB as a single variable from multiple spreadsheets that contains various data ranges

Hello Peter, Try the below solution :

station = [];
 SheetName = {'CTD 2014'; 'CTD 2015'; 'CTD 2016'; 'CTD 2017'; 'CTD 2018'; 'CTD 2019'};
FileName = 'SBE 19plus CTD Profiling Database.xlsx';
for sheet_idx = 1:length(SheetName)
    opts = detectImportOptions(FileName,'Sheet',SheetName{sheet_idx});
    [station_raw] = readtable(FileName,opts);
    station_raw = station_raw.Station;
    station_raw(strcmp(station_raw,'-')) = [];
    station_raw(strcmp(station_raw,'?')) = [];
    station_raw = station_raw(~cellfun(@isempty, station_raw));
    station = [station; station_raw];
end

I hope this helps...!

Best Answer

Related Solutions

MATLAB: Problem on acessing excel by activeX command in Matlab

MATLAB: Importing Microsoft Excel data to MATLAB as a single variable from multiple spreadsheets that contains various data ranges

Related Question