求助大神帮帮忙，给个小程序~！！！

我有一个excel2013的文件，SHEET页面10-20个不等，每页面100多万行数据。
数据如下：

2017-12-23 07:30:00.000	6.740223
2017-12-23  07:30:00.500	6.742738
2017-12-23  07:30:01.000	6.741006
2017-12-23  07:30:01.500	6.74316
2017-12-23  07:30:02.000	6.741403
2017-12-23  07:30:02.500	6.743275
2017-12-23  07:30:03.000	6.74328
2017-12-23  07:30:03.500	6.7432
2017-12-23  07:30:04.000	6.742964
2017-12-23  07:30:04.500	6.743034
2017-12-23  07:30:05.000	6.743195
2017-12-23  07:30:05.500	6.743306
2017-12-23  07:30:06.000	6.743632
2017-12-23  07:30:06.500	6.743682
2017-12-23  07:30:07.000	6.743767
2017-12-23  07:30:07.500	6.743697
2017-12-23  07:30:08.000	6.743808
2017-12-23  07:30:08.500	6.744008
2017-12-23  07:30:09.000	6.744254
2017-12-23  07:30:09.500	6.74444
2017-12-23  07:30:10.000	6.744536
2017-12-23  07:30:10.500	6.744777
2017-12-23  07:30:11.000	6.744983
2017-12-23  07:30:11.500	6.745158
2017-12-23  07:30:12.000	6.745369
2017-12-23  07:30:12.500	6.745841
2017-12-23  07:30:13.000	6.746368
2017-12-23  07:30:13.500	6.74685
2017-12-23  07:30:14.000	6.747111
2017-12-23  07:30:14.500	6.747207
2017-12-23  07:30:15.000	6.747227
2017-12-23  07:30:15.500	6.747232
2017-12-23  07:30:16.000	6.747126
2017-12-23  07:30:16.500	6.746865
2017-12-23  07:30:17.000	6.746835
2017-12-23  07:30:17.500	6.747076
2017-12-23  07:30:18.000	6.747192
2017-12-23  07:30:18.500	6.747473
2017-12-23  07:30:19.000	6.747874
2017-12-23  07:30:19.500	6.748532
2017-12-23  07:30:20.000	6.749069
2017-12-23  07:30:20.500	6.749597
2017-12-23  07:30:21.000	6.749923
2017-12-23  07:30:21.500	6.750234
2017-12-23  07:30:22.000	6.750279
2017-12-23  07:30:22.500	6.750445
2017-12-23  07:30:23.000	6.750515
2017-12-23  07:30:23.500	6.750751
2017-12-23  07:30:24.000	6.751063
2017-12-23  07:30:24.500	6.751419
2017-12-23  07:30:25.000	6.75168
2017-12-23  07:30:25.500	6.751966
2017-12-23  07:30:26.000	6.752257
2017-12-23  07:30:26.500	6.752318
2017-12-23  07:30:27.000	6.752207
2017-12-23  07:30:27.500	6.752237
2017-12-23  07:30:28.000	6.752222
2017-12-23  07:30:28.500	6.752197
2017-12-23  07:30:29.000	6.752042
2017-12-23  07:30:29.500	6.751906
2017-12-23  07:30:30.000	6.7516
2017-12-23  07:30:30.500	6.751429
2017-12-23  07:30:31.000	6.751509
2017-12-23  07:30:31.500	6.751776
2017-12-23  07:30:32.000	6.752117
2017-12-23  07:30:32.500	6.752378
2017-12-23  07:30:33.000	6.752729
2017-12-23  07:30:33.500	6.753091
2017-12-23  07:30:34.000	6.753472
2017-12-23  07:30:34.500	6.753583
2017-12-23  07:30:35.000	6.753437
2017-12-23  07:30:35.500	6.753001
2017-12-23  07:30:36.000	6.752654
2017-12-23  07:30:36.500	6.752328
2017-12-23  07:30:37.000	6.752162
2017-12-23  07:30:37.500	6.751971
2017-12-23  07:30:38.000	6.751695
2017-12-23  07:30:38.500	6.751459
2017-12-23  07:30:39.000	6.751173
2017-12-23  07:30:39.500	6.750761
2017-12-23  07:30:40.000	6.75055
2017-12-23  07:30:40.500	6.750571
2017-12-23  07:30:41.000	6.750656
2017-12-23  07:30:41.500	6.750596
2017-12-23  07:30:42.000	6.750606
2017-12-23  07:30:42.500	6.750545
2017-12-23  07:30:43.000	6.75044
2017-12-23  07:30:43.500	6.75044
2017-12-23  07:30:44.000	6.750495
2017-12-23  07:30:44.500	6.75045
2017-12-23  07:30:45.000	6.750445
2017-12-23  07:30:45.500	6.750556
2017-12-23  07:30:46.000	6.750596
2017-12-23  07:30:46.500	6.750691
2017-12-23  07:30:47.000	6.750927
2017-12-23  07:30:47.500	6.751078
2017-12-23  07:30:48.000	6.751128
2017-12-23  07:30:48.500	6.751118
2017-12-23  07:30:49.000	6.751103
2017-12-23  07:30:49.500	6.750827
2017-12-23  07:30:50.000	6.750535
2017-12-23  07:30:50.500	6.75039
2017-12-23  07:30:51.000	6.750355
2017-12-23  07:30:51.500	6.750465
2017-12-23  07:30:52.000	6.75036
2017-12-23  07:30:52.500	6.75038
2017-12-23  07:30:53.000	6.750325
2017-12-23  07:30:53.500	6.750224
2017-12-23  07:30:54.000	6.750209
2017-12-23  07:30:54.500	6.750229
2017-12-23  07:30:55.000	6.75033
2017-12-23  07:30:55.500	6.75035
2017-12-23  07:30:56.000	6.75034
2017-12-23  07:30:56.500	6.75041
2017-12-23  07:30:57.000	6.75039
2017-12-23  07:30:57.500	6.750309
2017-12-23  07:30:58.000	6.750224
2017-12-23  07:30:58.500	6.75033
2017-12-23  07:30:59.000	6.750601
2017-12-23  07:30:59.500	6.750741
2017-12-23  07:31:00.000	6.750847
2017-12-23  07:31:00.500	6.750867
2017-12-23  07:31:01.000	6.750962
2017-12-23  07:31:01.500	6.750922
2017-12-23  07:31:02.000	6.750892
2017-12-23  07:31:02.500	6.750867
2017-12-23  07:31:03.000	6.750771
2017-12-23  07:31:03.500	6.750681
2017-12-23  07:31:04.000	6.750691
2017-12-23  07:31:04.500	6.750721
2017-12-23  07:31:05.000	6.750661
2017-12-23  07:31:05.500	6.750686
2017-12-23  07:31:06.000	6.750701
2017-12-23  07:31:06.500	6.750837
2017-12-23  07:31:07.000	6.750807
2017-12-23  07:31:07.500	6.750897
2017-12-23  07:31:08.000	6.750902
2017-12-23  07:31:08.500	6.750907
2017-12-23  07:31:09.000	6.750797
2017-12-23  07:31:09.500	6.750701
2017-12-23  07:31:10.000	6.75052
2017-12-23  07:31:10.500	6.75039
2017-12-23  07:31:11.000	6.750309
2017-12-23  07:31:11.500	6.750159
2017-12-23  07:31:12.000	6.750013
2017-12-23  07:31:12.500	6.750214
2017-12-23  07:31:13.000	6.75042
2017-12-23  07:31:13.500	6.750495
2017-12-23  07:31:14.000	6.75048
2017-12-23  07:31:14.500	6.750289
2017-12-23  07:31:15.000	6.750048
2017-12-23  07:31:15.500	6.749797
2017-12-23  07:31:16.000	6.749546
2017-12-23  07:31:16.500	6.749401
2017-12-23  07:31:17.000	6.74933
2017-12-23  07:31:17.500	6.749441
2017-12-23  07:31:18.000	6.749521
2017-12-23  07:31:18.500	6.749647
2017-12-23  07:31:19.000	6.749536
2017-12-23  07:31:19.500	6.749471
2017-12-23  07:31:20.000	6.749215
2017-12-23  07:31:20.500	6.749019
2017-12-23  07:31:21.000	6.748874
2017-12-23  07:31:21.500	6.748648
2017-12-23  07:31:22.000	6.748361
2017-12-23  07:31:22.500	6.74812
2017-12-23  07:31:23.000	6.748035
2017-12-23  07:31:23.500	6.748045
2017-12-23  07:31:24.000	6.747925
2017-12-23  07:31:24.500	6.747839
2017-12-23  07:31:25.000	6.747744
2017-12-23  07:31:25.500	6.747784
2017-12-23  07:31:26.000	6.747834
2017-12-23  07:31:26.500	6.747819
2017-12-23  07:31:27.000	6.747804
2017-12-23  07:31:27.500	6.747779
2017-12-23  07:31:28.000	6.747689
2017-12-23  07:31:28.500	6.747679
2017-12-23  07:31:29.000	6.747654
2017-12-23  07:31:29.500	6.747684
2017-12-23  07:31:30.000	6.747603
2017-12-23  07:31:30.500	6.747618
2017-12-23  07:31:31.000	6.747553
2017-12-23  07:31:31.500	6.747523
2017-12-23  07:31:32.000	6.747377
2017-12-23  07:31:32.500	6.747267
2017-12-23  07:31:33.000	6.747222
2017-12-23  07:31:33.500	6.747001
2017-12-23  07:31:34.000	6.74687
2017-12-23  07:31:34.500	6.746745
2017-12-23  07:31:35.000	6.746715
2017-12-23  07:31:35.500	6.746885
2017-12-23  07:31:36.000	6.747192
2017-12-23  07:31:36.500	6.747874
2017-12-23  07:31:37.000	6.749034
2017-12-23  07:31:37.500	6.750224
2017-12-23  07:31:38.000	6.751238
2017-12-23  07:31:38.500	6.751625
2017-12-23  07:31:39.000	6.751555
2017-12-23  07:31:39.500	6.751519
2017-12-23  07:31:40.000	6.751314
2017-12-23  07:31:40.500	6.751113
2017-12-23  07:31:41.000	6.750676
2017-12-23  07:31:41.500	6.750023
2017-12-23  07:31:42.000	6.749351
2017-12-23  07:31:42.500	6.748758
2017-12-23  07:31:43.000	6.748361
2017-12-23  07:31:43.500	6.74807
2017-12-23  07:31:44.000	6.747955
2017-12-23  07:31:44.500	6.748095
2017-12-23  07:31:45.000	6.748286
2017-12-23  07:31:45.500	6.748326
2017-12-23  07:31:46.000	6.748146
2017-12-23  07:31:46.500	6.747874
2017-12-23  07:31:47.000	6.747518
2017-12-23  07:31:47.500	6.747357
2017-12-23  07:31:48.000	6.747332
2017-12-23  07:31:48.500	6.747413
2017-12-23  07:31:49.000	6.747819
2017-12-23  07:31:49.500	6.748382
2017-12-23  07:31:50.000	6.748904
2017-12-23  07:31:50.500	6.74931
2017-12-23  07:31:51.000	6.749556
2017-12-23  07:31:51.500	6.749617
2017-12-23  07:31:52.000	6.749767
2017-12-23  07:31:52.500	6.749802
2017-12-23  07:31:53.000	6.749958
2017-12-23  07:31:53.500	6.750134
2017-12-23  07:31:54.000	6.750525
2017-12-23  07:31:54.500	6.751098
2017-12-23  07:31:55.000	6.7517
2017-12-23  07:31:55.500	6.752132
2017-12-23  07:31:56.000	6.752629
2017-12-23  07:31:56.500	6.753141
2017-12-23  07:31:57.000	6.753111
2017-12-23  07:31:57.500	6.753001
2017-12-23  07:31:58.000	6.752885
2017-12-23  07:31:58.500	6.753051
2017-12-23  07:31:59.000	6.753247
2017-12-23  07:31:59.500	6.753673
2017-12-23  07:32:00.000	6.754331
2017-12-23  07:32:00.500	6.754708
2017-12-23  07:32:01.000	6.754878
2017-12-23  07:32:01.500	6.754853
2017-12-23  07:32:02.000	6.754903
2017-12-23  07:32:02.500	6.755064
2017-12-23  07:32:03.000	6.755265
2017-12-23  07:32:03.500	6.755676
2017-12-23  07:32:04.000	6.756168
2017-12-23  07:32:04.500	6.756816
2017-12-23  07:32:05.000	6.757599
2017-12-23  07:32:05.500	6.758563
2017-12-23  07:32:06.000	6.759367
2017-12-23  07:32:06.500	6.759994
2017-12-23  07:32:07.000	6.760526
2017-12-23  07:32:07.500	6.761099
2017-12-23  07:32:08.000	6.761616
2017-12-23  07:32:08.500	6.761922
2017-12-23  07:32:09.000	6.761997
2017-12-23  07:32:09.500	6.761872
2017-12-23  07:32:10.000	6.761666
2017-12-23  07:32:10.500	6.76142
2017-12-23  07:32:11.000	6.761254
2017-12-23  07:32:11.500	6.760968
2017-12-23  07:32:12.000	6.760757
2017-12-23  07:32:12.500	6.760496
2017-12-23  07:32:13.000	6.760396
2017-12-23  07:32:13.500	6.760345
2017-12-23  07:32:14.000	6.760481
2017-12-23  07:32:14.500	6.760782
2017-12-23  07:32:15.000	6.761023
2017-12-23  07:32:15.500	6.761189
2017-12-23  07:32:16.000	6.76137
2017-12-23  07:32:16.500	6.761545
2017-12-23  07:32:17.000	6.761832
2017-12-23  07:32:17.500	6.762027
2017-12-23  07:32:18.000	6.762113
2017-12-23  07:32:18.500	6.762118
2017-12-23  07:32:19.000	6.761967
2017-12-23  07:32:19.500	6.761681
2017-12-23  07:32:20.000	6.76149
2017-12-23  07:32:20.500	6.761329
2017-12-23  07:32:21.000	6.761229
2017-12-23  07:32:21.500	6.761033
2017-12-23  07:32:22.000	6.760812
2017-12-23  07:32:22.500	6.760677
2017-12-23  07:32:23.000	6.760436
2017-12-23  07:32:23.500	6.760245
2017-12-23  07:32:24.000	6.760094
2017-12-23  07:32:24.500	6.759929
2017-12-23  07:32:25.000	6.759879
2017-12-23  07:32:25.500	6.759803
2017-12-23  07:32:26.000	6.759733
2017-12-23  07:32:26.500	6.759597
2017-12-23  07:32:27.000	6.759597
2017-12-23  07:32:27.500	6.759497
2017-12-23  07:32:28.000	6.759417
2017-12-23  07:32:28.500	6.759196
2017-12-23  07:32:29.000	6.759005
2017-12-23  07:32:29.500	6.758729
2017-12-23  07:32:30.000	6.758724
2017-12-23  07:32:30.500	6.758498
2017-12-23  07:32:31.000	6.758563
2017-12-23  07:32:31.500	6.758518
2017-12-23  07:32:32.000	6.758503
2017-12-23  07:32:32.500	6.758433
2017-12-23  07:32:33.000	6.758192
2017-12-23  07:32:33.500	6.758071
2017-12-23  07:32:34.000	6.75787
2017-12-23  07:32:34.500	6.758006
2017-12-23  07:32:35.000	6.758277
2017-12-23  07:32:35.500	6.758322
2017-12-23  07:32:36.000	6.758327
2017-12-23  07:32:36.500	6.758473
2017-12-23  07:32:37.000	6.758468
2017-12-23  07:32:37.500	6.758523
2017-12-23  07:32:38.000	6.758518
2017-12-23  07:32:38.500	6.758503
2017-12-23  07:32:39.000	6.758543
2017-12-23  07:32:39.500	6.758608
2017-12-23  07:32:40.000	6.759121
2017-12-23  07:32:40.500	6.759773
2017-12-23  07:32:41.000	6.760456
2017-12-23  07:32:41.500	6.760953
2017-12-23  07:32:42.000	6.761204
2017-12-23  07:32:42.500	6.761475
2017-12-23  07:32:43.000	6.761626
2017-12-23  07:32:43.500	6.761862
2017-12-23  07:32:44.000	6.761912
2017-12-23  07:32:44.500	6.762083
2017-12-23  07:32:45.000	6.762228
2017-12-23  07:32:45.500	6.762344
2017-12-23  07:32:46.000	6.762575
2017-12-23  07:32:46.500	6.762715
2017-12-23  07:32:47.000	6.762956
2017-12-23  07:32:47.500	6.763197
2017-12-23  07:32:48.000	6.763247
2017-12-23  07:32:48.500	6.763287
2017-12-23  07:32:49.000	6.763353
2017-12-23  07:32:49.500	6.763604
2017-12-23  07:32:50.000	6.763749
2017-12-23  07:32:50.500	6.763905
2017-12-23  07:32:51.000	6.76394
2017-12-23  07:32:51.500	6.764055
2017-12-23  07:32:52.000	6.76401
2017-12-23  07:32:52.500	6.764035
2017-12-23  07:32:53.000	6.76384
2017-12-23  07:32:53.500	6.763659
2017-12-23  07:32:54.000	6.763659
2017-12-23  07:32:54.500	6.763558
2017-12-23  07:32:55.000	6.763538
2017-12-23  07:32:55.500	6.763478
2017-12-23  07:32:56.000	6.763318
2017-12-23  07:32:56.500	6.763267
2017-12-23  07:32:57.000	6.763182
2017-12-23  07:32:57.500	6.763222
2017-12-23  07:32:58.000	6.763237
2017-12-23  07:32:58.500	6.763302
2017-12-23  07:32:59.000	6.763378
2017-12-23  07:32:59.500	6.763528
2017-12-23  07:33:00.000	6.763789
2017-12-23  07:33:00.500	6.764121
2017-12-23  07:33:01.000	6.764553
2017-12-23  07:33:01.500	6.764949
2017-12-23  07:33:02.000	6.76515
2017-12-23  07:33:02.500	6.765401
2017-12-23  07:33:03.000	6.765547
2017-12-23  07:33:03.500	6.765567
2017-12-23  07:33:04.000	6.765361
2017-12-23  07:33:04.500	6.76517
2017-12-23  07:33:05.000	6.76526
2017-12-23  07:33:05.500	6.765416
2017-12-23  07:33:06.000	6.765536
2017-12-23  07:33:06.500	6.765692
2017-12-23  07:33:07.000	6.765712
2017-12-23  07:33:07.500	6.766129
2017-12-23  07:33:08.000	6.766701
2017-12-23  07:33:08.500	6.767268
2017-12-23  07:33:09.000	6.767735
2017-12-23  07:33:09.500	6.768122
2017-12-23  07:33:10.000	6.768468
2017-12-23  07:33:10.500	6.768604
2017-12-23  07:33:11.000	6.768574
2017-12-23  07:33:11.500	6.768734
2017-12-23  07:33:12.000	6.768704
2017-12-23  07:33:12.500	6.768609
2017-12-23  07:33:13.000	6.768488
2017-12-23  07:33:13.500	6.768453
2017-12-23  07:33:14.000	6.768363
2017-12-23  07:33:14.500	6.768378
2017-12-23  07:33:15.000	6.768192
2017-12-23  07:33:15.500	6.768001
2017-12-23  07:33:16.000	6.76774
2017-12-23  07:33:16.500	6.76759
2017-12-23  07:33:17.000	6.767504
2017-12-23  07:33:17.500	6.767504
2017-12-23  07:33:18.000	6.767509
2017-12-23  07:33:18.500	6.767675
2017-12-23  07:33:19.000	6.76775
2017-12-23  07:33:19.500	6.767755
2017-12-23  07:33:20.000	6.767725
2017-12-23  07:33:20.500	6.76767
2017-12-23  07:33:21.000	6.767615
2017-12-23  07:33:21.500	6.767565
2017-12-23  07:33:22.000	6.767524
2017-12-23  07:33:22.500	6.767635
2017-12-23  07:33:23.000	6.767474
2017-12-23  07:33:23.500	6.767414
2017-12-23  07:33:24.000	6.767529
2017-12-23  07:33:24.500	6.767434
2017-12-23  07:33:25.000	6.767474
2017-12-23  07:33:25.500	6.767509
2017-12-23  07:33:26.000	6.767585
2017-12-23  07:33:26.500	6.767645
2017-12-23  07:33:27.000	6.76759
2017-12-23  07:33:27.500	6.76759
2017-12-23  07:33:28.000	6.767585
2017-12-23  07:33:28.500	6.767575
2017-12-23  07:33:29.000	6.767585
2017-12-23  07:33:29.500	6.767625
2017-12-23  07:33:30.000	6.76758
2017-12-23  07:33:30.500	6.76763
2017-12-23  07:33:31.000	6.767655
2017-12-23  07:33:31.500	6.76758
2017-12-23  07:33:32.000	6.767645
2017-12-23  07:33:32.500	6.767585
2017-12-23  07:33:33.000	6.767585
2017-12-23  07:33:33.500	6.767625
2017-12-23  07:33:34.000	6.76773
2017-12-23  07:33:34.500	6.767655
2017-12-23  07:33:35.000	6.76774
2017-12-23  07:33:35.500	6.767866
2017-12-23  07:33:36.000	6.767921
2017-12-23  07:33:36.500	6.767981
2017-12-23  07:33:37.000	6.768107
2017-12-23  07:33:37.500	6.768172
2017-12-23  07:33:38.000	6.768227
2017-12-23  07:33:38.500	6.768277
2017-12-23  07:33:39.000	6.768368
2017-12-23  07:33:39.500	6.768473
2017-12-23  07:33:40.000	6.768669
2017-12-23  07:33:40.500	6.76879
2017-12-23  07:33:41.000	6.768885
2017-12-23  07:33:41.500	6.768975
2017-12-23  07:33:42.000	6.7689
2017-12-23  07:33:42.500	6.768895
2017-12-23  07:33:43.000	6.769031
2017-12-23  07:33:43.500	6.769056
2017-12-23  07:33:44.000	6.769266
2017-12-23  07:33:44.500	6.769362
2017-12-23  07:33:45.000	6.769477
2017-12-23  07:33:45.500	6.769548
2017-12-23  07:33:46.000	6.769683
2017-12-23  07:33:46.500	6.769723
2017-12-23  07:33:47.000	6.769703
2017-12-23  07:33:47.500	6.769648
2017-12-23  07:33:48.000	6.769588
2017-12-23  07:33:48.500	6.769713
2017-12-23  07:33:49.000	6.769678
2017-12-23  07:33:49.500	6.769633
2017-12-23  07:33:50.000	6.769558
2017-12-23  07:33:50.500	6.769522
2017-12-23  07:33:51.000	6.769578
2017-12-23  07:33:51.500	6.769733
2017-12-23  07:33:52.000	6.769854
2017-12-23  07:33:52.500	6.770065
2017-12-23  07:33:53.000	6.77026
2017-12-23  07:33:53.500	6.770617
2017-12-23  07:33:54.000	6.770983
2017-12-23  07:33:54.500	6.771249
2017-12-23  07:33:55.000	6.771505
2017-12-23  07:33:55.500	6.771601
2017-12-23  07:33:56.000	6.771596
2017-12-23  07:33:56.500	6.771686
2017-12-23  07:33:57.000	6.771847
2017-12-23  07:33:57.500	6.771962
2017-12-23  07:33:58.000	6.772083
2017-12-23  07:33:58.500	6.772073
2017-12-23  07:33:59.000	6.772113
2017-12-23  07:33:59.500	6.771987
2017-12-23  07:34:00.000	6.771907
2017-12-23  07:34:00.500	6.771782
2017-12-23  07:34:01.000	6.771581
2017-12-23  07:34:01.500	6.771475
2017-12-23  07:34:02.000	6.77145
2017-12-23  07:34:02.500	6.771475
2017-12-23  07:34:03.000	6.771475
2017-12-23  07:34:03.500	6.77151
2017-12-23  07:34:04.000	6.77139
2017-12-23  07:34:04.500	6.771435
2017-12-23  07:34:05.000	6.771385
2017-12-23  07:34:05.500	6.77145
2017-12-23  07:34:06.000	6.77149
2017-12-23  07:34:06.500	6.771405
2017-12-23  07:34:07.000	6.771455
2017-12-23  07:34:07.500	6.771455
2017-12-23  07:34:08.000	6.771475
2017-12-23  07:34:08.500	6.77152
2017-12-23  07:34:09.000	6.77147
2017-12-23  07:34:09.500	6.77149
2017-12-23  07:34:10.000	6.771425
2017-12-23  07:34:10.500	6.77142
2017-12-23  07:34:11.000	6.771435
2017-12-23  07:34:11.500	6.77146
2017-12-23  07:34:12.000	6.77144
2017-12-23  07:34:12.500	6.771541
2017-12-23  07:34:13.000	6.771561
2017-12-23  07:34:13.500	6.771525
2017-12-23  07:34:14.000	6.771546
2017-12-23  07:34:14.500	6.771551
2017-12-23  07:34:15.000	6.771586
2017-12-23  07:34:15.500	6.771606
2017-12-23  07:34:16.000	6.771616
2017-12-23  07:34:16.500	6.771566
2017-12-23  07:34:17.000	6.771616
2017-12-23  07:34:17.500	6.771556
2017-12-23  07:34:18.000	6.77151
2017-12-23  07:34:18.500	6.771485
2017-12-23  07:34:19.000	6.771495
2017-12-23  07:34:19.500	6.771465
2017-12-23  07:34:20.000	6.771536
2017-12-23  07:34:20.500	6.771546
2017-12-23  07:34:21.000	6.77147
2017-12-23  07:34:21.500	6.771546
2017-12-23  07:34:22.000	6.771551
2017-12-23  07:34:22.500	6.771561
2017-12-23  07:34:23.000	6.771556
2017-12-23  07:34:23.500	6.771621
2017-12-23  07:34:24.000	6.771556
2017-12-23  07:34:24.500	6.771611
2017-12-23  07:34:25.000	6.771621
2017-12-23  07:34:25.500	6.771656
2017-12-23  07:34:26.000	6.771696
2017-12-23  07:34:26.500	6.771651
2017-12-23  07:34:27.000	6.771616
2017-12-23  07:34:27.500	6.771646
2017-12-23  07:34:28.000	6.771656
2017-12-23  07:34:28.500	6.771591
2017-12-23  07:34:29.000	6.771651
2017-12-23  07:34:29.500	6.771586
2017-12-23  07:34:30.000	6.771485
2017-12-23  07:34:30.500	6.77143
2017-12-23  07:34:31.000	6.771355
2017-12-23  07:34:31.500	6.77132
2017-12-23  07:34:32.000	6.771264
2017-12-23  07:34:32.500	6.771194
2017-12-23  07:34:33.000	6.771189
2017-12-23  07:34:33.500	6.771169
2017-12-23  07:34:34.000	6.771119
2017-12-23  07:34:34.500	6.771018
2017-12-23  07:34:35.000	6.770958
2017-12-23  07:34:35.500	6.770953
2017-12-23  07:34:36.000	6.770963
2017-12-23  07:34:36.500	6.770993
2017-12-23  07:34:37.000	6.771013
2017-12-23  07:34:37.500	6.771003
2017-12-23  07:34:38.000	6.771069
2017-12-23  07:34:38.500	6.771069
2017-12-23  07:34:39.000	6.771199
2017-12-23  07:34:39.500	6.771069
2017-12-23  07:34:40.000	6.771144
2017-12-23  07:34:40.500	6.771209
2017-12-23  07:34:41.000	6.771214
2017-12-23  07:34:41.500	6.771249
2017-12-23  07:34:42.000	6.771219
2017-12-23  07:34:42.500	6.771174
2017-12-23  07:34:43.000	6.771164
2017-12-23  07:34:43.500	6.771154
2017-12-23  07:34:44.000	6.771234
2017-12-23  07:34:44.500	6.771159
2017-12-23  07:34:45.000	6.771149
2017-12-23  07:34:45.500	6.771179
2017-12-23  07:34:46.000	6.771139
2017-12-23  07:34:46.500	6.771229
2017-12-23  07:34:47.000	6.771184
2017-12-23  07:34:47.500	6.771194
2017-12-23  07:34:48.000	6.771239
2017-12-23  07:34:48.500	6.771219
2017-12-23  07:34:49.000	6.771254
2017-12-23  07:34:49.500	6.771264
2017-12-23  07:34:50.000	6.771325
2017-12-23  07:34:50.500	6.771305
2017-12-23  07:34:51.000	6.771244
2017-12-23  07:34:51.500	6.771199
2017-12-23  07:34:52.000	6.771179
2017-12-23  07:34:52.500	6.771164
2017-12-23  07:34:53.000	6.771139
2017-12-23  07:34:53.500	6.771144
2017-12-23  07:34:54.000	6.771164
2017-12-23  07:34:54.500	6.771305
2017-12-23  07:34:55.000	6.771209
2017-12-23  07:34:55.500	6.771199
2017-12-23  07:34:56.000	6.771199
2017-12-23  07:34:56.500	6.77128
2017-12-23  07:34:57.000	6.771244
2017-12-23  07:34:57.500	6.771264
2017-12-23  07:34:58.000	6.771264
2017-12-23  07:34:58.500	6.771234
2017-12-23  07:34:59.000	6.771174
2017-12-23  07:34:59.500	6.771234
2017-12-23  07:35:00.000	6.771244
2017-12-23  07:35:00.500	6.771219
2017-12-23  07:35:01.000	6.771194
2017-12-23  07:35:01.500	6.771184
2017-12-23  07:35:02.000	6.771159
2017-12-23  07:35:02.500	6.771204
2017-12-23  07:35:03.000	6.771239
2017-12-23  07:35:03.500	6.771149
2017-12-23  07:35:04.000	6.771214
2017-12-23  07:35:04.500	6.771134
2017-12-23  07:35:05.000	6.771154
2017-12-23  07:35:05.500	6.771174
2017-12-23  07:35:06.000	6.771209
2017-12-23  07:35:06.500	6.771089
2017-12-23  07:35:07.000	6.771054
2017-12-23  07:35:07.500	6.771134
2017-12-23  07:35:08.000	6.771104
2017-12-23  07:35:08.500	6.771013
2017-12-23  07:35:09.000	6.771069
2017-12-23  07:35:09.500	6.771069
2017-12-23  07:35:10.000	6.771034
2017-12-23  07:35:10.500	6.770968
2017-12-23  07:35:11.000	6.770878
2017-12-23  07:35:11.500	6.770848
2017-12-23  07:35:12.000	6.770838
2017-12-23  07:35:12.500	6.770777
2017-12-23  07:35:13.000	6.770858
2017-12-23  07:35:13.500	6.770803
2017-12-23  07:35:14.000	6.770793
2017-12-23  07:35:14.500	6.770752
2017-12-23  07:35:15.000	6.770823
2017-12-23  07:35:15.500	6.770757
2017-12-23  07:35:16.000	6.770672
2017-12-23  07:35:16.500	6.770607
2017-12-23  07:35:17.000	6.770667
2017-12-23  07:35:17.500	6.770697
2017-12-23  07:35:18.000	6.770662
2017-12-23  07:35:18.500	6.770677
2017-12-23  07:35:19.000	6.770622
2017-12-23  07:35:19.500	6.770657
2017-12-23  07:35:20.000	6.770612
2017-12-23  07:35:20.500	6.770607
2017-12-23  07:35:21.000	6.770597
2017-12-23  07:35:21.500	6.770617
2017-12-23  07:35:22.000	6.770632
2017-12-23  07:35:22.500	6.770717
2017-12-23  07:35:23.000	6.770687
2017-12-23  07:35:23.500	6.770667
2017-12-23  07:35:24.000	6.770557
2017-12-23  07:35:24.500	6.770486
2017-12-23  07:35:25.000	6.770481
2017-12-23  07:35:25.500	6.770552
2017-12-23  07:35:26.000	6.770496
2017-12-23  07:35:26.500	6.770532
2017-12-23  07:35:27.000	6.770481
2017-12-23  07:35:27.500	6.770451
2017-12-23  07:35:28.000	6.770486
2017-12-23  07:35:28.500	6.770481
2017-12-23  07:35:29.000	6.770421
2017-12-23  07:35:29.500	6.770516
2017-12-23  07:35:30.000	6.770486
2017-12-23  07:35:30.500	6.770547
2017-12-23  07:35:31.000	6.770486
2017-12-23  07:35:31.500	6.770441
2017-12-23  07:35:32.000	6.770456
2017-12-23  07:35:32.500	6.770381
2017-12-23  07:35:33.000	6.770366
2017-12-23  07:35:33.500	6.770431
2017-12-23  07:35:34.000	6.770461
2017-12-23  07:35:34.500	6.770391
2017-12-23  07:35:35.000	6.770461
2017-12-23  07:35:35.500	6.770396
2017-12-23  07:35:36.000	6.770501
2017-12-23  07:35:36.500	6.770376
2017-12-23  07:35:37.000	6.770441
2017-12-23  07:35:37.500	6.770481
2017-12-23  07:35:38.000	6.770466
2017-12-23  07:35:38.500	6.770446
2017-12-23  07:35:39.000	6.770532
2017-12-23  07:35:39.500	6.770481
2017-12-23  07:35:40.000	6.770486
2017-12-23  07:35:40.500	6.770471
2017-12-23  07:35:41.000	6.770451
2017-12-23  07:35:41.500	6.770537
2017-12-23  07:35:42.000	6.770426
2017-12-23  07:35:42.500	6.770577
2017-12-23  07:35:43.000	6.770587
2017-12-23  07:35:43.500	6.770798
2017-12-23  07:35:44.000	6.771089
2017-12-23  07:35:44.500	6.771315
2017-12-23  07:35:45.000	6.771445
2017-12-23  07:35:45.500	6.771561
2017-12-23  07:35:46.000	6.77148
2017-12-23  07:35:46.500	6.771616
2017-12-23  07:35:47.000	6.771711
2017-12-23  07:35:47.500	6.771852
2017-12-23  07:35:48.000	6.772098
2017-12-23  07:35:48.500	6.772294
2017-12-23  07:35:49.000	6.772444
2017-12-23  07:35:49.500	6.772745
2017-12-23  07:35:50.000	6.773097
2017-12-23  07:35:50.500	6.773614
2017-12-23  07:35:51.000	6.774056
2017-12-23  07:35:51.500	6.774367
2017-12-23  07:35:52.000	6.774507
2017-12-23  07:35:52.500	6.774377
2017-12-23  07:35:53.000	6.774281
2017-12-23  07:35:53.500	6.774035
2017-12-23  07:35:54.000	6.77384
2017-12-23  07:35:54.500	6.773634
2017-12-23  07:35:55.000	6.773277
2017-12-23  07:35:55.500	6.773117
2017-12-23  07:35:56.000	6.773021
2017-12-23  07:35:56.500	6.773052
2017-12-23  07:35:57.000	6.773132
2017-12-23  07:35:57.500	6.773157
2017-12-23  07:35:58.000	6.773147
2017-12-23  07:35:58.500	6.773227
2017-12-23  07:35:59.000	6.773348
2017-12-23  07:35:59.500	6.773428
2017-12-23  07:36:00.000	6.773659
2017-12-23  07:36:00.500	6.773624
2017-12-23  07:36:01.000	6.773488
2017-12-23  07:36:01.500	6.773353
2017-12-23  07:36:02.000	6.773162
2017-12-23  07:36:02.500	6.773047
2017-12-23  07:36:03.000	6.773082
2017-12-23  07:36:03.500	6.773037
2017-12-23  07:36:04.000	6.772951
2017-12-23  07:36:04.500	6.772946
2017-12-23  07:36:05.000	6.772936
2017-12-23  07:36:05.500	6.772881
2017-12-23  07:36:06.000	6.772971
2017-12-23  07:36:06.500	6.772986
2017-12-23  07:36:07.000	6.773097
2017-12-23  07:36:07.500	6.773077
2017-12-23  07:36:08.000	6.773142
2017-12-23  07:36:08.500	6.773222
2017-12-23  07:36:09.000	6.773182
2017-12-23  07:36:09.500	6.773011
2017-12-23  07:36:10.000	6.772921
2017-12-23  07:36:10.500	6.772896
2017-12-23  07:36:11.000	6.773077
2017-12-23  07:36:11.500	6.773157
2017-12-23  07:36:12.000	6.773413
2017-12-23  07:36:12.500	6.773483
2017-12-23  07:36:13.000	6.773584
2017-12-23  07:36:13.500	6.773624
2017-12-23  07:36:14.000	6.773739
2017-12-23  07:36:14.500	6.773865
2017-12-23  07:36:15.000	6.773639
2017-12-23  07:36:15.500	6.773383
2017-12-23  07:36:16.000	6.773147
2017-12-23  07:36:16.500	6.773001
2017-12-23  07:36:17.000	6.772876
2017-12-23  07:36:17.500	6.772685
2017-12-23  07:36:18.000	6.772615
2017-12-23  07:36:18.500	6.772449
2017-12-23  07:36:19.000	6.772243
2017-12-23  07:36:19.500	6.772163
2017-12-23  07:36:20.000	6.772143
2017-12-23  07:36:20.500	6.772133
2017-12-23  07:36:21.000	6.772289
2017-12-23  07:36:21.500	6.772359
2017-12-23  07:36:22.000	6.772439
2017-12-23  07:36:22.500	6.772339
2017-12-23  07:36:23.000	6.772263
2017-12-23  07:36:23.500	6.772143
2017-12-23  07:36:24.000	6.772103
2017-12-23  07:36:24.500	6.772078
2017-12-23  07:36:25.000	6.772163
2017-12-23  07:36:25.500	6.772093
2017-12-23  07:36:26.000	6.772113
2017-12-23  07:36:26.500	6.772068
2017-12-23  07:36:27.000	6.771967
2017-12-23  07:36:27.500	6.771967
2017-12-23  07:36:28.000	6.771947
2017-12-23  07:36:28.500	6.771771
2017-12-23  07:36:29.000	6.771741
2017-12-23  07:36:29.500	6.771716
2017-12-23  07:36:30.000	6.771586
2017-12-23  07:36:30.500	6.771641
2017-12-23  07:36:31.000	6.771571
2017-12-23  07:36:31.500	6.771596
2017-12-23  07:36:32.000	6.771651
2017-12-23  07:36:32.500	6.771766
2017-12-23  07:36:33.000	6.771751
2017-12-23  07:36:33.500	6.771847
2017-12-23  07:36:34.000	6.771867
2017-12-23  07:36:34.500	6.771872
2017-12-23  07:36:35.000	6.771877
2017-12-23  07:36:35.500	6.771927
2017-12-23  07:36:36.000	6.771947
2017-12-23  07:36:36.500	6.771972
2017-12-23  07:36:37.000	6.771967
2017-12-23  07:36:37.500	6.771937
2017-12-23  07:36:38.000	6.771917
2017-12-23  07:36:38.500	6.772083
2017-12-23  07:36:39.000	6.772158
2017-12-23  07:36:39.500	6.772278
2017-12-23  07:36:40.000	6.772304
2017-12-23  07:36:40.500	6.772143
2017-12-23  07:36:41.000	6.772038
2017-12-23  07:36:41.500	6.771897
2017-12-23  07:36:42.000	6.771792
2017-12-23  07:36:42.500	6.771666
2017-12-23  07:36:43.000	6.771651
2017-12-23  07:36:43.500	6.771621
2017-12-23  07:36:44.000	6.771626
2017-12-23  07:36:44.500	6.771596
2017-12-23  07:36:45.000	6.771736
2017-12-23  07:36:45.500	6.771721
2017-12-23  07:36:46.000	6.771771
2017-12-23  07:36:46.500	6.771751
2017-12-23  07:36:47.000	6.771787
2017-12-23  07:36:47.500	6.771651
2017-12-23  07:36:48.000	6.771751
2017-12-23  07:36:48.500	6.771741
2017-12-23  07:36:49.000	6.771812
2017-12-23  07:36:49.500	6.771716
2017-12-23  07:36:50.000	6.771681
2017-12-23  07:36:50.500	6.771761
2017-12-23  07:36:51.000	6.771782
2017-12-23  07:36:51.500	6.771857
2017-12-23  07:36:52.000	6.771842
2017-12-23  07:36:52.500	6.771927
2017-12-23  07:36:53.000	6.772048
2017-12-23  07:36:53.500	6.772093
2017-12-23  07:36:54.000	6.772143
2017-12-23  07:36:54.500	6.772133
2017-12-23  07:36:55.000	6.772198
2017-12-23  07:36:55.500	6.772278
2017-12-23  07:36:56.000	6.772399
2017-12-23  07:36:56.500	6.772374
2017-12-23  07:36:57.000	6.772439
2017-12-23  07:36:57.500	6.772359
2017-12-23  07:36:58.000	6.772344
2017-12-23  07:36:58.500	6.772354
2017-12-23  07:36:59.000	6.772233
2017-12-23  07:36:59.500	6.772128
2017-12-23  07:37:00.000	6.772128
2017-12-23  07:37:00.500	6.772078
2017-12-23  07:37:01.000	6.771997
2017-12-23  07:37:01.500	6.771967
2017-12-23  07:37:02.000	6.771927
2017-12-23  07:37:02.500	6.771882
2017-12-23  07:37:03.000	6.771887
2017-12-23  07:37:03.500	6.771847
2017-12-23  07:37:04.000	6.771842
2017-12-23  07:37:04.500	6.771867
2017-12-23  07:37:05.000	6.771847
2017-12-23  07:37:05.500	6.771817
2017-12-23  07:37:06.000	6.771907
2017-12-23  07:37:06.500	6.771837
2017-12-23  07:37:07.000	6.771807
2017-12-23  07:37:07.500	6.771736
2017-12-23  07:37:08.000	6.771485
2017-12-23  07:37:08.500	6.771089
2017-12-23  07:37:09.000	6.770672
2017-12-23  07:37:09.500	6.770441
2017-12-23  07:37:10.000	6.770371
2017-12-23  07:37:10.500	6.770225
2017-12-23  07:37:11.000	6.770165
2017-12-23  07:37:11.500	6.770045
2017-12-23  07:37:12.000	6.769974
2017-12-23  07:37:12.500	6.77009
2017-12-23  07:37:13.000	6.77007
2017-12-23  07:37:13.500	6.77016
2017-12-23  07:37:14.000	6.770095
2017-12-23  07:37:14.500	6.769954
2017-12-23  07:37:15.000	6.769854
2017-12-23  07:37:15.500	6.769613
2017-12-23  07:37:16.000	6.769206
2017-12-23  07:37:16.500	6.768985
2017-12-23  07:37:17.000	6.768785
2017-12-23  07:37:17.500	6.768729
2017-12-23  07:37:18.000	6.768729
2017-12-23  07:37:18.500	6.76882
2017-12-23  07:37:19.000	6.768785
2017-12-23  07:37:19.500	6.76883
2017-12-23  07:37:20.000	6.768739
2017-12-23  07:37:20.500	6.768744
2017-12-23  07:37:21.000	6.768659
2017-12-23  07:37:21.500	6.768795
2017-12-23  07:37:22.000	6.768679
2017-12-23  07:37:22.500	6.768699
2017-12-23  07:37:23.000	6.768855
2017-12-23  07:37:23.500	6.768925
2017-12-23  07:37:24.000	6.76897
2017-12-23  07:37:24.500	6.769046
2017-12-23  07:37:25.000	6.769056
2017-12-23  07:37:25.500	6.769051
2017-12-23  07:37:26.000	6.769071
2017-12-23  07:37:26.500	6.769121
2017-12-23  07:37:27.000	6.769171
2017-12-23  07:37:27.500	6.769101
2017-12-23  07:37:28.000	6.769211
2017-12-23  07:37:28.500	6.769111
2017-12-23  07:37:29.000	6.769231
2017-12-23  07:37:29.500	6.769307
2017-12-23  07:37:30.000	6.769302
2017-12-23  07:37:30.500	6.769231
2017-12-23  07:37:31.000	6.769166
2017-12-23  07:37:31.500	6.768684
2017-12-23  07:37:32.000	6.768207
2017-12-23  07:37:32.500	6.767786
2017-12-23  07:37:33.000	6.7676
2017-12-23  07:37:33.500	6.767504
2017-12-23  07:37:34.000	6.767585
2017-12-23  07:37:34.500	6.767459
2017-12-23  07:37:35.000	6.767444
2017-12-23  07:37:35.500	6.767339
2017-12-23  07:37:36.000	6.767404
2017-12-23  07:37:36.500	6.7676
2017-12-23  07:37:37.000	6.767715
2017-12-23  07:37:37.500	6.767811
2017-12-23  07:37:38.000	6.767725
2017-12-23  07:37:38.500	6.767791
2017-12-23  07:37:39.000	6.767755
2017-12-23  07:37:39.500	6.767675
2017-12-23  07:37:40.000	6.767585
2017-12-23  07:37:40.500	6.767565
2017-12-23  07:37:41.000	6.767565
2017-12-23  07:37:41.500	6.767535
2017-12-23  07:37:42.000	6.767489
2017-12-23  07:37:42.500	6.767364
2017-12-23  07:37:43.000	6.767329
2017-12-23  07:37:43.500	6.767203
2017-12-23  07:37:44.000	6.767203
2017-12-23  07:37:44.500	6.767078
2017-12-23  07:37:45.000	6.767043
2017-12-23  07:37:45.500	6.767158
2017-12-23  07:37:46.000	6.767103
2017-12-23  07:37:46.500	6.767133
2017-12-23  07:37:47.000	6.767173
2017-12-23  07:37:47.500	6.767043
2017-12-23  07:37:48.000	6.767043
2017-12-23  07:37:48.500	6.766917
2017-12-23  07:37:49.000	6.766917
2017-12-23  07:37:49.500	6.766892
2017-12-23  07:37:50.000	6.766827
2017-12-23  07:37:50.500	6.766807
2017-12-23  07:37:51.000	6.766696
2017-12-23  07:37:51.500	6.766726
2017-12-23  07:37:52.000	6.766626
2017-12-23  07:37:52.500	6.766651
2017-12-23  07:37:53.000	6.766701
2017-12-23  07:37:53.500	6.766636
2017-12-23  07:37:54.000	6.766621
2017-12-23  07:37:54.500	6.76653
2017-12-23  07:37:55.000	6.766485
2017-12-23  07:37:55.500	6.76645
2017-12-23  07:37:56.000	6.766495
2017-12-23  07:37:56.500	6.766475
2017-12-23  07:37:57.000	6.76643
2017-12-23  07:37:57.500	6.76635
2017-12-23  07:37:58.000	6.76633
2017-12-23  07:37:58.500	6.7663
2017-12-23  07:37:59.000	6.766269
2017-12-23  07:37:59.500	6.766385
2017-12-23  07:38:00.000	6.766239
2017-12-23  07:38:00.500	6.766269
2017-12-23  07:38:01.000	6.766284
2017-12-23  07:38:01.500	6.7663
2017-12-23  07:38:02.000	6.766305
2017-12-23  07:38:02.500	6.766385
2017-12-23  07:38:03.000	6.766385
2017-12-23  07:38:03.500	6.766435
2017-12-23  07:38:04.000	6.766546
2017-12-23  07:38:04.500	6.766525
2017-12-23  07:38:05.000	6.766475
2017-12-23  07:38:05.500	6.76653
2017-12-23  07:38:06.000	6.76651
2017-12-23  07:38:06.500	6.76651
2017-12-23  07:38:07.000	6.766395
2017-12-23  07:38:07.500	6.76642
2017-12-23  07:38:08.000	6.766445
2017-12-23  07:38:08.500	6.76645
2017-12-23  07:38:09.000	6.766581
2017-12-23  07:38:09.500	6.766611
2017-12-23  07:38:10.000	6.766751
2017-12-23  07:38:10.500	6.766822
2017-12-23  07:38:11.000	6.766817
2017-12-23  07:38:11.500	6.766872
2017-12-23  07:38:12.000	6.766771
2017-12-23  07:38:12.500	6.766907
2017-12-23  07:38:13.000	6.766792
2017-12-23  07:38:13.500	6.766877
2017-12-23  07:38:14.000	6.766917
2017-12-23  07:38:14.500	6.767002
2017-12-23  07:38:15.000	6.767048
2017-12-23  07:38:15.500	6.767058
2017-12-23  07:38:16.000	6.767158
2017-12-23  07:38:16.500	6.767183
2017-12-23  07:38:17.000	6.767108
2017-12-23  07:38:17.500	6.767163
2017-12-23  07:38:18.000	6.767123
2017-12-23  07:38:18.500	6.767108
2017-12-23  07:38:19.000	6.767063
2017-12-23  07:38:19.500	6.766947
2017-12-23  07:38:20.000	6.766892
2017-12-23  07:38:20.500	6.766756
2017-12-23  07:38:21.000	6.766691

