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>
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)
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
