Advertisement
Guest User

Untitled

a guest
Jun 6th, 2017
128
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  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(1,(sh.nrows)):
  12. for col in range(sh.ncols):
  13. if col ==0 or col>10:
  14. row_should_be_written=False
  15. else:
  16. row_should_be_written=True
  17. c.writerow(sh.row_values(row))
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement