import os
import csv
import xlrd
from xlrd import open_workbook
from xlwt import Workbook
import math
import os, glob

os.chdir = '\\sise.envir.ee\Kasutajad$\KAUR\38511124933\Documents\Kaupo\Epu failid\2. nokitsemine\Failid_kaustas'
for fname in glob.glob('*.xls'):
    print (fname)

    fname = 'Pilvetyybid_1968_Jõgeva.xls'
    #print (fname)
    eraldi=fname.split("_")
    #print (eraldi)
    taiendita=eraldi[2].split(".")
    #print (taiendita)
    pilv=eraldi[0]
    #print (pilv)
    pilvnimi=pilv[:4]
    #print (pilvnimi)
    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)


    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 row in range(1,6)
                #row[2]=int(row[2])
                for col_num in range(1, 5): row[col_num] = int(row[col_num])
                for col_num in range(1, 5): row[col_num] = str(row[col_num])
                for col_num in range(2, 5): row[col_num] = str(row[col_num]).zfill(2)

                c.writerow(row)