数据的时间间隔为半秒钟，我现在想把整理的多余数据删除，我只需要10分钟整点的数据，例如2017-12-23 07-30：00：000   2017-12-23 07-40：00：000   2017-12-23 07-50：00：000     这样的数据，那位大神能帮忙写个小程序给我。万分感谢，我是一个根本不懂编程的人，别人告诉我找编程人员帮帮忙。所以才来发帖子。

karlzhang00 发表于 2018-4-4 15:17
# -*- coding: utf-8 -*-

import xlrd,re

output:
################################
    2017-12-23 07:30:10.000
    2017-12-23 07:30:20.000
    2017-12-23 07:30:30.000
    2017-12-23 07:30:40.000
    2017-12-23 07:30:50.000
    2017-12-23 07:31:10.000
    2017-12-23 07:31:20.000
    2017-12-23 07:31:30.000
    2017-12-23 07:31:40.000
    2017-12-23 07:31:50.000
    2017-12-23 07:32:10.000
    2017-12-23 07:32:20.000
    2017-12-23 07:32:30.000
    2017-12-23 07:32:40.000
    2017-12-23 07:32:50.000
    2017-12-23 07:33:10.000
    2017-12-23 07:33:20.000
    2017-12-23 07:33:30.000
    2017-12-23 07:33:40.000
    2017-12-23 07:33:50.000

