SHOW:
|
|
- or go back to the newest paste.
| 1 | import os | |
| 2 | import csv | |
| 3 | import xlrd | |
| 4 | from xlrd import open_workbook | |
| 5 | from xlwt import Workbook | |
| 6 | ||
| 7 | ||
| 8 | fname = 'Pilvetyybid_1968_Jõgeva.xls' | |
| 9 | eraldi=fname.split("_")
| |
| 10 | taiendita=eraldi[2].split(".")
| |
| 11 | pilv=eraldi[0] | |
| 12 | pilvnimi=pilv[:4] | |
| 13 | jaamanimi=pilvnimi + "_" + taiendita[0] + "_" + eraldi[1] | |
| 14 | #print(jaamanimi) | |
| 15 | ||
| 16 | with xlrd.open_workbook(fname) as wb: | |
| 17 | sh = wb.sheet_by_index(0) # or wb.sheet_by_name('name_of_the_sheet_here')
| |
| 18 | with open(jaamanimi + '.txt', 'w', newline='') as f: | |
| 19 | spamwriter = csv.writer(f, delimiter=';') | |
| 20 | c = csv.writer(f) | |
| 21 | ||
| 22 | for a in range(1,(sh.nrows)): | |
| 23 | - | #row=round(row,0) |
| 23 | + | for a in range(2,6): |
| 24 | - | # b=int(floor(a)) |
| 24 | + | b= isinstance(a, int) |
| 25 | - | #if isinstance(row, int): |
| 25 | + | |
| 26 | - | |
| 26 | + | |
| 27 | if col ==0 or col>10: | |
| 28 | row_should_be_written=False | |
| 29 | else: | |
| 30 | row_should_be_written=True | |
| 31 | c.writerow(sh.row_values(b)[1:11]) |
