找回密码
 立即注册

QQ登录

只需一步,快速开始

扫一扫,访问微社区

查看: 926|回复: 16

[求助] 求助大神帮帮忙,给个小程序~!!!

2

主题

15

帖子

15

积分

贫民

积分
15
xinxin868 发表于 2018-4-4 09:51:19 | 显示全部楼层 |阅读模式
我有一个excel2013的文件,SHEET页面10-20个不等,每页面100多万行数据。
数据如下:
2017-12-23 07:30:00.0006.740223
2017-12-23  07:30:00.5006.742738
2017-12-23  07:30:01.0006.741006
2017-12-23  07:30:01.5006.74316
2017-12-23  07:30:02.0006.741403
2017-12-23  07:30:02.5006.743275
2017-12-23  07:30:03.0006.74328
2017-12-23  07:30:03.5006.7432
2017-12-23  07:30:04.0006.742964
2017-12-23  07:30:04.5006.743034
2017-12-23  07:30:05.0006.743195
2017-12-23  07:30:05.5006.743306
2017-12-23  07:30:06.0006.743632
2017-12-23  07:30:06.5006.743682
2017-12-23  07:30:07.0006.743767
2017-12-23  07:30:07.5006.743697
2017-12-23  07:30:08.0006.743808
2017-12-23  07:30:08.5006.744008
2017-12-23  07:30:09.0006.744254
2017-12-23  07:30:09.5006.74444
2017-12-23  07:30:10.0006.744536
2017-12-23  07:30:10.5006.744777
2017-12-23  07:30:11.0006.744983
2017-12-23  07:30:11.5006.745158
2017-12-23  07:30:12.0006.745369
2017-12-23  07:30:12.5006.745841
2017-12-23  07:30:13.0006.746368
2017-12-23  07:30:13.5006.74685
2017-12-23  07:30:14.0006.747111
2017-12-23  07:30:14.5006.747207
2017-12-23  07:30:15.0006.747227
2017-12-23  07:30:15.5006.747232
2017-12-23  07:30:16.0006.747126
2017-12-23  07:30:16.5006.746865
2017-12-23  07:30:17.0006.746835
2017-12-23  07:30:17.5006.747076
2017-12-23  07:30:18.0006.747192
2017-12-23  07:30:18.5006.747473
2017-12-23  07:30:19.0006.747874
2017-12-23  07:30:19.5006.748532
2017-12-23  07:30:20.0006.749069
2017-12-23  07:30:20.5006.749597
2017-12-23  07:30:21.0006.749923
2017-12-23  07:30:21.5006.750234
2017-12-23  07:30:22.0006.750279
2017-12-23  07:30:22.5006.750445
2017-12-23  07:30:23.0006.750515
2017-12-23  07:30:23.5006.750751
2017-12-23  07:30:24.0006.751063
2017-12-23  07:30:24.5006.751419
2017-12-23  07:30:25.0006.75168
2017-12-23  07:30:25.5006.751966
2017-12-23  07:30:26.0006.752257
2017-12-23  07:30:26.5006.752318
2017-12-23  07:30:27.0006.752207
2017-12-23  07:30:27.5006.752237
2017-12-23  07:30:28.0006.752222
2017-12-23  07:30:28.5006.752197
2017-12-23  07:30:29.0006.752042
2017-12-23  07:30:29.5006.751906
2017-12-23  07:30:30.0006.7516
2017-12-23  07:30:30.5006.751429
2017-12-23  07:30:31.0006.751509
2017-12-23  07:30:31.5006.751776
2017-12-23  07:30:32.0006.752117
2017-12-23  07:30:32.5006.752378
2017-12-23  07:30:33.0006.752729
2017-12-23  07:30:33.5006.753091
2017-12-23  07:30:34.0006.753472
2017-12-23  07:30:34.5006.753583
2017-12-23  07:30:35.0006.753437
2017-12-23  07:30:35.5006.753001
2017-12-23  07:30:36.0006.752654
2017-12-23  07:30:36.5006.752328
2017-12-23  07:30:37.0006.752162
2017-12-23  07:30:37.5006.751971
2017-12-23  07:30:38.0006.751695
2017-12-23  07:30:38.5006.751459
2017-12-23  07:30:39.0006.751173
2017-12-23  07:30:39.5006.750761
2017-12-23  07:30:40.0006.75055
2017-12-23  07:30:40.5006.750571
2017-12-23  07:30:41.0006.750656
2017-12-23  07:30:41.5006.750596
2017-12-23  07:30:42.0006.750606
2017-12-23  07:30:42.5006.750545
2017-12-23  07:30:43.0006.75044
2017-12-23  07:30:43.5006.75044
2017-12-23  07:30:44.0006.750495
2017-12-23  07:30:44.5006.75045
2017-12-23  07:30:45.0006.750445
2017-12-23  07:30:45.5006.750556
2017-12-23  07:30:46.0006.750596
2017-12-23  07:30:46.5006.750691
2017-12-23  07:30:47.0006.750927
2017-12-23  07:30:47.5006.751078
2017-12-23  07:30:48.0006.751128
2017-12-23  07:30:48.5006.751118
2017-12-23  07:30:49.0006.751103
2017-12-23  07:30:49.5006.750827
2017-12-23  07:30:50.0006.750535
2017-12-23  07:30:50.5006.75039
2017-12-23  07:30:51.0006.750355
2017-12-23  07:30:51.5006.750465
2017-12-23  07:30:52.0006.75036
2017-12-23  07:30:52.5006.75038
2017-12-23  07:30:53.0006.750325
2017-12-23  07:30:53.5006.750224
2017-12-23  07:30:54.0006.750209
2017-12-23  07:30:54.5006.750229
2017-12-23  07:30:55.0006.75033
2017-12-23  07:30:55.5006.75035
2017-12-23  07:30:56.0006.75034
2017-12-23  07:30:56.5006.75041
2017-12-23  07:30:57.0006.75039
2017-12-23  07:30:57.5006.750309
2017-12-23  07:30:58.0006.750224
2017-12-23  07:30:58.5006.75033
2017-12-23  07:30:59.0006.750601
2017-12-23  07:30:59.5006.750741
2017-12-23  07:31:00.0006.750847
2017-12-23  07:31:00.5006.750867
2017-12-23  07:31:01.0006.750962
2017-12-23  07:31:01.5006.750922
2017-12-23  07:31:02.0006.750892
2017-12-23  07:31:02.5006.750867
2017-12-23  07:31:03.0006.750771
2017-12-23  07:31:03.5006.750681
2017-12-23  07:31:04.0006.750691
2017-12-23  07:31:04.5006.750721
2017-12-23  07:31:05.0006.750661
2017-12-23  07:31:05.5006.750686
2017-12-23  07:31:06.0006.750701
2017-12-23  07:31:06.5006.750837
2017-12-23  07:31:07.0006.750807
2017-12-23  07:31:07.5006.750897
2017-12-23  07:31:08.0006.750902
2017-12-23  07:31:08.5006.750907
2017-12-23  07:31:09.0006.750797
2017-12-23  07:31:09.5006.750701
2017-12-23  07:31:10.0006.75052
2017-12-23  07:31:10.5006.75039
2017-12-23  07:31:11.0006.750309
2017-12-23  07:31:11.5006.750159
2017-12-23  07:31:12.0006.750013
2017-12-23  07:31:12.5006.750214
2017-12-23  07:31:13.0006.75042
2017-12-23  07:31:13.5006.750495
2017-12-23  07:31:14.0006.75048
2017-12-23  07:31:14.5006.750289
2017-12-23  07:31:15.0006.750048
2017-12-23  07:31:15.5006.749797
2017-12-23  07:31:16.0006.749546
2017-12-23  07:31:16.5006.749401
2017-12-23  07:31:17.0006.74933
2017-12-23  07:31:17.5006.749441
2017-12-23  07:31:18.0006.749521
2017-12-23  07:31:18.5006.749647
2017-12-23  07:31:19.0006.749536
2017-12-23  07:31:19.5006.749471
2017-12-23  07:31:20.0006.749215
2017-12-23  07:31:20.5006.749019
2017-12-23  07:31:21.0006.748874
2017-12-23  07:31:21.5006.748648
2017-12-23  07:31:22.0006.748361
2017-12-23  07:31:22.5006.74812
2017-12-23  07:31:23.0006.748035
2017-12-23  07:31:23.5006.748045
2017-12-23  07:31:24.0006.747925
2017-12-23  07:31:24.5006.747839
2017-12-23  07:31:25.0006.747744
2017-12-23  07:31:25.5006.747784
2017-12-23  07:31:26.0006.747834
2017-12-23  07:31:26.5006.747819
2017-12-23  07:31:27.0006.747804
2017-12-23  07:31:27.5006.747779
2017-12-23  07:31:28.0006.747689
2017-12-23  07:31:28.5006.747679
2017-12-23  07:31:29.0006.747654
2017-12-23  07:31:29.5006.747684
2017-12-23  07:31:30.0006.747603
2017-12-23  07:31:30.5006.747618
2017-12-23  07:31:31.0006.747553
2017-12-23  07:31:31.5006.747523
2017-12-23  07:31:32.0006.747377
2017-12-23  07:31:32.5006.747267
2017-12-23  07:31:33.0006.747222
2017-12-23  07:31:33.5006.747001
2017-12-23  07:31:34.0006.74687
2017-12-23  07:31:34.5006.746745
2017-12-23  07:31:35.0006.746715
2017-12-23  07:31:35.5006.746885
2017-12-23  07:31:36.0006.747192
2017-12-23  07:31:36.5006.747874
2017-12-23  07:31:37.0006.749034
2017-12-23  07:31:37.5006.750224
2017-12-23  07:31:38.0006.751238
2017-12-23  07:31:38.5006.751625
2017-12-23  07:31:39.0006.751555
2017-12-23  07:31:39.5006.751519
2017-12-23  07:31:40.0006.751314
2017-12-23  07:31:40.5006.751113
2017-12-23  07:31:41.0006.750676
2017-12-23  07:31:41.5006.750023
2017-12-23  07:31:42.0006.749351
2017-12-23  07:31:42.5006.748758
2017-12-23  07:31:43.0006.748361
2017-12-23  07:31:43.5006.74807
2017-12-23  07:31:44.0006.747955
2017-12-23  07:31:44.5006.748095
2017-12-23  07:31:45.0006.748286
2017-12-23  07:31:45.5006.748326
2017-12-23  07:31:46.0006.748146
2017-12-23  07:31:46.5006.747874
2017-12-23  07:31:47.0006.747518
2017-12-23  07:31:47.5006.747357
2017-12-23  07:31:48.0006.747332
2017-12-23  07:31:48.5006.747413
2017-12-23  07:31:49.0006.747819
2017-12-23  07:31:49.5006.748382
2017-12-23  07:31:50.0006.748904
2017-12-23  07:31:50.5006.74931
2017-12-23  07:31:51.0006.749556
2017-12-23  07:31:51.5006.749617
2017-12-23  07:31:52.0006.749767
2017-12-23  07:31:52.5006.749802
2017-12-23  07:31:53.0006.749958
2017-12-23  07:31:53.5006.750134
2017-12-23  07:31:54.0006.750525
2017-12-23  07:31:54.5006.751098
2017-12-23  07:31:55.0006.7517
2017-12-23  07:31:55.5006.752132
2017-12-23  07:31:56.0006.752629
2017-12-23  07:31:56.5006.753141
2017-12-23  07:31:57.0006.753111
2017-12-23  07:31:57.5006.753001
2017-12-23  07:31:58.0006.752885
2017-12-23  07:31:58.5006.753051
2017-12-23  07:31:59.0006.753247
2017-12-23  07:31:59.5006.753673
2017-12-23  07:32:00.0006.754331
2017-12-23  07:32:00.5006.754708
2017-12-23  07:32:01.0006.754878
2017-12-23  07:32:01.5006.754853
2017-12-23  07:32:02.0006.754903
2017-12-23  07:32:02.5006.755064
2017-12-23  07:32:03.0006.755265
2017-12-23  07:32:03.5006.755676
2017-12-23  07:32:04.0006.756168
2017-12-23  07:32:04.5006.756816
2017-12-23  07:32:05.0006.757599
2017-12-23  07:32:05.5006.758563
2017-12-23  07:32:06.0006.759367
2017-12-23  07:32:06.5006.759994
2017-12-23  07:32:07.0006.760526
2017-12-23  07:32:07.5006.761099
2017-12-23  07:32:08.0006.761616
2017-12-23  07:32:08.5006.761922
2017-12-23  07:32:09.0006.761997
2017-12-23  07:32:09.5006.761872
2017-12-23  07:32:10.0006.761666
2017-12-23  07:32:10.5006.76142
2017-12-23  07:32:11.0006.761254
2017-12-23  07:32:11.5006.760968
2017-12-23  07:32:12.0006.760757
2017-12-23  07:32:12.5006.760496
2017-12-23  07:32:13.0006.760396
2017-12-23  07:32:13.5006.760345
2017-12-23  07:32:14.0006.760481
2017-12-23  07:32:14.5006.760782
2017-12-23  07:32:15.0006.761023
2017-12-23  07:32:15.5006.761189
2017-12-23  07:32:16.0006.76137
2017-12-23  07:32:16.5006.761545
2017-12-23  07:32:17.0006.761832
2017-12-23  07:32:17.5006.762027
2017-12-23  07:32:18.0006.762113
2017-12-23  07:32:18.5006.762118
2017-12-23  07:32:19.0006.761967
2017-12-23  07:32:19.5006.761681
2017-12-23  07:32:20.0006.76149
2017-12-23  07:32:20.5006.761329
2017-12-23  07:32:21.0006.761229
2017-12-23  07:32:21.5006.761033
2017-12-23  07:32:22.0006.760812
2017-12-23  07:32:22.5006.760677
2017-12-23  07:32:23.0006.760436
2017-12-23  07:32:23.5006.760245
2017-12-23  07:32:24.0006.760094
2017-12-23  07:32:24.5006.759929
2017-12-23  07:32:25.0006.759879
2017-12-23  07:32:25.5006.759803
2017-12-23  07:32:26.0006.759733
2017-12-23  07:32:26.5006.759597
2017-12-23  07:32:27.0006.759597
2017-12-23  07:32:27.5006.759497
2017-12-23  07:32:28.0006.759417
2017-12-23  07:32:28.5006.759196
2017-12-23  07:32:29.0006.759005
2017-12-23  07:32:29.5006.758729
2017-12-23  07:32:30.0006.758724
2017-12-23  07:32:30.5006.758498
2017-12-23  07:32:31.0006.758563
2017-12-23  07:32:31.5006.758518
2017-12-23  07:32:32.0006.758503
2017-12-23  07:32:32.5006.758433
2017-12-23  07:32:33.0006.758192
2017-12-23  07:32:33.5006.758071
2017-12-23  07:32:34.0006.75787
2017-12-23  07:32:34.5006.758006
2017-12-23  07:32:35.0006.758277
2017-12-23  07:32:35.5006.758322
2017-12-23  07:32:36.0006.758327
2017-12-23  07:32:36.5006.758473
2017-12-23  07:32:37.0006.758468
2017-12-23  07:32:37.5006.758523
2017-12-23  07:32:38.0006.758518
2017-12-23  07:32:38.5006.758503
2017-12-23  07:32:39.0006.758543
2017-12-23  07:32:39.5006.758608
2017-12-23  07:32:40.0006.759121
2017-12-23  07:32:40.5006.759773
2017-12-23  07:32:41.0006.760456
2017-12-23  07:32:41.5006.760953
2017-12-23  07:32:42.0006.761204
2017-12-23  07:32:42.5006.761475
2017-12-23  07:32:43.0006.761626
2017-12-23  07:32:43.5006.761862
2017-12-23  07:32:44.0006.761912
2017-12-23  07:32:44.5006.762083
2017-12-23  07:32:45.0006.762228
2017-12-23  07:32:45.5006.762344
2017-12-23  07:32:46.0006.762575
2017-12-23  07:32:46.5006.762715
2017-12-23  07:32:47.0006.762956
2017-12-23  07:32:47.5006.763197
2017-12-23  07:32:48.0006.763247
2017-12-23  07:32:48.5006.763287
2017-12-23  07:32:49.0006.763353
2017-12-23  07:32:49.5006.763604
2017-12-23  07:32:50.0006.763749
2017-12-23  07:32:50.5006.763905
2017-12-23  07:32:51.0006.76394
2017-12-23  07:32:51.5006.764055
2017-12-23  07:32:52.0006.76401
2017-12-23  07:32:52.5006.764035
2017-12-23  07:32:53.0006.76384
2017-12-23  07:32:53.5006.763659
2017-12-23  07:32:54.0006.763659
2017-12-23  07:32:54.5006.763558
2017-12-23  07:32:55.0006.763538
2017-12-23  07:32:55.5006.763478
2017-12-23  07:32:56.0006.763318
2017-12-23  07:32:56.5006.763267
2017-12-23  07:32:57.0006.763182
2017-12-23  07:32:57.5006.763222
2017-12-23  07:32:58.0006.763237
2017-12-23  07:32:58.5006.763302
2017-12-23  07:32:59.0006.763378
2017-12-23  07:32:59.5006.763528
2017-12-23  07:33:00.0006.763789
2017-12-23  07:33:00.5006.764121
2017-12-23  07:33:01.0006.764553
2017-12-23  07:33:01.5006.764949
2017-12-23  07:33:02.0006.76515
2017-12-23  07:33:02.5006.765401
2017-12-23  07:33:03.0006.765547
2017-12-23  07:33:03.5006.765567
2017-12-23  07:33:04.0006.765361
2017-12-23  07:33:04.5006.76517
2017-12-23  07:33:05.0006.76526
2017-12-23  07:33:05.5006.765416
2017-12-23  07:33:06.0006.765536
2017-12-23  07:33:06.5006.765692
2017-12-23  07:33:07.0006.765712
2017-12-23  07:33:07.5006.766129
2017-12-23  07:33:08.0006.766701
2017-12-23  07:33:08.5006.767268
2017-12-23  07:33:09.0006.767735
2017-12-23  07:33:09.5006.768122
2017-12-23  07:33:10.0006.768468
2017-12-23  07:33:10.5006.768604
2017-12-23  07:33:11.0006.768574
2017-12-23  07:33:11.5006.768734
2017-12-23  07:33:12.0006.768704
2017-12-23  07:33:12.5006.768609
2017-12-23  07:33:13.0006.768488
2017-12-23  07:33:13.5006.768453
2017-12-23  07:33:14.0006.768363
2017-12-23  07:33:14.5006.768378
2017-12-23  07:33:15.0006.768192
2017-12-23  07:33:15.5006.768001
2017-12-23  07:33:16.0006.76774
2017-12-23  07:33:16.5006.76759
2017-12-23  07:33:17.0006.767504
2017-12-23  07:33:17.5006.767504
2017-12-23  07:33:18.0006.767509
2017-12-23  07:33:18.5006.767675
2017-12-23  07:33:19.0006.76775
2017-12-23  07:33:19.5006.767755
2017-12-23  07:33:20.0006.767725
2017-12-23  07:33:20.5006.76767
2017-12-23  07:33:21.0006.767615
2017-12-23  07:33:21.5006.767565
2017-12-23  07:33:22.0006.767524
2017-12-23  07:33:22.5006.767635
2017-12-23  07:33:23.0006.767474
2017-12-23  07:33:23.5006.767414
2017-12-23  07:33:24.0006.767529
2017-12-23  07:33:24.5006.767434
2017-12-23  07:33:25.0006.767474
2017-12-23  07:33:25.5006.767509
2017-12-23  07:33:26.0006.767585
2017-12-23  07:33:26.5006.767645
2017-12-23  07:33:27.0006.76759
2017-12-23  07:33:27.5006.76759
2017-12-23  07:33:28.0006.767585
2017-12-23  07:33:28.5006.767575
2017-12-23  07:33:29.0006.767585
2017-12-23  07:33:29.5006.767625
2017-12-23  07:33:30.0006.76758
2017-12-23  07:33:30.5006.76763
2017-12-23  07:33:31.0006.767655
2017-12-23  07:33:31.5006.76758
2017-12-23  07:33:32.0006.767645
2017-12-23  07:33:32.5006.767585
2017-12-23  07:33:33.0006.767585
2017-12-23  07:33:33.5006.767625
2017-12-23  07:33:34.0006.76773
2017-12-23  07:33:34.5006.767655
2017-12-23  07:33:35.0006.76774
2017-12-23  07:33:35.5006.767866
2017-12-23  07:33:36.0006.767921
2017-12-23  07:33:36.5006.767981
2017-12-23  07:33:37.0006.768107
2017-12-23  07:33:37.5006.768172
2017-12-23  07:33:38.0006.768227
2017-12-23  07:33:38.5006.768277
2017-12-23  07:33:39.0006.768368
2017-12-23  07:33:39.5006.768473
2017-12-23  07:33:40.0006.768669
2017-12-23  07:33:40.5006.76879
2017-12-23  07:33:41.0006.768885
2017-12-23  07:33:41.5006.768975
2017-12-23  07:33:42.0006.7689
2017-12-23  07:33:42.5006.768895
2017-12-23  07:33:43.0006.769031
2017-12-23  07:33:43.5006.769056
2017-12-23  07:33:44.0006.769266
2017-12-23  07:33:44.5006.769362
2017-12-23  07:33:45.0006.769477
2017-12-23  07:33:45.5006.769548
2017-12-23  07:33:46.0006.769683
2017-12-23  07:33:46.5006.769723
2017-12-23  07:33:47.0006.769703
2017-12-23  07:33:47.5006.769648
2017-12-23  07:33:48.0006.769588
2017-12-23  07:33:48.5006.769713
2017-12-23  07:33:49.0006.769678
2017-12-23  07:33:49.5006.769633
2017-12-23  07:33:50.0006.769558
2017-12-23  07:33:50.5006.769522
2017-12-23  07:33:51.0006.769578
2017-12-23  07:33:51.5006.769733
2017-12-23  07:33:52.0006.769854
2017-12-23  07:33:52.5006.770065
2017-12-23  07:33:53.0006.77026
2017-12-23  07:33:53.5006.770617
2017-12-23  07:33:54.0006.770983
2017-12-23  07:33:54.5006.771249
2017-12-23  07:33:55.0006.771505
2017-12-23  07:33:55.5006.771601
2017-12-23  07:33:56.0006.771596
2017-12-23  07:33:56.5006.771686
2017-12-23  07:33:57.0006.771847
2017-12-23  07:33:57.5006.771962
2017-12-23  07:33:58.0006.772083
2017-12-23  07:33:58.5006.772073
2017-12-23  07:33:59.0006.772113
2017-12-23  07:33:59.5006.771987
2017-12-23  07:34:00.0006.771907
2017-12-23  07:34:00.5006.771782
2017-12-23  07:34:01.0006.771581
2017-12-23  07:34:01.5006.771475
2017-12-23  07:34:02.0006.77145
2017-12-23  07:34:02.5006.771475
2017-12-23  07:34:03.0006.771475
2017-12-23  07:34:03.5006.77151
2017-12-23  07:34:04.0006.77139
2017-12-23  07:34:04.5006.771435
2017-12-23  07:34:05.0006.771385
2017-12-23  07:34:05.5006.77145
2017-12-23  07:34:06.0006.77149
2017-12-23  07:34:06.5006.771405
2017-12-23  07:34:07.0006.771455
2017-12-23  07:34:07.5006.771455
2017-12-23  07:34:08.0006.771475
2017-12-23  07:34:08.5006.77152
2017-12-23  07:34:09.0006.77147
2017-12-23  07:34:09.5006.77149
2017-12-23  07:34:10.0006.771425
2017-12-23  07:34:10.5006.77142
2017-12-23  07:34:11.0006.771435
2017-12-23  07:34:11.5006.77146
2017-12-23  07:34:12.0006.77144
2017-12-23  07:34:12.5006.771541
2017-12-23  07:34:13.0006.771561
2017-12-23  07:34:13.5006.771525
2017-12-23  07:34:14.0006.771546
2017-12-23  07:34:14.5006.771551
2017-12-23  07:34:15.0006.771586
2017-12-23  07:34:15.5006.771606
2017-12-23  07:34:16.0006.771616
2017-12-23  07:34:16.5006.771566
2017-12-23  07:34:17.0006.771616
2017-12-23  07:34:17.5006.771556
2017-12-23  07:34:18.0006.77151
2017-12-23  07:34:18.5006.771485
2017-12-23  07:34:19.0006.771495
2017-12-23  07:34:19.5006.771465
2017-12-23  07:34:20.0006.771536
2017-12-23  07:34:20.5006.771546
2017-12-23  07:34:21.0006.77147
2017-12-23  07:34:21.5006.771546
2017-12-23  07:34:22.0006.771551
2017-12-23  07:34:22.5006.771561
2017-12-23  07:34:23.0006.771556
2017-12-23  07:34:23.5006.771621
2017-12-23  07:34:24.0006.771556
2017-12-23  07:34:24.5006.771611
2017-12-23  07:34:25.0006.771621
2017-12-23  07:34:25.5006.771656
2017-12-23  07:34:26.0006.771696
2017-12-23  07:34:26.5006.771651
2017-12-23  07:34:27.0006.771616
2017-12-23  07:34:27.5006.771646
2017-12-23  07:34:28.0006.771656
2017-12-23  07:34:28.5006.771591
2017-12-23  07:34:29.0006.771651
2017-12-23  07:34:29.5006.771586
2017-12-23  07:34:30.0006.771485
2017-12-23  07:34:30.5006.77143
2017-12-23  07:34:31.0006.771355
2017-12-23  07:34:31.5006.77132
2017-12-23  07:34:32.0006.771264
2017-12-23  07:34:32.5006.771194
2017-12-23  07:34:33.0006.771189
2017-12-23  07:34:33.5006.771169
2017-12-23  07:34:34.0006.771119
2017-12-23  07:34:34.5006.771018
2017-12-23  07:34:35.0006.770958
2017-12-23  07:34:35.5006.770953
2017-12-23  07:34:36.0006.770963
2017-12-23  07:34:36.5006.770993
2017-12-23  07:34:37.0006.771013
2017-12-23  07:34:37.5006.771003
2017-12-23  07:34:38.0006.771069
2017-12-23  07:34:38.5006.771069
2017-12-23  07:34:39.0006.771199
2017-12-23  07:34:39.5006.771069
2017-12-23  07:34:40.0006.771144
2017-12-23  07:34:40.5006.771209
2017-12-23  07:34:41.0006.771214
2017-12-23  07:34:41.5006.771249
2017-12-23  07:34:42.0006.771219
2017-12-23  07:34:42.5006.771174
2017-12-23  07:34:43.0006.771164
2017-12-23  07:34:43.5006.771154
2017-12-23  07:34:44.0006.771234
2017-12-23  07:34:44.5006.771159
2017-12-23  07:34:45.0006.771149
2017-12-23  07:34:45.5006.771179
2017-12-23  07:34:46.0006.771139
2017-12-23  07:34:46.5006.771229
2017-12-23  07:34:47.0006.771184
2017-12-23  07:34:47.5006.771194
2017-12-23  07:34:48.0006.771239
2017-12-23  07:34:48.5006.771219
2017-12-23  07:34:49.0006.771254
2017-12-23  07:34:49.5006.771264
2017-12-23  07:34:50.0006.771325
2017-12-23  07:34:50.5006.771305
2017-12-23  07:34:51.0006.771244
2017-12-23  07:34:51.5006.771199
2017-12-23  07:34:52.0006.771179
2017-12-23  07:34:52.5006.771164
2017-12-23  07:34:53.0006.771139
2017-12-23  07:34:53.5006.771144
2017-12-23  07:34:54.0006.771164
2017-12-23  07:34:54.5006.771305
2017-12-23  07:34:55.0006.771209
2017-12-23  07:34:55.5006.771199
2017-12-23  07:34:56.0006.771199
2017-12-23  07:34:56.5006.77128
2017-12-23  07:34:57.0006.771244
2017-12-23  07:34:57.5006.771264
2017-12-23  07:34:58.0006.771264
2017-12-23  07:34:58.5006.771234
2017-12-23  07:34:59.0006.771174
2017-12-23  07:34:59.5006.771234
2017-12-23  07:35:00.0006.771244
2017-12-23  07:35:00.5006.771219
2017-12-23  07:35:01.0006.771194
2017-12-23  07:35:01.5006.771184
2017-12-23  07:35:02.0006.771159
2017-12-23  07:35:02.5006.771204
2017-12-23  07:35:03.0006.771239
2017-12-23  07:35:03.5006.771149
2017-12-23  07:35:04.0006.771214
2017-12-23  07:35:04.5006.771134
2017-12-23  07:35:05.0006.771154
2017-12-23  07:35:05.5006.771174
2017-12-23  07:35:06.0006.771209
2017-12-23  07:35:06.5006.771089
2017-12-23  07:35:07.0006.771054
2017-12-23  07:35:07.5006.771134
2017-12-23  07:35:08.0006.771104
2017-12-23  07:35:08.5006.771013
2017-12-23  07:35:09.0006.771069
2017-12-23  07:35:09.5006.771069
2017-12-23  07:35:10.0006.771034
2017-12-23  07:35:10.5006.770968
2017-12-23  07:35:11.0006.770878
2017-12-23  07:35:11.5006.770848
2017-12-23  07:35:12.0006.770838
2017-12-23  07:35:12.5006.770777
2017-12-23  07:35:13.0006.770858
2017-12-23  07:35:13.5006.770803
2017-12-23  07:35:14.0006.770793
2017-12-23  07:35:14.5006.770752
2017-12-23  07:35:15.0006.770823
2017-12-23  07:35:15.5006.770757
2017-12-23  07:35:16.0006.770672
2017-12-23  07:35:16.5006.770607
2017-12-23  07:35:17.0006.770667
2017-12-23  07:35:17.5006.770697
2017-12-23  07:35:18.0006.770662
2017-12-23  07:35:18.5006.770677
2017-12-23  07:35:19.0006.770622
2017-12-23  07:35:19.5006.770657
2017-12-23  07:35:20.0006.770612
2017-12-23  07:35:20.5006.770607
2017-12-23  07:35:21.0006.770597
2017-12-23  07:35:21.5006.770617
2017-12-23  07:35:22.0006.770632
2017-12-23  07:35:22.5006.770717
2017-12-23  07:35:23.0006.770687
2017-12-23  07:35:23.5006.770667
2017-12-23  07:35:24.0006.770557
2017-12-23  07:35:24.5006.770486
2017-12-23  07:35:25.0006.770481
2017-12-23  07:35:25.5006.770552
2017-12-23  07:35:26.0006.770496
2017-12-23  07:35:26.5006.770532
2017-12-23  07:35:27.0006.770481
2017-12-23  07:35:27.5006.770451
2017-12-23  07:35:28.0006.770486
2017-12-23  07:35:28.5006.770481
2017-12-23  07:35:29.0006.770421
2017-12-23  07:35:29.5006.770516
2017-12-23  07:35:30.0006.770486
2017-12-23  07:35:30.5006.770547
2017-12-23  07:35:31.0006.770486
2017-12-23  07:35:31.5006.770441
2017-12-23  07:35:32.0006.770456
2017-12-23  07:35:32.5006.770381
2017-12-23  07:35:33.0006.770366
2017-12-23  07:35:33.5006.770431
2017-12-23  07:35:34.0006.770461
2017-12-23  07:35:34.5006.770391
2017-12-23  07:35:35.0006.770461
2017-12-23  07:35:35.5006.770396
2017-12-23  07:35:36.0006.770501
2017-12-23  07:35:36.5006.770376
2017-12-23  07:35:37.0006.770441
2017-12-23  07:35:37.5006.770481
2017-12-23  07:35:38.0006.770466
2017-12-23  07:35:38.5006.770446
2017-12-23  07:35:39.0006.770532
2017-12-23  07:35:39.5006.770481
2017-12-23  07:35:40.0006.770486
2017-12-23  07:35:40.5006.770471
2017-12-23  07:35:41.0006.770451
2017-12-23  07:35:41.5006.770537
2017-12-23  07:35:42.0006.770426
2017-12-23  07:35:42.5006.770577
2017-12-23  07:35:43.0006.770587
2017-12-23  07:35:43.5006.770798
2017-12-23  07:35:44.0006.771089
2017-12-23  07:35:44.5006.771315
2017-12-23  07:35:45.0006.771445
2017-12-23  07:35:45.5006.771561
2017-12-23  07:35:46.0006.77148
2017-12-23  07:35:46.5006.771616
2017-12-23  07:35:47.0006.771711
2017-12-23  07:35:47.5006.771852
2017-12-23  07:35:48.0006.772098
2017-12-23  07:35:48.5006.772294
2017-12-23  07:35:49.0006.772444
2017-12-23  07:35:49.5006.772745
2017-12-23  07:35:50.0006.773097
2017-12-23  07:35:50.5006.773614
2017-12-23  07:35:51.0006.774056
2017-12-23  07:35:51.5006.774367
2017-12-23  07:35:52.0006.774507
2017-12-23  07:35:52.5006.774377
2017-12-23  07:35:53.0006.774281
2017-12-23  07:35:53.5006.774035
2017-12-23  07:35:54.0006.77384
2017-12-23  07:35:54.5006.773634
2017-12-23  07:35:55.0006.773277
2017-12-23  07:35:55.5006.773117
2017-12-23  07:35:56.0006.773021
2017-12-23  07:35:56.5006.773052
2017-12-23  07:35:57.0006.773132
2017-12-23  07:35:57.5006.773157
2017-12-23  07:35:58.0006.773147
2017-12-23  07:35:58.5006.773227
2017-12-23  07:35:59.0006.773348
2017-12-23  07:35:59.5006.773428
2017-12-23  07:36:00.0006.773659
2017-12-23  07:36:00.5006.773624
2017-12-23  07:36:01.0006.773488
2017-12-23  07:36:01.5006.773353
2017-12-23  07:36:02.0006.773162
2017-12-23  07:36:02.5006.773047
2017-12-23  07:36:03.0006.773082
2017-12-23  07:36:03.5006.773037
2017-12-23  07:36:04.0006.772951
2017-12-23  07:36:04.5006.772946
2017-12-23  07:36:05.0006.772936
2017-12-23  07:36:05.5006.772881
2017-12-23  07:36:06.0006.772971
2017-12-23  07:36:06.5006.772986
2017-12-23  07:36:07.0006.773097
2017-12-23  07:36:07.5006.773077
2017-12-23  07:36:08.0006.773142
2017-12-23  07:36:08.5006.773222
2017-12-23  07:36:09.0006.773182
2017-12-23  07:36:09.5006.773011
2017-12-23  07:36:10.0006.772921
2017-12-23  07:36:10.5006.772896
2017-12-23  07:36:11.0006.773077
2017-12-23  07:36:11.5006.773157
2017-12-23  07:36:12.0006.773413
2017-12-23  07:36:12.5006.773483
2017-12-23  07:36:13.0006.773584
2017-12-23  07:36:13.5006.773624
2017-12-23  07:36:14.0006.773739
2017-12-23  07:36:14.5006.773865
2017-12-23  07:36:15.0006.773639
2017-12-23  07:36:15.5006.773383
2017-12-23  07:36:16.0006.773147
2017-12-23  07:36:16.5006.773001
2017-12-23  07:36:17.0006.772876
2017-12-23  07:36:17.5006.772685
2017-12-23  07:36:18.0006.772615
2017-12-23  07:36:18.5006.772449
2017-12-23  07:36:19.0006.772243
2017-12-23  07:36:19.5006.772163
2017-12-23  07:36:20.0006.772143
2017-12-23  07:36:20.5006.772133
2017-12-23  07:36:21.0006.772289
2017-12-23  07:36:21.5006.772359
2017-12-23  07:36:22.0006.772439
2017-12-23  07:36:22.5006.772339
2017-12-23  07:36:23.0006.772263
2017-12-23  07:36:23.5006.772143
2017-12-23  07:36:24.0006.772103
2017-12-23  07:36:24.5006.772078
2017-12-23  07:36:25.0006.772163
2017-12-23  07:36:25.5006.772093
2017-12-23  07:36:26.0006.772113
2017-12-23  07:36:26.5006.772068
2017-12-23  07:36:27.0006.771967
2017-12-23  07:36:27.5006.771967
2017-12-23  07:36:28.0006.771947
2017-12-23  07:36:28.5006.771771
2017-12-23  07:36:29.0006.771741
2017-12-23  07:36:29.5006.771716
2017-12-23  07:36:30.0006.771586
2017-12-23  07:36:30.5006.771641
2017-12-23  07:36:31.0006.771571
2017-12-23  07:36:31.5006.771596
2017-12-23  07:36:32.0006.771651
2017-12-23  07:36:32.5006.771766
2017-12-23  07:36:33.0006.771751
2017-12-23  07:36:33.5006.771847
2017-12-23  07:36:34.0006.771867
2017-12-23  07:36:34.5006.771872
2017-12-23  07:36:35.0006.771877
2017-12-23  07:36:35.5006.771927
2017-12-23  07:36:36.0006.771947
2017-12-23  07:36:36.5006.771972
2017-12-23  07:36:37.0006.771967
2017-12-23  07:36:37.5006.771937
2017-12-23  07:36:38.0006.771917
2017-12-23  07:36:38.5006.772083
2017-12-23  07:36:39.0006.772158
2017-12-23  07:36:39.5006.772278
2017-12-23  07:36:40.0006.772304
2017-12-23  07:36:40.5006.772143
2017-12-23  07:36:41.0006.772038
2017-12-23  07:36:41.5006.771897
2017-12-23  07:36:42.0006.771792
2017-12-23  07:36:42.5006.771666
2017-12-23  07:36:43.0006.771651
2017-12-23  07:36:43.5006.771621
2017-12-23  07:36:44.0006.771626
2017-12-23  07:36:44.5006.771596
2017-12-23  07:36:45.0006.771736
2017-12-23  07:36:45.5006.771721
2017-12-23  07:36:46.0006.771771
2017-12-23  07:36:46.5006.771751
2017-12-23  07:36:47.0006.771787
2017-12-23  07:36:47.5006.771651
2017-12-23  07:36:48.0006.771751
2017-12-23  07:36:48.5006.771741
2017-12-23  07:36:49.0006.771812
2017-12-23  07:36:49.5006.771716
2017-12-23  07:36:50.0006.771681
2017-12-23  07:36:50.5006.771761
2017-12-23  07:36:51.0006.771782
2017-12-23  07:36:51.5006.771857
2017-12-23  07:36:52.0006.771842
2017-12-23  07:36:52.5006.771927
2017-12-23  07:36:53.0006.772048
2017-12-23  07:36:53.5006.772093
2017-12-23  07:36:54.0006.772143
2017-12-23  07:36:54.5006.772133
2017-12-23  07:36:55.0006.772198
2017-12-23  07:36:55.5006.772278
2017-12-23  07:36:56.0006.772399
2017-12-23  07:36:56.5006.772374
2017-12-23  07:36:57.0006.772439
2017-12-23  07:36:57.5006.772359
2017-12-23  07:36:58.0006.772344
2017-12-23  07:36:58.5006.772354
2017-12-23  07:36:59.0006.772233
2017-12-23  07:36:59.5006.772128
2017-12-23  07:37:00.0006.772128
2017-12-23  07:37:00.5006.772078
2017-12-23  07:37:01.0006.771997
2017-12-23  07:37:01.5006.771967
2017-12-23  07:37:02.0006.771927
2017-12-23  07:37:02.5006.771882
2017-12-23  07:37:03.0006.771887
2017-12-23  07:37:03.5006.771847
2017-12-23  07:37:04.0006.771842
2017-12-23  07:37:04.5006.771867
2017-12-23  07:37:05.0006.771847
2017-12-23  07:37:05.5006.771817
2017-12-23  07:37:06.0006.771907
2017-12-23  07:37:06.5006.771837
2017-12-23  07:37:07.0006.771807
2017-12-23  07:37:07.5006.771736
2017-12-23  07:37:08.0006.771485
2017-12-23  07:37:08.5006.771089
2017-12-23  07:37:09.0006.770672
2017-12-23  07:37:09.5006.770441
2017-12-23  07:37:10.0006.770371
2017-12-23  07:37:10.5006.770225
2017-12-23  07:37:11.0006.770165
2017-12-23  07:37:11.5006.770045
2017-12-23  07:37:12.0006.769974
2017-12-23  07:37:12.5006.77009
2017-12-23  07:37:13.0006.77007
2017-12-23  07:37:13.5006.77016
2017-12-23  07:37:14.0006.770095
2017-12-23  07:37:14.5006.769954
2017-12-23  07:37:15.0006.769854
2017-12-23  07:37:15.5006.769613
2017-12-23  07:37:16.0006.769206
2017-12-23  07:37:16.5006.768985
2017-12-23  07:37:17.0006.768785
2017-12-23  07:37:17.5006.768729
2017-12-23  07:37:18.0006.768729
2017-12-23  07:37:18.5006.76882
2017-12-23  07:37:19.0006.768785
2017-12-23  07:37:19.5006.76883
2017-12-23  07:37:20.0006.768739
2017-12-23  07:37:20.5006.768744
2017-12-23  07:37:21.0006.768659
2017-12-23  07:37:21.5006.768795
2017-12-23  07:37:22.0006.768679
2017-12-23  07:37:22.5006.768699
2017-12-23  07:37:23.0006.768855
2017-12-23  07:37:23.5006.768925
2017-12-23  07:37:24.0006.76897
2017-12-23  07:37:24.5006.769046
2017-12-23  07:37:25.0006.769056
2017-12-23  07:37:25.5006.769051
2017-12-23  07:37:26.0006.769071
2017-12-23  07:37:26.5006.769121
2017-12-23  07:37:27.0006.769171
2017-12-23  07:37:27.5006.769101
2017-12-23  07:37:28.0006.769211
2017-12-23  07:37:28.5006.769111
2017-12-23  07:37:29.0006.769231
2017-12-23  07:37:29.5006.769307
2017-12-23  07:37:30.0006.769302
2017-12-23  07:37:30.5006.769231
2017-12-23  07:37:31.0006.769166
2017-12-23  07:37:31.5006.768684
2017-12-23  07:37:32.0006.768207
2017-12-23  07:37:32.5006.767786
2017-12-23  07:37:33.0006.7676
2017-12-23  07:37:33.5006.767504
2017-12-23  07:37:34.0006.767585
2017-12-23  07:37:34.5006.767459
2017-12-23  07:37:35.0006.767444
2017-12-23  07:37:35.5006.767339
2017-12-23  07:37:36.0006.767404
2017-12-23  07:37:36.5006.7676
2017-12-23  07:37:37.0006.767715
2017-12-23  07:37:37.5006.767811
2017-12-23  07:37:38.0006.767725
2017-12-23  07:37:38.5006.767791
2017-12-23  07:37:39.0006.767755
2017-12-23  07:37:39.5006.767675
2017-12-23  07:37:40.0006.767585
2017-12-23  07:37:40.5006.767565
2017-12-23  07:37:41.0006.767565
2017-12-23  07:37:41.5006.767535
2017-12-23  07:37:42.0006.767489
2017-12-23  07:37:42.5006.767364
2017-12-23  07:37:43.0006.767329
2017-12-23  07:37:43.5006.767203
2017-12-23  07:37:44.0006.767203
2017-12-23  07:37:44.5006.767078
2017-12-23  07:37:45.0006.767043
2017-12-23  07:37:45.5006.767158
2017-12-23  07:37:46.0006.767103
2017-12-23  07:37:46.5006.767133
2017-12-23  07:37:47.0006.767173
2017-12-23  07:37:47.5006.767043
2017-12-23  07:37:48.0006.767043
2017-12-23  07:37:48.5006.766917
2017-12-23  07:37:49.0006.766917
2017-12-23  07:37:49.5006.766892
2017-12-23  07:37:50.0006.766827
2017-12-23  07:37:50.5006.766807
2017-12-23  07:37:51.0006.766696
2017-12-23  07:37:51.5006.766726
2017-12-23  07:37:52.0006.766626
2017-12-23  07:37:52.5006.766651
2017-12-23  07:37:53.0006.766701
2017-12-23  07:37:53.5006.766636
2017-12-23  07:37:54.0006.766621
2017-12-23  07:37:54.5006.76653
2017-12-23  07:37:55.0006.766485
2017-12-23  07:37:55.5006.76645
2017-12-23  07:37:56.0006.766495
2017-12-23  07:37:56.5006.766475
2017-12-23  07:37:57.0006.76643
2017-12-23  07:37:57.5006.76635
2017-12-23  07:37:58.0006.76633
2017-12-23  07:37:58.5006.7663
2017-12-23  07:37:59.0006.766269
2017-12-23  07:37:59.5006.766385
2017-12-23  07:38:00.0006.766239
2017-12-23  07:38:00.5006.766269
2017-12-23  07:38:01.0006.766284
2017-12-23  07:38:01.5006.7663
2017-12-23  07:38:02.0006.766305
2017-12-23  07:38:02.5006.766385
2017-12-23  07:38:03.0006.766385
2017-12-23  07:38:03.5006.766435
2017-12-23  07:38:04.0006.766546
2017-12-23  07:38:04.5006.766525
2017-12-23  07:38:05.0006.766475
2017-12-23  07:38:05.5006.76653
2017-12-23  07:38:06.0006.76651
2017-12-23  07:38:06.5006.76651
2017-12-23  07:38:07.0006.766395
2017-12-23  07:38:07.5006.76642
2017-12-23  07:38:08.0006.766445
2017-12-23  07:38:08.5006.76645
2017-12-23  07:38:09.0006.766581
2017-12-23  07:38:09.5006.766611
2017-12-23  07:38:10.0006.766751
2017-12-23  07:38:10.5006.766822
2017-12-23  07:38:11.0006.766817
2017-12-23  07:38:11.5006.766872
2017-12-23  07:38:12.0006.766771
2017-12-23  07:38:12.5006.766907
2017-12-23  07:38:13.0006.766792
2017-12-23  07:38:13.5006.766877
2017-12-23  07:38:14.0006.766917
2017-12-23  07:38:14.5006.767002
2017-12-23  07:38:15.0006.767048
2017-12-23  07:38:15.5006.767058
2017-12-23  07:38:16.0006.767158
2017-12-23  07:38:16.5006.767183
2017-12-23  07:38:17.0006.767108
2017-12-23  07:38:17.5006.767163
2017-12-23  07:38:18.0006.767123
2017-12-23  07:38:18.5006.767108
2017-12-23  07:38:19.0006.767063
2017-12-23  07:38:19.5006.766947
2017-12-23  07:38:20.0006.766892
2017-12-23  07:38:20.5006.766756
2017-12-23  07:38:21.0006.766691
数据的时间间隔为半秒钟,我现在想把整理的多余数据删除,我只需要10分钟整点的数据,例如2017-12-23 07-30:00:000   2017-12-23 07-40:00:000   2017-12-23 07-50:00:000     这样的数据,那位大神能帮忙写个小程序给我。万分感谢,我是一个根本不懂编程的人,别人告诉我找编程人员帮帮忙。所以才来发帖子。




