MATLAB: How to make excel file to matlab

excelMATLAB

name age grade

Fred 19 78

Joe 22 83

Sally 98 99

Charlie 21 56

If the following name and age scores are made in Excel file and run on the mat, the same form as Excel is executed on the matlab.

How can I change the order of my grades when I execute the above file?

High scores are at the top, low scores are at the bottom.

Best Answer

T = readtable('YourFile.xlsx');
sortrows(T, 3, 'descending')

Related Solutions

MATLAB: Conditionals and character arrays to assign grade based on score

score = 75;
grade = assignGrade(score);
fprintf('The grade for score %d was %s\n', score, grade);
The grade for score 75 was undefined
function grade = assignGrade(score)
%Enter the commands for your function here.  
    if (score >= 90) && (score <= 100) 
        grade = 'A';
    else
        grade = 'undefined';
    end
end

MATLAB: Sorting a table with strings and numbers

Use readtable() to read in the workbook

T = readtable(fullXlsFileName);

Then use sortrows() to sort the table based on the column with strings in it. Let's say that the column with strings is the first column, like in the example below. Then you'd just do:

LastName = {'Smith';'Johnson';'Williams';'Jones';'Brown'};
Age = [38;43;38;40;49];
Height = [71;69;64;67;64];
Weight = [176;163;131;133;119];
BloodPressure = [124 93; 109 77; 125 83; 117 75; 122 80];
% Create a table, T, as a container for the workspace variables.
T = table(LastName, Age,Height,Weight,BloodPressure)
% Sort rows by last name.
sortedTable = sortrows(T, 1)

In the command window, you'll see the unsorted table first, followed by the sorted table:

T = 
     LastName     Age    Height    Weight    BloodPressure
    __________    ___    ______    ______    _____________
    'Smith'       38     71        176       124     93   
    'Johnson'     43     69        163       109     77   
    'Williams'    38     64        131       125     83   
    'Jones'       40     67        133       117     75   
    'Brown'       49     64        119       122     80   
sortedTable = 
     LastName     Age    Height    Weight    BloodPressure
    __________    ___    ______    ______    _____________
    'Brown'       49     64        119       122     80   
    'Johnson'     43     69        163       109     77   
    'Jones'       40     67        133       117     75   
    'Smith'       38     71        176       124     93   
    'Williams'    38     64        131       125     83

Best Answer

Related Solutions

MATLAB: Conditionals and character arrays to assign grade based on score

MATLAB: Sorting a table with strings and numbers

Related Question