Adding border to table

16 次查看(过去 30 天)
Abbey Kirkman
Abbey Kirkman 2021-2-25
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 个)

Anshika Chaurasia
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!

类别

Help CenterFile Exchange 中查找有关 App Building 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by