Unable to style range of cells
Created originally on Bitbucket by Josh Haywood
Styling a range of cells doesn't seem to be supported. The following code returns an AttributeError: 'generator' object has no attribute 'style'.
#!python
import tkinter as tk
from tkinter import filedialog
import csv, random
from openpyxl import Workbook
from openpyxl import load_workbook
from openpyxl.styles import Style, PatternFill, Border, Side, Alignment, Protection, Font, Color
###Some Code Here###
def onRandoClick(self):
count = 0
data = []
header = ["Animal #", "Weight (g)"]
while count < self.totalAnimals.get():
data.append(self.startAnimalNum.get() + count)
count += 1
random.shuffle(data)
wb = Workbook()
ws = wb.active
ws.cell('A1').value = header[0]
ws.cell('B1').value = header[1]
j = 0
for i in range(2, self.totalAnimals.get() + 1):
ws.cell(row = i, column = 1).value = data[j]
j = j + 1
endRow = str(self.totalAnimals.get() + 1)
sel = ws['A2':'B%s' % endRow]
sel.style = Style(font=Font(color=Color('ff0000')))
wb.save(self.randoFilepath + '//%s Randomization.xlsx' % self.studyNumber.get())
root.destroy()
###Some Code Here###