import os
import xlrd
import pandas as pd
from xlrd import open_workbook
from xlwt import Workbook


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

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(1,11):
    	for row in range (1,rs.nrows):
        	new_sheet.write(row, col, rs.cell(row, col).value)


    new_book.save(jaamanimi + ".xls")