def gen_xlsx(list_main, stats_dem, stats_lifestyle, stats_reach, workbook,
name):
sheet_dict = {}
sheet_count = 1
##Each URL in the provided input file
for site in list_main:
sheet_dict[site] = workbook.new_sheet(site)
sheet_dict[site].cell(coords=(0, 0), value=site)
sheet_dict[site].cell(coords=(2, 0), value='Demographic Stats')
sheet_dict[site].cell(coords=(2, 3), value='Reach Stats')
sheet_dict[site].cell(coords=(2, 6), value='LifeStyle Stats')
sheet_dict[site].cell(coords=(2, 1), value='%')
sheet_dict[site].cell(coords=(2, 4), value='Monthly Uniques')
sheet_dict[site].cell(coords=(2, 7), value='Affinity')
##Demographic Stats
row_dem = 2
col_dem = 0
for key1 in stats_dem[site].iterkeys():
sheet_dict[site].cell(coords=(row_dem, col_dem), value=key1) ##Key
sheet_dict[site].cell(coords=(row_dem, col_dem + 1),
value=stats_dem[site][key1]) ##Value
row_dem += 1
##Reach Stats - Not stored in list, not dict
row_reach = 3
col_reach = 3
for key2 in stats_reach[site]:
if row_reach == 3:
sheet_dict[site].cell(coords=(row_reach, col_reach),
value='US') ##Key
elif row_reach == 4:
sheet_dict[site].cell(coords=(row_reach, col_reach),
value='Global') ##Key
else:
sheet_dict[site].cell(coords=(row_reach, col_reach),
value='N/A') ##Key
sheet_dict[site].cell(coords=(row_reach, col_reach + 1),
value=key2) ##Value
row_reach += 1
##Lifestyle Stats
row_lifestyle = 3
col_lifestyle = 6
for w in sorted(stats_lifestyle[site].items(),
key=lambda (k, v): (v, k),
reverse=True):
sheet_dict[site].cell(coords=(row_lifestyle, col_lifestyle),
value=w[0]) ##Key
sheet_dict[site].cell(coords=(row_lifestyle, col_lifestyle + 1),
value=w[1]) ##Value
row_lifestyle += 1
sheet_count += 1
save(workbook, name + '.xlsx')
def main():
workbook = xlsx.Workbook()
sheet1 = workbook.new_sheet('Sheet 1')
sheet1.cell('B1', value=7)
sheet1.cell('C1', value=8)
sheet1.cell('D1', value=9)
formula = sheet1.formula('B1 + C1', shared=True)
sheet1.cell('D2', formula) # master
sheet1.cell('E2', formula) # shared, references the master formula
xlsx.save(workbook, 'test.xlsx') # save local file
def benchmark_xlsxcessive():
from xlsxcessive import xlsx as xcessive
workbook = xcessive.Workbook()
sheet = workbook.new_sheet('Sheet1')
for row, value in izip(xrange(ROWS), VALUES):
for column in xrange(COLUMNS):
sheet.cell(coords=(row, column), value=value)
xcessive.save(workbook, 'benchmark_xlsxcessive.xlsx')
def benchmark_xlsxcessive():
from xlsxcessive import xlsx as xcessive
workbook = xcessive.Workbook()
sheet = workbook.new_sheet('Sheet1')
for row, value in zip(range(ROWS), VALUES):
for column in range(COLUMNS):
sheet.cell(coords=(row, column), value=value)
xcessive.save(workbook, 'benchmark_xlsxcessive.xlsx')
def gen_xlsx(list_main, stats_dem, stats_lifestyle, workbook, name):
sheet_dict = {}
sheet_dict['Research'] = workbook.new_sheet('Research')
site_row = 3; index_dem = 1;
dem_dict = {}
ls_dict = {}
##Determine How many distinct Demographic fields are present
dem_max_dict = []; dem_max_index = 1
for site2 in list_main:
for key_dem in stats_dem[site2].iterkeys():
if key_dem not in dem_max_dict:
dem_max_dict.append(key_dem)
dem_max_index +=1
##Each URL in the provided input file
for site in list_main:
sheet_dict['Research'].cell(coords=(site_row,0), value=site)
##Demographic Info
for key1 in stats_dem[site].iterkeys():
##Check if Parameter has been added
if key1 not in dem_dict.keys():
sheet_dict['Research'].cell(coords=(2,index_dem), value=key1) ## Add Key
sheet_dict['Research'].cell(coords=(site_row,index_dem), value=stats_dem[site][key1]) ##Value
dem_dict[key1] = index_dem
index_dem +=1
else:
prev_index = dem_dict[key1] ##index of parameter that has been added already
sheet_dict['Research'].cell(coords=(site_row,prev_index), value=stats_dem[site][key1]) ##Value
index_ls = dem_max_index + 2; prev_index = -1
##Lifestyle Stats
for key2 in stats_lifestyle[site].iterkeys():
##Check if Parameter has been added
if key2 not in ls_dict.keys():
sheet_dict['Research'].cell(coords=(2,index_ls), value=key2) ## Add Key
sheet_dict['Research'].cell(coords=(site_row,index_ls), value=stats_lifestyle[site][key2]) ##Value
ls_dict[key2] = index_ls
index_ls +=1
else:
prev_index = ls_dict[key2] ##index of parameter that has been added already
sheet_dict['Research'].cell(coords=(site_row,prev_index), value=stats_lifestyle[site][key2]) ##Value
site_row +=1
save(workbook, name + '.xlsx')
def gen_xlsx(list_main, stats_dem, stats_lifestyle, stats_reach, workbook, name):
sheet_dict = {}
sheet_count = 1
##Each URL in the provided input file
for site in list_main:
sheet_dict[site] = workbook.new_sheet(site)
sheet_dict[site].cell(coords=(0,0), value=site)
sheet_dict[site].cell(coords=(2,0), value = 'Demographic Stats')
sheet_dict[site].cell(coords=(2,3), value = 'Reach Stats')
sheet_dict[site].cell(coords=(2,6), value = 'LifeStyle Stats')
sheet_dict[site].cell(coords=(2,1), value = '%')
sheet_dict[site].cell(coords=(2,4), value = 'Monthly Uniques')
sheet_dict[site].cell(coords=(2,7), value = 'Affinity')
##Demographic Stats
row_dem = 2; col_dem = 0
for key1 in stats_dem[site].iterkeys():
sheet_dict[site].cell(coords=(row_dem,col_dem), value=key1) ##Key
sheet_dict[site].cell(coords=(row_dem,col_dem + 1), value=stats_dem[site][key1]) ##Value
row_dem += 1
##Reach Stats - Not stored in list, not dict
row_reach = 3; col_reach = 3
for key2 in stats_reach[site]:
if row_reach == 3:
sheet_dict[site].cell(coords=(row_reach,col_reach), value='US') ##Key
elif row_reach == 4:
sheet_dict[site].cell(coords=(row_reach,col_reach), value='Global') ##Key
else:
sheet_dict[site].cell(coords=(row_reach,col_reach), value='N/A') ##Key
sheet_dict[site].cell(coords=(row_reach,col_reach+1), value=key2) ##Value
row_reach +=1
##Lifestyle Stats
row_lifestyle = 3; col_lifestyle = 6
for w in sorted(stats_lifestyle[site].items(), key=lambda(k,v):(v,k), reverse=True):
sheet_dict[site].cell(coords=(row_lifestyle,col_lifestyle), value=w[0]) ##Key
sheet_dict[site].cell(coords=(row_lifestyle,col_lifestyle + 1), value=w[1]) ##Value
row_lifestyle +=1
sheet_count +=1
save(workbook, name + '.xlsx')
''' print Symptom Info to excel file '''
rindex = 1
cindex = 0
for record in results:
for fieldname in fieldnames :
ws.cell(coords=(rindex, cindex, ), value = record[fieldname] )
cindex += 1
rindex += 1
cindex = 0
print ".",
print " "
curdir = os.path.abspath(os.curdir)
print "Excel Saving : " + curdir + "\\" + outputexcel
from xlsxcessive.xlsx import save
save(wb, outputexcel)
print "Processing End ....."
exit()
cindex += 1
if sum_total_count != 0 :
ws.cell(coords=(rindex, cindex, ), value = sum_total_time/sum_total_count )
else :
ws.cell(coords=(rindex, cindex, ), value = 0 )
rindex += 1
cindex = 0
print ".",
print "."
''' save the AppAccum'''
excelExceptPath = "AppAccum" + "_" + modelname + ".xlsx"
print "Saving ressult to Excel file : ", excelExceptPath
save(wb, excelExceptPath )
print "Saved...."
''' ====================================================================================='''
endtime = datetime.now()
print endtime
print " elasped time is : ", endtime - starttime
print "Proces End ....."
Jobfinished()
ws.cell(coords=(rindex, cindex, ), value = strh )
else:
ws.cell(coords=(rindex, cindex, ), value = dictSVClogs[fieldname] )
cindex += 1
rindex += 1
cindex = 0
print ".",
print " "
curdir = os.path.abspath(os.curdir)
excelsummary = excelsavingname + "_" + "SVCsummary" + "_" + period + ".xlsx"
print "Excel Saving : " + curdir + "\\" + excelsummary
save(wb, excelsummary )
wb = 0
''' ========================= MLT LOG ======================================='''
''' Build the summary of model of the MLT '''
wb = Workbook()
ws = wb.new_sheet(period) # insert at the end (default)
rindex = 0
cindex = 0
''' first, insert field name to row0 '''
def gen_xlsx(list_main, stats_dem, stats_lifestyle, workbook, name):
sheet_dict = {}
sheet_dict['Research'] = workbook.new_sheet('Research')
site_row = 3
index_dem = 1
dem_dict = {}
ls_dict = {}
##Determine How many distinct Demographic fields are present
dem_max_dict = []
dem_max_index = 1
for site2 in list_main:
for key_dem in stats_dem[site2].iterkeys():
if key_dem not in dem_max_dict:
dem_max_dict.append(key_dem)
dem_max_index += 1
##Each URL in the provided input file
for site in list_main:
sheet_dict['Research'].cell(coords=(site_row, 0), value=site)
##Demographic Info
for key1 in stats_dem[site].iterkeys():
##Check if Parameter has been added
if key1 not in dem_dict.keys():
sheet_dict['Research'].cell(coords=(2, index_dem),
value=key1) ## Add Key
sheet_dict['Research'].cell(
coords=(site_row, index_dem),
value=stats_dem[site][key1]) ##Value
dem_dict[key1] = index_dem
index_dem += 1
else:
prev_index = dem_dict[
key1] ##index of parameter that has been added already
sheet_dict['Research'].cell(
coords=(site_row, prev_index),
value=stats_dem[site][key1]) ##Value
index_ls = dem_max_index + 2
prev_index = -1
##Lifestyle Stats
for key2 in stats_lifestyle[site].iterkeys():
##Check if Parameter has been added
if key2 not in ls_dict.keys():
sheet_dict['Research'].cell(coords=(2, index_ls),
value=key2) ## Add Key
sheet_dict['Research'].cell(
coords=(site_row, index_ls),
value=stats_lifestyle[site][key2]) ##Value
ls_dict[key2] = index_ls
index_ls += 1
else:
prev_index = ls_dict[
key2] ##index of parameter that has been added already
sheet_dict['Research'].cell(
coords=(site_row, prev_index),
value=stats_lifestyle[site][key2]) ##Value
site_row += 1
save(workbook, name + '.xlsx')