多少费用，我试试

excel写几条判断语句，过滤一下就OK啦，用不着写啥脚本了吧。。。。

uitb 发表于 2018-4-4 12:09
excel写几条判断语句，过滤一下就OK啦，用不着写啥脚本了吧。。。。

我不会啊，麻烦大神帮帮忙

乘风 发表于 2018-4-4 10:29
多少费用，我试试

你说。我也不懂   不清楚

# -*- coding: utf-8 -*-

import xlrd,re

def read_excel():
    #文件位置
    ExcelFile=xlrd.open_workbook(r'D:\test.xlsx')
    #获取目标EXCEL文件sheet名
    #print (ExcelFile.sheet_names())
    #若有多个sheet，则需要指定读取目标sheet例如读取sheet2

    sheet=ExcelFile.sheet_by_name('Sheet2')

    cols1=sheet.col_values(0)#第X列内容
    cols2=sheet.col_values(1)#第X列内容

    #获取单元格内容
    list=[]
    for i in range(sheet.nrows):
        str1=cols1[i]+' '+cols2[i]
        str2=re.findall(r'.*\d{2}:[1-6][0].000',str1)
        if len(str2)!=0 :
            list.append(str1)
    print('################################')
   
    for i in range(len(list)):
        print ('  %s'%str(list[i]))

print (read_excel())

#刚试了试，应该可以实现你需要的功能

import pandas as pd
file_info=pd.ExcelFile('test.xlsx')
df1=pd.read_excel('test.xlsx',sheetname=file_info.sheet_names,header=None,names=['time','d'])
df=pd.concat([data for data in df1.values()],ignore_index=True)
df.index=pd.to_datetime(df.time)
result=df.resample('10T').asfreq()
result=result.reset_index(drop=True)
result.to_excel('result.xlsx',index=None)

图是按照每分钟取样，10分钟就是10T

lous楼上  nb

karlzhang00 发表于 2018-4-4 15:17
# -*- coding: utf-8 -*-

import xlrd,re

我复制这个代码  修改了文件名后和页面名后运行 提示  ：the line you point at doesn't look like a valid file name followed by a line number