import smbus2
import bme280
from time import sleep
import time
import datetime
from datetime import date
#installed openpyxl at terminal with "sudo pip3 install openpyxl"

from openpyxl import *
amounts, row = [1, 2, 3, 4, 5], 2
workbook = load_workbook("/home/pi/weather-station/bme280_data.xlsx")

port=1
address=0x76
bus=smbus2.SMBus(port)

def update_temp():
    temperature = p.read_temp_c()
    temp_text.value = temperature
    temp_text.after(1000, update_temp)
#load the workbook and select the sheet
workbook = workbook
filename = "/home/pi/weather-station/bme280_data.xlsx"
sheet = workbook.active
today=date.today
now=datetime.datetime.now().time()
bme280_data=bme280.sample(bus,address)
humidity=bme280_data.humidity
pressure=bme280_data.pressure
ambient_temperature=bme280_data.temperature
#
for i, value in enumerate(amounts):
    sheet.cell(column=i+1, row=row, value=value)
#
counter=1
while 1:
    if not counter % 10:

        bme280_data=bme280.sample(bus,address)
        humidity=bme280_data.humidity
        pressure=bme280_data.pressure
        ambient_temperature=bme280_data.temperature
        now=datetime.datetime.now().time()
    print('Adding sensor data to spreadsheet:')
    print(today)
    print(now)
    print('Humidity:'+str(round(humidity,2)))
    print('Pressure:'+str(round(pressure,2)))
    print('Ambiant_Temperature:'+str(round(ambient_temperature,2)))
    time.sleep(10)
#append data to spreadsheet
row=(today, now, ambient_temperature, pressure, humidity)
sheet.append(row)
#Save the workbook
workbook.save('/home/pi/weather-station/bme280_data.xlsx')
counter += 1 #increment counter by 1