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)
- 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)):
- for a in range(2,6):
- b= isinstance(a, 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(b)[1:11])
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement