+- Python Forum (https://python-forum.io)
+-- Forum: Python Coding (https://python-forum.io/forum-7.html)
+--- Forum: General Coding Help (https://python-forum.io/forum-8.html)
+--- Thread: Unable to execute the for loop (/thread-21290.html)
Unable to execute the for loop - harold - Sep-23-2019
Hi Guys
I have got a set of table(FruitsTable, B2:E5) from excel and would like to the font color to be red for column B if quantity is > 6500 via using python.
However, I ran into a syntax error after typing the for loop and unable to find out what is the issue. Hence, would appreciate if you guys would assist with the code. Thanks in advance!
A B C D E
1 Fruits 2011 2012 2013 2014
2 Apples 10000 5000 8000 6000
3 Pears 20000 30000 4000 5000
4 Bananas 6000 6500 6700 6000
5 Oranges 500 300 200 700
from openpyxl import Workbook
from openpyxl.styles import *
from openpyxl.worksheet.table import Table, TableStyleInfo
import openpyxl
workbook = openpyxl.load_workbook("C:/Users/HAROLD/Desktop/Python 3/Automate excel data using python/Employees.xlsx")
worksheet = workbook['Table']
style = TableStyleInfo(name = "TableStyleMedium9", showRowStripes = True, showColumnStripes = True)
table.tableStyleInfo = style
font = Font(color = colors.RED, bold = True, italic = Bold)
for cell_number in range (2,6):
if int(worksheet['B%s' % (cell_number)].value > 6500:
RE: Unable to execute the for loop - buran - Sep-23-2019
on line 14 there is missing closing bracket for int function