def fill_workbook(self):
counter = 1
a=self.has_workbook()
if a==True:
wb= openpyxl.load_workbook(self.get_workbook())
else:
wb = Workbook()
wb.save(self.get_workbook())
b=wb.active
b.title = self.user.get_name()
while b['B'+str(counter)].value!=b['C1'].value:
counter=counter+1
localtime = time.asctime( time.localtime(time.time()) )
b['B'+str(counter)]=float(self.web.get_price())
b['A'+str(counter)]=str(localtime)
chart = LineChart()
prices = Reference(b,min_col=2,max_col=2,min_row=1,max_row=int(counter))
times = Reference(b,min_col=1,max_col=1,min_row=1,max_row=int(counter))
series = Series(prices, title=self.user.get_name())
chart.append(series)
chart.set_categories(times)
chart.__name__= self.user.get_name()+" Prices"
b.add_chart(chart)
wb.save(self.get_workbook())
