First import the file :-
file_location = "C:/Users/DELL/Desktop/Book.xls"
workbook = xlrd.open_workbook(file_location)
sheet = workbook.sheet_by_index(0)
Then try using the code below:
for s in workbook.sheets():
**for row in range(1,s.nrows):**
col_names = s.row(0)
col_value = 
for name,col in zip(col_names,range(s.ncols)):
value = (s.cell(row,col).value)
try : value = str(int(value))
except : pass
May be some changes have to be made according to the row you want to exclude.
For example if you want to exclude the second row,
for row in range(2,s.nrows) has to be used.
I am not entirely sure.
Can you please check and let me know if this helps!!
You also have to install xlrd through cmd first to use it.