예제 #1
0
파일: run.py 프로젝트: sinantr/python
		line=[]
		for cell in row:
			line.append(cell.internal_value)
		table.append(line)			
except:
	a = 'Dosya açılamadı /home/python/xxxxxxxxxx/%s' % filename
	print a
	#defMandrill.defMandrillRoot(a,a)
	sys.exit()


print 'Update başladı.'

for row in table:
	try:
		defMySql.baglanti(int(row[0]),row[1],int(row[2]))
		print "%s - %s - %s" %(int(row[0]),row[1], int(row[2]))	
	except:
		pass
	
sonuc = '%s satırdan uygun olanlar update edildi.' %(len(table)) 
print sonuc

def mailAt():
	txt = ''
	for row in table:	
		txt += "%s - %s TL - %s<br>" % (int(row[0]),row[1],int(row[2]))
	return txt	

html = """%s<br>
-----------------------------------------------------------------<p>
예제 #2
0
파일: run.py 프로젝트: sinantr/python
worksheet.write('B4', 63379.05, cell_format_3) # Ocak
worksheet.write('B5', 44843.17, cell_format_3) # Şubat
worksheet.write('B6', 82923.77, cell_format_3) # Mart
worksheet.write('B7', 119059.76, cell_format_3) # Nisan
worksheet.write('B8', 45513.57, cell_format_3) # Mayıs
worksheet.write('B9', 50006.03, cell_format_3) # Haziran
worksheet.write('B10', 53824.04, cell_format_3) # Temmuz
worksheet.write('B11', 13878.8, cell_format_3) # Ağustos
worksheet.write('B12', 34737.15, cell_format_3) # Eylül
worksheet.write('B13', 72554.33, cell_format_3) # Ekim
worksheet.write('B14', 66943.89, cell_format_3) # Kasım
worksheet.write('B15', 43338.22, cell_format_3) # Aralık
# Toplama
worksheet.write_formula('B16', '=SUM(B4:B15)', cell_format_3)
# C Sütunu
worksheet.write('C4', defMySql.baglanti(2014,1), cell_format_3) # Ocak
worksheet.write('C5', defMySql.baglanti(2014,2), cell_format_3) # Şubat
worksheet.write('C6', defMySql.baglanti(2014,3), cell_format_3) # Mar
worksheet.write('C7', defMySql.baglanti(2014,4), cell_format_3) # Nisan
worksheet.write('C8', defMySql.baglanti(2014,5), cell_format_3) # Mayıs
worksheet.write('C9', defMySql.baglanti(2014,6), cell_format_3) # Haziran
worksheet.write('C10', defMySql.baglanti(2014,7), cell_format_3) # Temmmuz
worksheet.write('C11', defMySql.baglanti(2014,8), cell_format_3) # Ağustos
worksheet.write('C12', defMySql.baglanti(2014,9), cell_format_3) # Eylül
worksheet.write('C13', defMySql.baglanti(2014,10), cell_format_3) # Ekim
worksheet.write('C14', defMySql.baglanti(2014,11), cell_format_3) # Kasım
worksheet.write('C15', defMySql.baglanti(2014,12), cell_format_3) # Aralık
# Toplama
worksheet.write_formula('C16', '=SUM(C4:C15)', cell_format_3)
# D Sütunu
worksheet.write_formula('D4', '=C4/B4', cell_format_3)
예제 #3
0
파일: run.py 프로젝트: sinantr/python
    for row in sheet.iter_rows():
        line = []
        for cell in row:
            line.append(cell.internal_value)
        table.append(line)
except:
    a = 'Dosya açılamadı /home/python/xxxxxxxxxx/%s' % filename
    print a
    #defMandrill.defMandrillRoot(a,a)
    sys.exit()

print 'Update başladı.'

for row in table:
    try:
        defMySql.baglanti(int(row[0]), row[1], int(row[2]))
        print "%s - %s - %s" % (int(row[0]), row[1], int(row[2]))
    except:
        pass

sonuc = '%s satırdan uygun olanlar update edildi.' % (len(table))
print sonuc


def mailAt():
    txt = ''
    for row in table:
        txt += "%s - %s TL - %s<br>" % (int(row[0]), row[1], int(row[2]))
    return txt