玖叶教程网

话不多说，直接上干货

import os
import xlwt
import time


f0 = "C:\\Users\\Administrator\\Desktop\\123\\2111112.txt"
f1 = "C:\\Users\\Administrator\\Desktop\\123\\211111114.txt"
f5 = "C:\\Users\\Administrator\\Desktop\\123\\22111111.xls"
for i in range(20):
    val = os.popen(r"adb shell cat /proc/net/dev |findstr wwan0 ").read()
    f = open(f0, "a")
    result = str(val)
    f.write(result)
    f.close()
print("ok")


f2 = open(f0)
for x in f2:
    line1 = x.split(" ")[1]
    line11 = str(line1)[0:5]
    line2 = x.split(" ")[3]
    # print(line2)
    line21 = x.split(" 0 ")[6]
    # print(line21)
    line212 = line21.split(" ")[1]
    # print(line212)
    line22 = ((int(line2)+int(line212))/1024/1024)
    # print(line22)
    line23 = round(line22,2)
    resul1 = (line11 +":"+str(line23)) +"\n"
    f3 = open(f1, "a")
    f3.write(resul1)
    f3.close()
else:
    print("Finally finished")

def writeexcel():
    f4 = open(f1)
    workbook = xlwt.Workbook()
    sheet = workbook.add_sheet('总流量', cell_overwrite_ok=True)
    sheet.write(0, 1, "数据网络")
    sheet.write(0, 0, "消耗流量")
    x = 1
    y = 0
    while True:
        line3 = f4.readline()
        if not line3:
            break
        for i in line3.split(':'):
            item = i.strip()
            sheet.write(x, y, item)
            y += 1
        x += 1
        y = 0
        workbook.save(f5)
if __name__ == "__main__":
    writeexcel()