Info

이 질문은 마감되었습니다. 편집하거나 답변을 올리려면 질문을 다시 여십시오.

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

조회 수: 1(최근 30일)
isamh
isamh 2020년 11월 7일
마감: MATLAB Answer Bot 2021년 8월 20일
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')
  댓글 수: 3
dpb
dpb 2020년 11월 7일
Well, a .csv file can contain anything -- we can't see it from here.
We can't debug what we can't see/touch...
Either attach the data that fails or the table you tried to write.
Alternatively, delete the sheet(s) and try again. Will at least eliminate being left over from previous data on the same sheet.

답변(0개)

Community Treasure Hunt

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

Start Hunting!

Translated by