View difference between Paste ID: iALQTBxV and EstR6nVR

 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)
 
-myfile = xlrd.open_workbook(fname)
+with xlrd.open_workbook(fname) as wb:
-    # get a sheet
+    sh = wb.sheet_by_index(0)  # or wb.sheet_by_name('name_of_the_sheet_here')
-mysheet = myfile.sheet_by_index(0)
+    with open(jaamanimi + '.txt', 'w', newline='') as f:
-new_book = Workbook()
+        spamwriter = csv.writer(f, delimiter=';')
-new_sheet = new_book.add_sheet('Sheet 1', cell_overwrite_ok=True)
+        c = csv.writer(f)
 
-#print (mysheet.col_values(3))
+        for a in range(1,(sh.nrows)):
-for col in range(mysheet.ncols):
+            #row=round(row,0)
-    if col ==0 or col>10:
+           # b=int(floor(a))
-        pass
+            #if isinstance(row, int):
-    if len(mysheet.col_values(col)) == 1 and col in range(3, 6):
+
-        mysheet.col_values= int(0) + mysheet.col_values
+            for col in range(sh.ncols):
-        print(mysheet.col_values(3))							# <-----------------------------------return nothing!
+                if col ==0 or col>10:
-    else:
+                    row_should_be_written=False
-        for row in range (mysheet.nrows):
+                else:
-            if row == 0:
+                    row_should_be_written=True
-                pass
+            c.writerow(sh.row_values(a)[1:11])