SHOW:
|
|
- or go back to the newest paste.
1 | import os | |
2 | import csv | |
3 | import xlrd | |
4 | ||
5 | with xlrd.open_workbook('Pilvetyybid_1968_Jõgeva.xls') as wb: | |
6 | sh = wb.sheet_by_index(0) # or wb.sheet_by_name('name_of_the_sheet_here') | |
7 | with open('a_file.csv', 'w', newline='') as f: | |
8 | spamwriter = csv.writer(f, delimiter=';') | |
9 | c = csv.writer(f) | |
10 | ||
11 | for row in range(sh.nrows): | |
12 | #for col in range(sh.ncols): | |
13 | - | c.writerow(sh.row_values(sh.nrows-1)) |
13 | + | c.writerow(sh.row_values(row)) |