Having trouble fetching data from excel sheet using python

Question

I have attached an excel sheet and with the help of python code below I'm trying to fetch those roll numbers who have either secured marks less than 40 or are having an attendance below 75 percent.

But every time I run the code I face an error message :

Traceback (most recent call last): 87.0 File "C:/Users/Shubham Mishra/PycharmProjects/Python/jacc.py", line 11, in value1 = (int)(worksheet.cell(i, 2).value) ValueError: invalid literal for int() with base 10: 'Attendance'

import xlrd
workbook=xlrd.open_workbook('log.xls')
worksheet=workbook.sheet_by_index(0)  
print(worksheet.cell(1,2).value) 

i=1
n=6

for i in range(n):
    value1 = (int)(worksheet.cell(i, 2).value)
    value2 = (worksheet.cell(i, 3).value)

    if ((value1<=75) or (value2<=40)):
        print(worksheet.cell(i,1))

enter image description here

Yeah thanks but it's still throwing the same error....But thanks for correcting me on explicit conversion .@Giordano — user7520288
– user7520288, Commented Mar 7, 2017 at 16:53

Giordano · Accepted Answer · 2017-03-07 17:00:05Z

1

The main problem in your code is that range function starts with 0.
So the first loop's iteration is:

value1 = (int)(worksheet.cell(0, 2).value)

that corresponds to "Attendance" string.
This is the reason because you have this error.

You should think to change your code in something like this:

n=7
for i in range(1, n):
    value1 = (int)(worksheet.cell(i, 2).value)
    value2 = (worksheet.cell(i, 3).value)

    if ((value1<=75) or (value2<=40)):
         print(worksheet.cell(i,1))

please note that n is equals to 7 and not 6 anymore.

edited Mar 7, 2017 at 17:00

answered Mar 7, 2017 at 16:54

Giordano

5,6183 gold badges38 silver badges52 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Having trouble fetching data from excel sheet using python

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related