回复

使用道具 举报

1

主题

7

帖子

7

积分

贫民

积分
7
karlzhang00 发表于 2018-4-4 15:19:23 | 显示全部楼层
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
回复 支持 1 反对 0

使用道具 举报

0

主题

1

帖子

1

积分

贫民

积分
1
乘风 发表于 2018-4-4 10:29:00 | 显示全部楼层
多少费用,我试试
回复 支持 反对

使用道具 举报

3

主题

248

帖子

248

积分

侠客

积分
248

热心会员

uitb 发表于 2018-4-4 12:09:34 | 显示全部楼层
excel写几条判断语句,过滤一下就OK啦,用不着写啥脚本了吧。。。。
回复 支持 反对

使用道具 举报

2

主题

15

帖子

15

积分

贫民

积分
15
xinxin868  楼主| 发表于 2018-4-4 13:01:15 | 显示全部楼层
uitb 发表于 2018-4-4 12:09
excel写几条判断语句,过滤一下就OK啦,用不着写啥脚本了吧。。。。

我不会啊,麻烦大神帮帮忙
回复 支持 反对

使用道具 举报

2

主题

15

帖子

15

积分

贫民

积分
15
xinxin868  楼主| 发表于 2018-4-4 13:01:41 | 显示全部楼层
乘风 发表于 2018-4-4 10:29
多少费用,我试试

你说。我也不懂   不清楚
回复 支持 反对

使用道具 举报

1

主题

7

帖子

7

积分

贫民

积分
7
karlzhang00 发表于 2018-4-4 15:17:54 | 显示全部楼层
# -*- 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())

#刚试了试,应该可以实现你需要的功能
回复 支持 反对

使用道具 举报

0

主题

287

帖子

287

积分

侠客

积分
287
sheeboard 发表于 2018-4-4 18:13:06 | 显示全部楼层
本帖最后由 sheeboard 于 2018-4-4 18:30 编辑

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
Screenshot from 2018-04-04 18-11-50.png
回复 支持 反对

使用道具 举报

0

主题

20

帖子

20

积分

贫民

积分
20
sss123 发表于 2018-4-5 13:16:49 | 显示全部楼层
lous楼上  nb
回复 支持 反对

使用道具 举报

2

主题

15

帖子

15

积分

贫民

积分
15
xinxin868  楼主| 发表于 2018-4-5 14:50:35 | 显示全部楼层
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
回复 支持 反对

使用道具 举报

您需要登录后才可以回帖 登录 | 立即注册

本版积分规则

快速回复 返回顶部 返回列表