Adding border to table

14 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!

VBBV
VBBV on 11 Sep 2021

Tags

Community Treasure Hunt

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

Start Hunting!

Translated by