Adding border to table

18 views (last 30 days)
Abbey Kirkman
Abbey Kirkman on 25 Feb 2021
Answered: VBBV on 11 Sep 2021
Hi how would i go about adding a simple solid border to the table produced frim the following code below?
[filename1,pathname1]=uigetfile('*.xlsx','Pick your Data1 file');
if filename1~=0
data_1=readmatrix(fullfile(pathname1,filename1),'Range',17);
data1=data_1(:,4:37)
h={' Speed' 'Torque' 'TORQUE.ECE' 'POWER' 'ECE_power' 'BMEP' 'Correction_factor' 'Coolant_Temperature_Out_of_Engine' 'Coolant_Temperature_Into_Engine' 'Coolant_Pressure' 'Fuel_Pressure' 'Fuel_Temperature' 'Specific_Fuel_Consumption' 'Inlet_Air_Temperature' 'Humidity' 'Barometric_Pressure' 'Test_Cell_Temperature' 'Exhaust_Temperature_in_CAT' 'Exhaust_Temperature' 'Lambda' 'Exhaust_Pressure' 'Inlet_Manifold_Pressure' 'Blowby' 'Pedal_Position' 'IgnRetCyl1' 'IgnRetCyl2' 'IgnRetCyl3' 'IgnRetCyl4' 'ECU_Pedal_Position' 'Ignition_Timing' 'ThrottleAngle' 'Coolant_Temperature_ECU' 'Oil_Pressure_Head' 'Sump_Oil_Temperature'};
DATA1=[h;num2cell(data1)]
else
data1=0;
end
%%Loading data2 data
[filename2,pathname2]=uigetfile('*.xlsx','Pick your Data 2 file');
if filename2~=0
data_2=readmatrix(fullfile(pathname2,filename2),'Range',17);
data2=data_2(:,4:37)
h={' Speed' 'Torque' 'TORQUE.ECE' 'POWER' 'ECE_power' 'BMEP' 'Correction_factor' 'Coolant_Temperature_Out_of_Engine' 'Coolant_Temperature_Into_Engine' 'Coolant_Pressure' 'Fuel_Pressure' 'Fuel_Temperature' 'Specific_Fuel_Consumption' 'Inlet_Air_Temperature' 'Humidity' 'Barometric_Pressure' 'Test_Cell_Temperature' 'Exhaust_Temperature_in_CAT' 'Exhaust_Temperature' 'Lambda' 'Exhaust_Pressure' 'Inlet_Manifold_Pressure' 'Blowby' 'Pedal_Position' 'IgnRetCyl1' 'IgnRetCyl2' 'IgnRetCyl3' 'IgnRetCyl4' 'ECU_Pedal_Position' 'Ignition_Timing' 'ThrottleAngle' 'Coolant_Temperature_ECU' 'Oil_Pressure_Head' 'Sump_Oil_Temperature' };
DATA2=[h;num2cell(data2)]
else
data2=0;
end
%%Loading data3 data
[filename3,pathname3]=uigetfile('*.xlsx','Pick your data 3 file');
if filename3~=0
data_3=readmatrix(fullfile(pathname3,filename3),'Range',17);
data3=data_3(:,4:37)
h={' Speed' 'Torque' 'TORQUE.ECE' 'POWER' 'ECE_power' 'BMEP' 'Correction_factor' 'Coolant_Temperature_Out_of_Engine' 'Coolant_Temperature_Into_Engine' 'Coolant_Pressure' 'Fuel_Pressure' 'Fuel_Temperature' 'Specific_Fuel_Consumption' 'Inlet_Air_Temperature' 'Humidity' 'Barometric_Pressure' 'Test_Cell_Temperature' 'Exhaust_Temperature_in_CAT' 'Exhaust_Temperature' 'Lambda' 'Exhaust_Pressure' 'Inlet_Manifold_Pressure' 'Blowby' 'Pedal_Position' 'IgnRetCyl1' 'IgnRetCyl2' 'IgnRetCyl3' 'IgnRetCyl4' 'ECU_Pedal_Position' 'Ignition_Timing' 'ThrottleAngle' 'Coolant_Temperature_ECU' 'Oil_Pressure_Head' 'Sump_Oil_Temperature' };
DATA3=[h;num2cell(data3)]
else
data3=0;
end
%%Loading data 4 data
[filename4,pathname4]=uigetfile('*.xlsx','Pick your Data 4 file');
if filename4~=0
data_4=readmatrix(fullfile(pathname4,filename4),'Range',17);
data4=data_4(:,4:37)
h={' Speed' 'Torque' 'TORQUE.ECE' 'POWER' 'ECE_power' 'BMEP' 'Correction_factor' 'Coolant_Temperature_Out_of_Engine' 'Coolant_Temperature_Into_Engine' 'Coolant_Pressure' 'Fuel_Pressure' 'Fuel_Temperature' 'Specific_Fuel_Consumption' 'Inlet_Air_Temperature' 'Humidity' 'Barometric_Pressure' 'Test_Cell_Temperature' 'Exhaust_Temperature_in_CAT' 'Exhaust_Temperature' 'Lambda' 'Exhaust_Pressure' 'Inlet_Manifold_Pressure' 'Blowby' 'Pedal_Position' 'IgnRetCyl1' 'IgnRetCyl2' 'IgnRetCyl3' 'IgnRetCyl4' 'ECU_Pedal_Position' 'Ignition_Timing' 'ThrottleAngle' 'Coolant_Temperature_ECU' 'Oil_Pressure_Head' 'Sump_Oil_Temperature' };
DATA4=[h;num2cell(data4)]
else
data4=0;
end
%%Loading data 5 data
[filename5,pathname5]=uigetfile('*.xlsx','Pick your Data 5 file');
if filename5~=0
data_5=readmatrix(fullfile(pathname5,filename5),'Range',17);
data5=data_5(:,4:37)
h={' Speed' 'Torque' 'TORQUE.ECE' 'POWER' 'ECE_power' 'BMEP' 'Correction_factor' 'Coolant_Temperature_Out_of_Engine' 'Coolant_Temperature_Into_Engine' 'Coolant_Pressure' 'Fuel_Pressure' 'Fuel_Temperature' 'Specific_Fuel_Consumption' 'Inlet_Air_Temperature' 'Humidity' 'Barometric_Pressure' 'Test_Cell_Temperature' 'Exhaust_Temperature_in_CAT' 'Exhaust_Temperature' 'Lambda' 'Exhaust_Pressure' 'Inlet_Manifold_Pressure' 'Blowby' 'Pedal_Position' 'IgnRetCyl1' 'IgnRetCyl2' 'IgnRetCyl3' 'IgnRetCyl4' 'ECU_Pedal_Position' 'Ignition_Timing' 'ThrottleAngle' 'Coolant_Temperature_ECU' 'Oil_Pressure_Head' 'Sump_Oil_Temperature' };
DATA5=[h;num2cell(data5)]
else
data5=0;
end
if data1~=0
max3_1=max(data1(:,3));
max5_1=max(data1(:,5));
else
max3_1=0;
max5_1=0;
end
if data2~=0
max3_2=max(data2(:,3));
max5_2=max(data2(:,5));
else
max3_2=0;
max5_2=0;
end
if data3~=0
max3_3=max(data3(:,3));
max5_3=max(data3(:,5));
else
max3_3=0;
max5_3=0;
end
if data4~=0
max3_4=max(data4(:,3));
max5_4=max(data4(:,5));
else
max3_4=0;
max5_4=0;
end
if data5~=0
max3_5=max(data5(:,3));
max5_5=max(data5(:,5));
else
max3_5=0;
max5_5=0;
end
Max_values=[max3_1,max3_2,max3_3,max3_4,max3_5]'
Max_values1=[max5_1,max5_2,max5_3,max5_4,max5_5]'
max_values = string(Max_values);
max_values1 = string(Max_values1);
for i = 1:numel(max_values)
max_values(i) = sprintf('%.1f',max_values(i));
max_values1(i) = sprintf('%.1f',max_values1(i));
end
Table =table({filename1;filename2;filename3;filename4;filename5},max_values,max_values1)
Table.Properties.VariableNames = {'Filenames' ,'Max ECE Torque','Max ECE Power'}
  1 Comment
Abbey Kirkman
Abbey Kirkman on 1 Mar 2021
any help would be appreciated

Sign in to comment.

Answers (2)

Anshika Chaurasia
Anshika Chaurasia on 2 Mar 2021
Hi Abbey,
I would suggest you to use uitable that will create table user interface component.
The code provided by you generate Table. You can use following code snippet to create a table UI component:
fig = uifigure;
uit = uitable(fig,'Data',Table);
Hope it helps!

Tags

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!