import os
import csv
import xlrd
from xlrd import open_workbook
from xlwt import Workbook


fname = 'Pilvetyybid_1968_Jõgeva.xls'
eraldi=fname.split("_")
taiendita=eraldi[2].split(".")
pilv=eraldi[0]
pilvnimi=pilv[:4]
jaamanimi=pilvnimi + "_" + taiendita[0] + "_" + eraldi[1]
#print(jaamanimi)

myfile = xlrd.open_workbook(fname)
    # get a sheet
mysheet = myfile.sheet_by_index(0)
new_book = Workbook()
new_sheet = new_book.add_sheet('Sheet 1', cell_overwrite_ok=True)

#print (mysheet.col_values(3))
for col in range(mysheet.ncols):
    if col ==0 or col>10:
        pass
    if len(int(mysheet.col_values) in range(3,5))==1:
        mysheet.col_values= 0 + mysheet.col_values
    else:
        for row in range (mysheet.nrows):
            if row == 0:
                pass
            else:

                new_sheet.write(row-1, col-1, mysheet.cell(row, col).value)


new_book.save(jaamanimi + ".xls")

Traceback (most recent call last):
  File "\\Lahendus2.py", line 31, in <module>
    if len(int(mysheet.col_values) in range(3,5))==1:
TypeError: int() argument must be a string, a bytes-like object or a number, not 'method'