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


rb = open_workbook('Pilvetyybid_1968_Jõgeva.xls',formatting_info=False)

nimi=os.path.basename('Pilvetyybid_1968_Jõgeva.xls')
print (nimi)
eraldi=nimi.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)

first_sheet = rb.sheet_by_index(0)

for a, name in enumerate(rb.sheet_names()):
    rs = rb.sheet_by_index(a)
    new_book = Workbook()
    new_sheet = new_book.add_sheet('Sheet 1')

    for col in range(rs.ncols):
        if col ==0 or col>10:
            pass
        else:
            for row in range (rs.nrows):
                if row == 0:
                    pass
                else:
                    new_sheet.write(row-1, col-1, rs.cell(row, col).value)


    new_book.save(jaamanimi + ".txt")