import os
import xlrd
from xlrd import open_workbook
from xlwt import Workbook
from xlrd.sheet import empty_cell

rb = open_workbook('andmefail_Tooma_1924.xls',formatting_info=False)

nimi=os.path.basename('andmefail_Tooma_1924.xls')
#print (nimi)
eraldi=nimi.split("_")
#print (eraldi)
jaam=eraldi[1]
#print(jaam)

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', cell_overwrite_ok=True)

    for col in range(1,(rs.nrows-4)):

        new_sheet.write(col,0,jaam)

    for col in range(rs.ncols):
        if col >= 26:
            pass  # don't write
        else:
            for row in range(rs.nrows):
                if row == 0 or row >= (rs.nrows) -4:
                    pass  # don't write
                else:
                    new_sheet.write(row, col+1, rs.cell(row, col).value)


    new_book.save(jaam +"_"+str(name) + ".xls")


Output:
[[" ";" ";" ";" ";" ";" ";" ";" ";" ";" ";" ";" ";" ";" ";" ";" ";" ";" ";" ";"]["Tooma";"1924";"1";1";3";"2";"1";1";3";"2";"1";1";3";"2"]["Tooma";"1924";"1";1";3";"2";"1";1";3";"2";"1";1";3";"2"]["Tooma";"1924";"1";1";3";"2";"1";1";3";"2";"1";1";3";"2"]["Tooma";"1924";"1";1";3";"2";"1";1";3";"2";"1";1";3";"2"]["Tooma";"1924";"1";1";3";"2";"1";1";3";"2";"1";1";3";"2"]["Tooma";"1924";"1";1";3";"2";"1";1";3";"2";"1";1";3";"2"]]