some rows appears as text in excel when it should be numerical.

1 次查看（过去 30 天）

显示更早的评论

isamh 2020-11-7

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/639255-some-rows-appears-as-text-in-excel-when-it-should-be-numerical

关闭： MATLAB Answer Bot 2021-8-20

SteadyState_0443.PNG

在 MATLAB Online 中打开

I calculated some data and imorted that to an xlsx sheet. for some odd reason, some rows show as text while others show as numerical.

code is:

Speed_70 = table(mean_speed70_MPH, mean_power70_MPH, mean_force112_KPH);
STD_70 = table(std_speed70_MPH, std_power70_MPH, std_force112_KPH);
CV_70 = table(CV_speed70_MPH, CV_power70_MPH, CV_force112_KPH);
%%Table
Table11 = [Speed_50_1, Speed_55_1, Speed_60_1, Speed_65_1, Speed_70];
Table12 = [STD_50_1, STD_55_1, STD_60_1, STD_65_1, STD_70];
Table13 = [CV_50_1, CV_55_1, CV_60_1, CV_65_1, CV_70];
Table21 = [Speed_50_2, Speed_55_2, Speed_60_2, Speed_65_2];
Table22 = [STD_50_2, STD_55_2, STD_60_2, STD_65_2];
Table23 = [CV_50_2, CV_55_2, CV_60_2, CV_65_2];
writetable(Table11,'Steady_State_027.xlsx','Sheet',1,'Range','A1:O2')
writetable(Table12,'Steady_State_027.xlsx','Sheet',1,'WriteVariableNames',0,'Range','A3:O3')
writetable(Table13,'Steady_State_027.xlsx','Sheet',1,'WriteVariableNames',0,'Range','A4:O4')
writetable(Table21,'Steady_State_027.xlsx','Sheet',1,'Range','A5:O6')
writetable(Table22,'Steady_State_027.xlsx','Sheet',1,'WriteVariableNames',0,'Range','A7:O7')
writetable(Table23,'Steady_State_027.xlsx','Sheet',1,'WriteVariableNames',0,'Range','A8:O8')