无人机代码

import random

from openpyxl import Workbook,load_workbook
from decimal import Decimal

import time,datetime
tn = datetime.datetime.now()
t =datetime.timedelta(days=8)
t_min = datetime.timedelta(minutes=3)
strtime =tn -t
str_time_min =tn + t_min
ttime = strtime.strftime('%Y-%m-%d %H:%M:%S')
ttime_last = str_time_min.strftime(' %H:%M:%S')
print(ttime)
print(ttime_last)
time_dest = ttime + ttime_last
print(time_dest)

wb =Workbook()

wb = load_workbook("D:\django\bypy_home\2024-03-21-17-15-59-飞行记录.xlsx")
ws= wb.active

rows= ws.max_row
alist= [6.45] *(rows-1)

使用变量长度表格行数

alen =ws.max_row-1
print("要写如数据的长度",alen,"\n")
def create_random_list():
yu_shu = alen %2
print(yu_shu)
if yu_shu == 1:
print("奇数")
i=0
for i in range(0,alen):
suijishu = random.randint(10, 30) * 0.01
print(suijishu, "ooo")
alist[i] =alist[i]+suijishu
alist[i] = round(alist[i], 2)

alist[i+1]=alist[i+1]-suijishu
alist[i+1] = round(alist[i+1], 2)
# 保留两位小数
# number = Decimal(alist[i])
# alist[i] = number.quantize(2)
#
# number1 = Decimal(alist[i+1])
# alist[i+1] = number1.quantize(2)
i +=2
if i >=alen-3:
break
else:
print("说明是数列奇数行")
j = 0
for j in range(0,alen):
suijishu = random.randint(10, 30) * 0.01
print(suijishu, "ooo")
if j >(alen -2):
break
alist[j] = alist[j] + suijishu
alist[j] = round(alist[j],3)

alist[j + 1] = alist[j+1] - suijishu
alist[j+1] = round(alist[j+1], 3)

j += 2

create_random_list()
def sum_area():
ksum=0
for i in alist:
ksum +=i
print("总面积是",ksum)
print(alist)
sum_area()

定位开始时间

data_start_time =strtime
delta_kaishi = datetime.timedelta(hours=6)
delta_kaishi_min = datetime.timedelta(minutes=3)
delta_kaishi_second = datetime.timedelta(seconds=17)
strtime = strtime - delta_kaishi
for k in range(2,rows+1):
#前缀
ttime_first = strtime.strftime('%Y-%m-%d %H:%M:%S')
# print(ttime_first)

后3分钟时间

strtime = strtime+delta_kaishi_min
strtime = strtime + delta_kaishi_second
#中途休息3分钟
strtime = strtime + delta_kaishi_min
ttime_last=strtime.strftime(' %H:%M:%S')
diyihang_diyilie_cell=ws.cell(k,1)
shengcheng_shifenmiao = ttime_first+" " +ttime_last
ws.cell(k,1,shengcheng_shifenmiao)
# print(diyihang_diyilie_cell.value)#
##开始写入面积数据
cell_5=ws.cell(k,5)
cell_6 = ws.cell(k, 6)
arrae =alist[k-2]
cell_5.value =arrae
cell_6.value = (alist[k-2] )*7.5
print(cell_6.value,9999999999)
# ws.cell(k, 6, arrae * 7.5)

# print(ttime,"kkk")

v=cell.value

ws.cell(k,6,v*3)

# print(cell.value)

wb.save("D:\django\bypy_home\2024-03-21-17-15-59-飞行记录.xlsx")

print(ak)