Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- 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)
- 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)
- #print (mysheet.col_values(3))
- for col in range(mysheet.ncols):
- if col ==0 or col>10:
- pass
- if len(mysheet.col_values(col)) == 1 and col in range(3, 6):
- mysheet.col_values= int(0) + mysheet.col_values
- print(mysheet.col_values(3)) # <-----------------------------------return nothing!
- else:
- for row in range (mysheet.nrows):
- if row == 0:
- pass
- else:
- new_sheet.write(row-1, col-1, mysheet.cell(row, col).value)
- new_book.save(jaamanimi + ".xls")
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement