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=round(row,0)
           # b=int(floor(a))
            #if isinstance(row, int):

            for col in range(sh.ncols):
                if col ==0 or col>10:
                    row_should_be_written=False
                else:
                    row_should_be_written=True
            c.writerow(sh.row_values(a)[1:11])