Advertisement
Guest User

Untitled

a guest
Jun 15th, 2017
113
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. 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. myfile = xlrd.open_workbook(fname)
  17. # get a sheet
  18. mysheet = myfile.sheet_by_index(0)
  19. new_book = Workbook()
  20. new_sheet = new_book.add_sheet('Sheet 1', cell_overwrite_ok=True)
  21.  
  22. #print (mysheet.col_values(3))
  23. for col in range(mysheet.ncols):
  24. if col ==0 or col>10:
  25. pass
  26. if len(mysheet.col_values(col)) == 1 and col in range(3, 6):
  27. mysheet.col_values= int(0) + mysheet.col_values
  28. print(mysheet.col_values(3)) # <-----------------------------------return nothing!
  29. else:
  30. for row in range (mysheet.nrows):
  31. if row == 0:
  32. pass
  33. else:
  34.  
  35. new_sheet.write(row-1, col-1, mysheet.cell(row, col).value)
  36.  
  37.  
  38. new_book.save(jaamanimi + ".xls")
  39.  
  40. Traceback (most recent call last):
  41. File "\\Lahendus2.py", line 31, in <module>
  42. if len(int(mysheet.col_values) in range(3,5))==1:
  43. TypeError: int() argument must be a string, a bytes-like object or a number, not 'method'
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement