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)

with xlrd.open_workbook(fname) as wb:
    sh = wb.sheet_by_index(0)  # or wb.sheet_by_name('name_of_the_sheet_here')
    with open(jaamanimi + '.txt', 'w', newline='') as f:
        spamwriter = csv.writer(f, delimiter=';')
        c = csv.writer(f)

        for a in range(1,sh.nrows):
            row = sh.row_values(a, start_colx=1, end_colx=11)
            for a in range(2,6):
                a=int(a)

            c.writerow(row)