阅读并不难；解释您缺乏一些信息...
First, use the
检测iMportoptions
function to set up a base import object and then pick only the columns with variable names to actually read in --
opt = dentectimportoptions（'test_file.xls'，，，，“ numheaderlines”，4）;％实际上只有5个，没有六个标题线
isgoodcol = find（cellfun（@isempty，regexp（opt.SelectedVariablenames，'Var*'））;％查找定义的变量名称
opt.SelectedVariableNames=opt.SelectedVariableNames(isGoodCol);％仅导入这些列
t =可读取（'test_file.xls'，，，，opt);％阅读桌子
[h,m,s]=hms(datetime(T.TIME_,“转换”，，，，'excel'));％从Excel转换时间
t.date_ = dateshift（fillmissing（t.date_，，'以前的'),'开始'，，，，'天');％开始一天
T.DATE_=T.DATE_+duration(h,m,s);% and add time
T.Time _ = [];% now superfluous
Returns
T =
43×9 table
DATE_m00__cM01_CM02__CM03__CM04__CM10__HM20__CM30_Gk
____________________________________________________________________
10-MAR-2020 14:05:36 24.59 23.50 23.43 23.58 -1.09 28.10 4.90 5.40
10-Mar-2020 14:10:36 24.51 23.48 23.44 23.61 -1.03 28.00 4.80 5.30
10-Mar-2020 14:15:36 24.43 23.42 23.43 23.60 -1.01 28.50 5.00 5.40
...
10-MAR-2020 16:10:36 24.29 23.27 23.38 23.57 -1.02 28.20 4.70 5.30
10-Mar-2020 16:15:36 24.29 23.27 23.38 23.56 -1.02 28.20 4.70 5.30
10-Mar-2020 16:20:36 24.29 23.27 23.38 23.56 -1.02 28.30 4.80 5.30
10-MAR-2020 16:25:36 24.29 23.27 23.38 23.56 -1.02 28.30 4.80 5.30
11月11日2020 00:00:36 24.28 23.24 23.34 23.53 -1.04 29.00 5.10 5.10 5.40
11-Mar-2020 00:05:36 24.29 23.24 23.34 23.53 -1.05 29.00 5.10 5.40
11-Mar-2020 00:10:36 24.28 23.24 23.33 23.53 -1.04 29.10 5.20 5.40
11-Mar-2020 00:15:36 24.26 23.24 23.34 23.53 -1.02 29.10 5.10 5.40
11-Mar-2020 00:50:36 24.26 23.24 23.34 23.53 -1.02 29.10 5.10 5.40
11-Mar-2020 00:55:36 24.28 23.24 23.34 23.53 -1.04 29.10 5.20 5.40
11月11日2020 01:00:36 24.26 23.24 23.34 23.53 -1.02 29.10 5.20 5.20 5.40
11月11日2020 01:05:36 24.28 23.24 23.33 23.53 -1.04 29.20 5.20 5.20 5.40
...。
>>
where I elided data rows for brevity.
