import binascii
import serial
import datetime
import time
import openpyxl
from openpyxl import Workbook
from openpyxl.styles import Font
import pandas as pd
import matplotlib.pyplot as plt
from matplotlib import rcParams
rcParams['font.family'] = 'SimHei'
port_set = "com4"
baudrate_set = 9600
timeout_set = 2
ser = serial.Serial(port = port_set, baudrate = baudrate_set, timeout = timeout_set) ##串口参数配置
def update_line(): ##动态更新折线图
x.append(i)
y.append(pm25_data)
plt.cla()
plt.plot(x, y)
plt.xlabel('编号')
plt.ylabel('PM2.5')
plt.title('PM2.5测试数据折线图')
plt.pause(0.1)
i = 0 ##初始坐标图
x = [0, 0]
y = [0, 0]
plt.plot(x, y)
##plt.xlabel("编号")
##plt.ylabel("PM2.5")
##plt.title("PM2.5测试数据折线图")
##plt.show()
now = datetime.datetime.now() ##系统时间获取
test_data1 = openpyxl.Workbook()
now_time =now.strftime("%Y%m%d%H%M%S")
ws = test_data1.create_sheet(title= now_time, index=0) ##按照系统时间创建工作表
header_font = Font(bold=True)
ws.append(["编号", "时间", "二氧化碳", "甲醛", "TVOC", "PM2.5", "PM10", "温度", "湿度"]) ##写入表格首行 标题行
while True:
data = ser.read(17)
if i < 30000:
i = i + 1
ceshi_i = str(i)
print("\033[1;37;42m第{}次测试\033[0m".format(ceshi_i)) ##测试次数获取
data_hex = binascii.hexlify(data).decode('utf-8')
now1 = datetime.datetime.now() ##系统时间获取
test_time = now1.strftime("%H:%M:%S")
print(test_time)
co2_com_data = data_hex[4:8]
co2_data = int(co2_com_data, 16) ##二氧化碳数据获取
print(f"co2={co2_data}")
ch2o_com_data = data_hex[8:12]
ch2o_data = int(ch2o_com_data, 16) ##甲醛数据获取
print(f"ch2o={ch2o_data}")
tvoc_com_data = data_hex[12:16]
tvoc_data = int(tvoc_com_data, 16) ##挥发物数据获取
print(f"\033[1;33;40mtvoc={tvoc_data}\033[0m")
pm25_com_data = data_hex[16:20]
pm25_data = int(pm25_com_data, 16) ##PM2.5数据获取
print(f"\033[1;33;40mpm2.5={pm25_data}\033[0m")
pm10_com_data = data_hex[20:24]
pm10_data = int(pm10_com_data, 16) ##PM10数据获取
print(f"pm10={pm10_data}")
temp1_com_data = data_hex[24:26]
temp1_data = int(temp1_com_data, 16)
temp2_com_data = data_hex[26:28]
temp2_data = int(temp2_com_data, 16)
temp_data = str(temp1_data) + "." + str(temp2_data) ##温度数据获取
temp = float(temp_data)
print(f"temperature= {temp}")
humi1_com_data = data_hex[28:30]
humi1_data = int(humi1_com_data, 16)
humi2_com_data = data_hex[30:32]
humi2_data = int(humi2_com_data, 16)
humi_data = str(humi1_data) + "." + str(humi2_data)
humi = float(humi_data)
print(f"humidity={humi}") ##湿度数据获取
print("=========================")
ws.append([i, now1, co2_data, ch2o_data, tvoc_data, pm25_data, pm10_data, temp, humi])
test_data1.save("{}.xlsx".format(now_time)) ##表格数据保存
update_line()
else:
now_time =now.strftime("%Y%m%d%H%M%S")
ws = test_data1.create_sheet(title= now_time, index=0)
header_font = Font(bold=True)
ws.append(["编号", "时间", "二氧化碳", "甲醛", "TVOC", "PM2.5", "PM10", "温度", "湿度"])
i = 0
else:
print("error")