I'm working with QGIS 2.8.1. and I want to convert many xls files into csv format using python.
My input directory is: D:\PATRICIA\TESTE\XLS and output is: D:\PATRICIA\TESTE\CSV2.
I wrote this code based on suggestions from (http://stackoverflow.com/questions/24969274/converting-xls-file-into-csv-txt-file-in-python) and developed it in different files with different dates 1999/01/2 until 1999/01/31 us:RR_1999_1_2.xls,RR_1999_1_3.xls,...RR_1999_1_31.xls
I don't know why my script doesn´t works.
My script is:
import xlrdimport csvimport datetime as dtfrom datetime import timedelta#initial and final dates data1='19990102'data2='19990131'anoi = int(data1[:4])mesi = int(data1[4:6])diai = int(data1[6:8])anof = int(data2[:4])mesf = int(data2[4:6])diaf = int(data2[6:8])start_date = dt.datetime(anoi, mesi, diai)end_date = dt.datetime(anof, mesf, diaf)total_days = (end_date - start_date).days + 1for day in xrange(0, total_days): current_date = (start_date + dt.timedelta(days = day)).date() file_date = str(current_date.year)+'_'+str(current_date.month)+'_'+str(current_date.day) srt1='D:/PATRICIA/TESTE/XLS/RR_'+file_date+'.xls' srt2='D:/PATRICIA/TESTE/CSV2/RR_'+file_date+'.csv' def xls_to_csv(): x = xlrd.open_workbook(str1) x1 = x.sheet_by_name('Sheet1') csvfile = open(str2, 'wb') writecsv = csv.writer(csvfile, quoting=csv.QUOTE_ALL) for rownum in xrange(sh.nrows): writecsv.writerow(x1.row_values(rownum)) csvfile.close()
أكثر...
My input directory is: D:\PATRICIA\TESTE\XLS and output is: D:\PATRICIA\TESTE\CSV2.
I wrote this code based on suggestions from (http://stackoverflow.com/questions/24969274/converting-xls-file-into-csv-txt-file-in-python) and developed it in different files with different dates 1999/01/2 until 1999/01/31 us:RR_1999_1_2.xls,RR_1999_1_3.xls,...RR_1999_1_31.xls
I don't know why my script doesn´t works.
My script is:
import xlrdimport csvimport datetime as dtfrom datetime import timedelta#initial and final dates data1='19990102'data2='19990131'anoi = int(data1[:4])mesi = int(data1[4:6])diai = int(data1[6:8])anof = int(data2[:4])mesf = int(data2[4:6])diaf = int(data2[6:8])start_date = dt.datetime(anoi, mesi, diai)end_date = dt.datetime(anof, mesf, diaf)total_days = (end_date - start_date).days + 1for day in xrange(0, total_days): current_date = (start_date + dt.timedelta(days = day)).date() file_date = str(current_date.year)+'_'+str(current_date.month)+'_'+str(current_date.day) srt1='D:/PATRICIA/TESTE/XLS/RR_'+file_date+'.xls' srt2='D:/PATRICIA/TESTE/CSV2/RR_'+file_date+'.csv' def xls_to_csv(): x = xlrd.open_workbook(str1) x1 = x.sheet_by_name('Sheet1') csvfile = open(str2, 'wb') writecsv = csv.writer(csvfile, quoting=csv.QUOTE_ALL) for rownum in xrange(sh.nrows): writecsv.writerow(x1.row_values(rownum)) csvfile.close()
أكثر...