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())