def generatecfromobj(excel_file, pobj, pvalue): removefile("./.tmp") removefile("./" + excel_file) object_parse_childs(pobj, pvalue) wb = Workbook(style_compression=2) sheet = wb.add_sheet('CWMP-USP') xlwt.add_palette_colour("custom_colour_yellow", 0x10) xlwt.add_palette_colour("custom_colour_green", 0x20) xlwt.add_palette_colour("custom_colour_grey", 0x30) wb.set_colour_RGB(0x10, 255, 255, 153) wb.set_colour_RGB(0x20, 102, 205, 170) wb.set_colour_RGB(0x30, 153, 153, 153) style_title = xlwt.easyxf( 'pattern: pattern solid, fore_colour custom_colour_grey;' 'font: bold 1, color black;' 'alignment: horizontal center;') sheet.write(0, 0, 'OBJ/PARAM/OPERATE', style_title) sheet.write(0, 1, 'Protocols', style_title) sheet.write(0, 2, 'Supported', style_title) i = 0 file = open("./.tmp", "r") for line in file: param = line.split("::") i += 1 if param[3] == "object": style_name = xlwt.easyxf( 'pattern: pattern solid, fore_colour custom_colour_yellow') style = xlwt.easyxf( 'pattern: pattern solid, fore_colour custom_colour_yellow;' 'alignment: horizontal center;') elif param[3] == "operate": style_name = xlwt.easyxf( 'pattern: pattern solid, fore_colour custom_colour_green') style = xlwt.easyxf( 'pattern: pattern solid, fore_colour custom_colour_green;' 'alignment: horizontal center;') else: style_name = None style = xlwt.easyxf('alignment: horizontal center;') if style_name != None: sheet.write(i, 0, param[0], style_name) else: sheet.write(i, 0, param[0]) sheet.write(i, 1, param[1], style) sheet.write(i, 2, param[2], style) sheet.col(0).width = 1300 * 20 sheet.col(1).width = 175 * 20 sheet.col(2).width = 175 * 20 wb.save(excel_file) removefile("./.tmp")
def build_excel_shit(Stock1): #Workbook is created wb = Workbook() # add new colour to palette and set RGB colour value xlwt.add_palette_colour("custom_colour", 0x21) wb.set_colour_RGB(0x21, 1, 183, 2) # now you can use the colour in styles sheet1 = wb.add_sheet('Sheet 1') style = xlwt.easyxf('pattern: pattern solid, fore_colour custom_colour') sheet1.write(1, 0, 'Sales') sheet1.write(2, 0, 'Current Ratio') sheet1.write(3, 0, 'P/E') sheet1.write(4, 0, 'Graham Multiplier ') sheet1.write(5, 0, 'Eps Growth') sheet1.write(7, 0, 'ROE') sheet1.write(8, 0, 'ROI') if (Stock1.total_revenue[4] > 350000000): sheet1.write(1, 1, Stock1.total_revenue[4], style) else: sheet1.write(1, 1, Stock1.total_revenue[4]) if (Stock1.current_ratio) > 2: sheet1.write(2, 1, Stock1.current_ratio, style) else: sheet1.write(2, 1, Stock1.current_ratio) if (Stock1.p_e) > 5 and (Stock1.p_e) < 15: sheet1.write(3, 1, Stock1.p_e, style) else: sheet1.write(3, 1, Stock1.p_e) if (Stock1.graham_multiplier) < 22: sheet1.write(4, 1, Stock1.graham_multiplier, style) else: sheet1.write(4, 1, Stock1.graham_multiplier) if (Stock1.eps_growth[4]) > 0.3: sheet1.write(5, 1, Stock1.eps_growth[4], style) else: sheet1.write(5, 1, Stock1.eps_growth[4]) if (Stock1.return_on_equity) > 15: sheet1.write(7, 1, Stock1.return_on_equity, style) else: sheet1.write(7, 1, Stock1.return_on_equity) if (Stock1.return_on_invested_capital) > 15: sheet1.write(8, 1, Stock1.return_on_invested_capital, style) else: sheet1.write(8, 1, Stock1.return_on_invested_capital) wb.save('xlwt example.xls')
class ExcelCalidadArgos(): def __init__(self, ruta, nombreArchivo): self.ruta = ruta self.nombreArchivo = nombreArchivo self.wb = Workbook() self.save_workbook self.sheet = None def save_workbook(self): self.wb.save(self.ruta + '//' + self.nombreArchivo + '.xls') def add_sheet(self, sheet_name, list_columns, list_data, style_tittle, desc_Validacion): self.sheet = self.wb.add_sheet(sheet_name) self.add_write(0, round(len(list_columns) / 2), desc_Validacion, style_tittle) self.add_write(0, round(len(list_columns) / 2) + 1, desc_Validacion, style_tittle) desc_Validacion li_Row = 1 li_Column = 0 for col in list_columns: self.add_write(li_Row, li_Column, col, style_tittle) li_Column += 1 li_Row += 1 for row in list_data: li_Column = 0 for data in row: self.add_write(li_Row, li_Column, data) li_Column += 1 li_Row += 1 return self.sheet def add_write(self, row, column, content, style=''): if len(style) > 0: xlwt.add_palette_colour("custom_colour", 0x21) self.wb.set_colour_RGB(0x21, 200, 200, 100) l_style = xlwt.easyxf(style) self.sheet.write(row, column, content, l_style) else: self.sheet.write(row, column, content) def add_write_all_row(self, content, row=0, column=0, style=''): for column, heading in enumerate(content, column): self.sheet.write(row, column, heading)
def collection(file_name): quartz_file = open('../data/' + file_name, 'r') save_file_name = '../data/test_' + time.strftime( '%Y.%m.%d', time.localtime(time.time())) + '.xls' if os.path.exists(save_file_name): os.remove(save_file_name) line_lines = quartz_file.readlines() xls = Workbook(encoding='utf-8') sheet = xls.add_sheet('trigger_bpm') # 生成表头 sheet.write(0, 0, "a") sheet.write(0, 1, "b") sheet.write(0, 2, "c") sheet.write(0, 3, "d") sheet.write(0, 4, "e") xls.set_colour_RGB(8, 169, 169, 169) for i in range(0, line_lines.__len__()): line = line_lines[i] line_list = line.split('|') id = line_list[0] name = line_list[1] _id = line_list[2] enable = line_list[3] quartz = line_list[4] if id in test_list: continue sheet.write(i + 1, 0, id) sheet.write(i + 1, 1, name) sheet.write(i + 1, 2, _id) sheet.write(i + 1, 3, enable) sheet.write(i + 1, 4, quartz) if not line: break xls.save(save_file_name) quartz_file.close()
def new_xlwt_colored_workbook(): """ Get an Xlwt Workbook with the custom colors. :return: xlwt Woorkbook """ new_workbook = XWorkbook(encoding="UTF-8") new_workbook.set_colour_RGB(0x21, 139, 31, 63) new_workbook.set_colour_RGB(0x22, 255, 255, 255) new_workbook.set_colour_RGB(0x23, 31, 85, 111) add_palette_colour("custom_colour", 0x21) add_palette_colour("white", 0x22) add_palette_colour("blue", 0x23) return new_workbook
def xuat_bao_cao_SV(TW_dstk, masv): wb = Workbook() xlwt.add_palette_colour("custom_colour", 0x21) wb.set_colour_RGB(0x21, 251, 228, 228) sheet = wb.add_sheet('sheet 1') style = xlwt.easyxf('font: bold off, color black;\ borders: top_color black, bottom_color black, right_color black, left_color black,\ left thin, right thin, top thin, bottom thin;\ pattern: pattern solid, fore_color white;') style1 = xlwt.easyxf('font: bold on, color black, height 260;\ borders: top_color black, bottom_color black, right_color black, left_color black,\ left thin, right thin, top thin, bottom thin;\ pattern: pattern solid, fore_color custom_colour;\ align: vertical center, horizontal center;') style2 = xlwt.easyxf('font: bold on, color black;\ borders: top_color black, bottom_color black, right_color black, left_color black,\ left thin, right thin, top thin, bottom thin;\ pattern: pattern solid, fore_color yellow;') style3 = xlwt.easyxf('font: bold on, color black;\ borders: top_color black, bottom_color black, right_color black, left_color black,\ left thin, right thin, top thin, bottom thin;\ pattern: pattern solid, fore_color white;') cot = 5 hang = 1 ttSinhVien = XLDL.xldl_SinhVien.layThonTinSinhVien(masv.split(' ')[0]) sheet.write_merge(0, 1, 1, 3, "BÁO CÁO THỐNG KÊ ĐIỂM DANH", style1) sheet.write_merge(2, 2, 0, 1, "Mã sinh viên: " + ttSinhVien[0], style2) sheet.write_merge(2, 2, 2, 4, "Họ và tên: " + ttSinhVien[1], style2) sheet.write_merge(2, 2, 5, 6, "Giới tính: " + ttSinhVien[2], style2) sheet.write_merge(2, 2, 7, 8, "Địa chỉ: " + str(ttSinhVien[3]), style2) sum = 0 for row in range(TW_dstk.rowCount()): sum = sum + int(TW_dstk.item(row, 3).text()) sheet.write_merge(2, 2, 9, 10, "Tổng vắng: " + str(sum), style2) heder = [ "STT", "Mã lớp học", "Tên lớp học", "Tên môn học", "Tổng vắng", "Số buổi học", "Tỉ lệ đi học(%)" ] for i in range(len(heder)): # ghi các herder cwidth = sheet.col(i).width # lấy độ rộng hiện tại của column if (len(str(heder[i])) * 367) > cwidth: sheet.col(i).width = (len(str(heder[i])) * 367) sheet.write(4, 0 + i, str(heder[i]), style3) for row in range(TW_dstk.rowCount()): sheet.write(cot + row, 0, row + 1, style) for col in range(TW_dstk.columnCount()): # auto chỉnh size của cột cwidth = sheet.col(col).width # lấy độ rộng hiện tại của column if (len(TW_dstk.item(row, col).text()) * 367) > cwidth: sheet.col(col + 1).width = (len(TW_dstk.item(row, col).text()) * 367) if col == 4 or col == 3: sheet.write(cot + row, hang + col, int(TW_dstk.item(row, col).text()), style) elif col == 5: sheet.write(cot + row, hang + col, float(TW_dstk.item(row, col).text()), style) else: sheet.write(cot + row, hang + col, TW_dstk.item(row, col).text(), style) wb.save('bao_cao_SinhVien_' + masv + '.xls')
def xuat_bao_cao(TW_dstk, malophoc, nam): wb = Workbook() xlwt.add_palette_colour("custom_colour", 0x21) wb.set_colour_RGB(0x21, 251, 228, 228) sheet = wb.add_sheet('sheet 1') style = xlwt.easyxf('font: bold off, color black;\ borders: top_color black, bottom_color black, right_color black, left_color black,\ left thin, right thin, top thin, bottom thin;\ pattern: pattern solid, fore_color white;') style1 = xlwt.easyxf('font: bold on, color black, height 260;\ borders: top_color black, bottom_color black, right_color black, left_color black,\ left thin, right thin, top thin, bottom thin;\ pattern: pattern solid, fore_color custom_colour;\ align: vertical center, horizontal center;') style2 = xlwt.easyxf('font: bold on, color black;\ borders: top_color black, bottom_color black, right_color black, left_color black,\ left thin, right thin, top thin, bottom thin;\ pattern: pattern solid, fore_color yellow;') style3 = xlwt.easyxf('font: bold on, color black;\ borders: top_color black, bottom_color black, right_color black, left_color black,\ left thin, right thin, top thin, bottom thin;\ pattern: pattern solid, fore_color white;') cot = 5 hang = 1 ttlophoc = XLDL.xldl_LopHoc.layThonTinLopHoc(malophoc.split(' ')[0]) # write_merge(top_row, bottom_row, left_col , right_col) sheet.write_merge(0, 1, 1, 3, "BÁO CÁO THỐNG KÊ ĐIỂM DANH LỚP HỌC", style1) sheet.write(0, 6, "Năm: " + nam) sheet.write_merge(2, 2, 0, 1, "Mã lớp học: " + ttlophoc[0], style2) sheet.write_merge(2, 2, 2, 3, "Tên lớp học: " + ttlophoc[1], style2) sheet.write_merge(2, 2, 4, 6, "Tên giảng viên: " + ttlophoc[2], style2) sheet.write_merge(2, 2, 7, 7, "Sỉ số: " + str(ttlophoc[3]), style2) sum = 0 for row in range(TW_dstk.rowCount()): sum = sum + int(TW_dstk.item(row, 4).text()) sheet.write_merge(2, 2, 8, 9, "Tổng vắng: " + str(sum), style2) heder = [ "STT", "Mã sinh viên", "Tên sinh viên", "Lớp hinh hoạt", "giới tính", "Tổng vắng", "Tỉ lệ đi học(%)" ] for i in range(len(heder)): # ghi các herder cwidth = sheet.col(i).width # lấy độ rộng hiện tại của column if (len(str(heder[i])) * 367) > cwidth: sheet.col(i).width = (len(str(heder[i])) * 367) sheet.write(4, 0 + i, str(heder[i]), style3) dsNgay = XLDL.xldl_ThongKe.layDSngayDD(malophoc.split(' ')[0]) for i in range(len(dsNgay)): # ghi các cột ngày điểm danh cwidth = sheet.col(7 + i).width # lấy độ rộng hiện tại của column if (len(str(dsNgay[i])) * 367) > cwidth: sheet.col(7 + i).width = (len(str(dsNgay[i])) * 367) sheet.write(4, 7 + i, str(dsNgay[i]), style3) for row in range(TW_dstk.rowCount()): sheet.write(cot + row, 0, row + 1, style) for col in range(TW_dstk.columnCount()): # auto chỉnh size của cột cwidth = sheet.col(col).width # lấy độ rộng hiện tại của column if (len(TW_dstk.item(row, col).text()) * 367) > cwidth: sheet.col(col + 1).width = (len(TW_dstk.item(row, col).text()) * 367) if col == 4: sheet.write(cot + row, hang + col, int(TW_dstk.item(row, col).text()), style) elif col == 5: sheet.write(cot + row, hang + col, float(TW_dstk.item(row, col).text()), style) else: sheet.write(cot + row, hang + col, TW_dstk.item(row, col).text(), style) wb.save('bao_cao_lopHoc_' + malophoc + '.xls')
#print(running_mel_extractor_function()) print('') print('Completed MEL Extractions from TAFs') print('') import xlwt from xlwt import Workbook # Workbook is created wb = Workbook() # add new colour to palette and set RGB colour value for "Surface Icing Types:" xlwt.add_palette_colour("custom_colour1", 0x21) wb.set_colour_RGB(0x21, 242, 242, 242) # add new colour to palette and set RGB colour value for "sn = snow:" xlwt.add_palette_colour("custom_colour2", 0x22) wb.set_colour_RGB(0x22, 0, 176, 240) # add new colour to palette and set RGB colour value for "pl=sleet:" xlwt.add_palette_colour("custom_colour3", 0x23) wb.set_colour_RGB(0x23, 0, 176, 80) # #hubs_list = mel_list[54:58] #hubs_list_icao=station_ids[54:58] #print(hubs_list,hubs_list_icao) # #print(mel_list)
sheet1.write(row, column, 'Share Name') sheet1.write(row, column + 1, 'Last Date') sheet1.write(row, column + 2, 'Last Day Closing Price') sheet1.write(row, column + 3, 'Two Days Back') sheet1.write(row, column + 4, 'Two Days Back Close Price') sheet1.write(row, column + 5, 'Profit/Loss') for key, value in stocks_dict.iteritems(): row += 1 sheet1.write(row, column, value.get('company_name')) sheet1.write(row, column + 1, value.get('top_1').get('date')) sheet1.write(row, column + 2, value.get('top_1').get('close')) sheet1.write(row, column + 3, value.get('top_2').get('date')) sheet1.write(row, column + 4, value.get('top_2').get('close')) if not value.get('profit'): xlwt.add_palette_colour("custom_colour", 0x08) wb.set_colour_RGB(0x08, 255, 000, 000) message = 'Loss' else: xlwt.add_palette_colour("custom_colour", 0x21) wb.set_colour_RGB(0x21, 000, 255, 000) message = 'Profit' style = xlwt.easyxf('pattern: pattern solid, fore_colour custom_colour') sheet1.write(row, column + 5, message, style) column = 0 row += 1 wb.save('Trade.xls')
def generate_comparison(list_experiments): row = easyxf('pattern: pattern solid, fore_colour blue') col = easyxf('pattern: pattern solid, fore_colour green') header = easyxf( 'font: bold True; pattern: pattern solid, fore_colour dark_red') book = Workbook() xlwt.add_palette_colour("dark_red", 0x21) book.set_colour_RGB(0x21, 150, 0, 0) attributes = ['AVG_DEV', 'MIN_DEV', 'MAX_DEV', 'VAR_DEV', 'FITNESS'] overview_sheets = [] for attr in attributes: sheet1 = book.add_sheet("Overview %s" % attr, cell_overwrite_ok=True) overview_sheets.append(sheet1) #from random import randint #for x in xrange(1, num_uavs+1): #for y in xrange(1, num_samples+1): #style = None #val = x*y #if val < 25: #style = easyxf('pattern: pattern solid, fore_colour green') #elif val < 50: #style = easyxf('pattern: pattern solid, fore_colour white') #elif val < 75: #style = easyxf('pattern: pattern solid, fore_colour orange') #else: #style = easyxf('pattern: pattern solid, fore_colour red') #sheet1.write(x,y,str(val),style) num_uavs = 0 num_steps = 0 for experiment in list_experiments: exp_num_uavs = experiment.config.getint(GLOBAL_SECTION, "num_receivers") exp_num_steps = experiment.config.getint(GENOTYPE_SECTION, "receiver_step_count") if num_uavs < exp_num_uavs: num_uavs = exp_num_uavs if num_steps < exp_num_steps: num_steps = exp_num_steps best_phenome = experiment.get_phenome(100, 0, "FITNESS", True) if best_phenome is None: continue for attr, sheet in zip(attributes, overview_sheets): value = best_phenome[attr] value = round(value, 2) cell_value = None image_path = os.path.join(experiment.experiment_folder, "figure_best_predictions", "generation_100.jpg") image_path_abs = os.path.join( os.path.dirname(os.path.abspath(__file__)), image_path) cell_value = Formula('HYPERLINK("file://' + image_path_abs + '";' + str(value) + ')') sheet.write(exp_num_steps, exp_num_uavs, cell_value) for sheet in overview_sheets: sheet.write(0, 0, "# samples/UAVs", header) for x in xrange(1, num_steps + 1): for sheet in overview_sheets: sheet.write(x, 0, str(x), header) for y in xrange(1, num_uavs + 1): for sheet in overview_sheets: sheet.write(0, y, str(y), header) #c = 0 #for experiment in list_experiments: #sheet = book.add_sheet(str(c),cell_overwrite_ok=True) #for gen in xrange(11): #image_path = os.path.join(experiment.experiment_folder, "figure_best_predictions", "generation_" + str(max(gen*10,1)) + ".jpg") #import Image #try: #im = Image.open("./" + image_path) ##open_image(image_path) #im.save("temp.bmp", "BMP") #except: #continue #sheet.insert_bitmap("temp.bmp", gen*17+1, 0, scale_x = 0.5, scale_y= 0.5) #c += 1 book.save(os.path.join(experiment_base_folder, 'overview.xls'))
def export_excel(story_map, file_name, title=None): colors = Story.objects.filter( theme__story_map=story_map ).order_by('color').values("color") # we could use distinct here but as we want to support # sqlite, we use list(set(x)) instead. color_list = [c['color'] for c in colors] color_list = list(set(color_list)) file_name = u"{0}.xls".format(slugify(file_name)) response = HttpResponse(content_type='application/vnd.ms-excel') response['Content-Disposition'] = \ 'attachment; filename="{0}"'.format(file_name) book = Workbook() i = 0 ix = 0x21 for c in color_list: add_palette_colour("board_color_{0}".format(i), ix) color = Color(c) book.set_colour_RGB(ix, int(color.r * 255), int(color.g * 255), int(color.b * 255)) ix += 1 i += 1 header_style = easyxf( 'font: name Arial, bold True, height 250;' 'borders: bottom thin;' 'alignment: horizontal center;' 'pattern: pattern solid, fore_colour gray25;', ) sheet1 = book.add_sheet('Board') row = 0 row_head = sheet1.row(row) themes = story_map.themes.all() index = 1 for theme in themes: row_head.write(index, theme.name, header_style) sheet1.col(index).width = 5000 index += 1 phase_style = easyxf( 'alignment: horizontal center, vertical center;' 'font: bold True;' 'border: right thin, top thin;' 'pattern: pattern solid, fore_colour gray25;' ) row += 1 for phase in story_map.phases.all(): max_stories = 1 index = 1 for theme in themes: stories = phase.stories.filter(theme=theme).all() row_index = row for story in stories: color = "board_color_{0}".format(color_list.index(story.color)) style = easyxf( 'alignment: wrap True, horizontal center, vertical top;' 'border: left thin, top thin, right thin, bottom thin;' 'pattern: pattern solid, fore_colour {0};'.format(color) ) sheet1.write(row_index, index, story.title, style) row_index += 1 index += 1 max_stories = max(max_stories, len(stories)) index = 0 # write theme name sheet1.write_merge(row, (row + max_stories - 1), index, index, phase.name, phase_style) row += max_stories book.save(response) return response
# excel worksheet font control import os from xlwt import Workbook import xlwt filepath = r'C:\Codes\Snippets\sample data\output.xlsx' book = Workbook() sheet1 = book.add_sheet('font') # book.add_sheet('Sheet 2') xlwt.add_palette_colour("custom_colour", 0x21) book.set_colour_RGB(0x21, 255, 255, 0) style = xlwt.easyxf('pattern: pattern solid, fore_colour custom_colour') sheet1.write(0, 0, 'Some text', style) book.save(filepath) os.startfile(filepath)
def generate_comparison(list_experiments): row = easyxf('pattern: pattern solid, fore_colour blue') col = easyxf('pattern: pattern solid, fore_colour green') header = easyxf('font: bold True; pattern: pattern solid, fore_colour dark_red') book = Workbook() xlwt.add_palette_colour("dark_red", 0x21) book.set_colour_RGB(0x21, 150, 0, 0) attributes = ['AVG_DEV','MIN_DEV','MAX_DEV','VAR_DEV','FITNESS'] overview_sheets = [] for attr in attributes: sheet1 = book.add_sheet("Overview %s" % attr,cell_overwrite_ok=True) overview_sheets.append(sheet1) #from random import randint #for x in xrange(1, num_uavs+1): #for y in xrange(1, num_samples+1): #style = None #val = x*y #if val < 25: #style = easyxf('pattern: pattern solid, fore_colour green') #elif val < 50: #style = easyxf('pattern: pattern solid, fore_colour white') #elif val < 75: #style = easyxf('pattern: pattern solid, fore_colour orange') #else: #style = easyxf('pattern: pattern solid, fore_colour red') #sheet1.write(x,y,str(val),style) num_uavs = 0 num_steps = 0 for experiment in list_experiments: exp_num_uavs = experiment.config.getint(GLOBAL_SECTION,"num_receivers") exp_num_steps = experiment.config.getint(GENOTYPE_SECTION,"receiver_step_count") if num_uavs < exp_num_uavs: num_uavs = exp_num_uavs if num_steps < exp_num_steps: num_steps = exp_num_steps best_phenome = experiment.get_phenome(100,0,"FITNESS",True) if best_phenome is None: continue for attr, sheet in zip(attributes, overview_sheets): value = best_phenome[attr] value = round(value,2) cell_value = None image_path = os.path.join(experiment.experiment_folder, "figure_best_predictions", "generation_100.jpg") image_path_abs = os.path.join(os.path.dirname(os.path.abspath(__file__)), image_path) cell_value = Formula('HYPERLINK("file://' + image_path_abs + '";' + str(value) + ')') sheet.write(exp_num_steps,exp_num_uavs,cell_value) for sheet in overview_sheets: sheet.write(0,0,"# samples/UAVs",header) for x in xrange(1,num_steps+1): for sheet in overview_sheets: sheet.write(x,0,str(x),header) for y in xrange(1,num_uavs+1): for sheet in overview_sheets: sheet.write(0,y,str(y),header) #c = 0 #for experiment in list_experiments: #sheet = book.add_sheet(str(c),cell_overwrite_ok=True) #for gen in xrange(11): #image_path = os.path.join(experiment.experiment_folder, "figure_best_predictions", "generation_" + str(max(gen*10,1)) + ".jpg") #import Image #try: #im = Image.open("./" + image_path) ##open_image(image_path) #im.save("temp.bmp", "BMP") #except: #continue #sheet.insert_bitmap("temp.bmp", gen*17+1, 0, scale_x = 0.5, scale_y= 0.5) #c += 1 book.save(os.path.join(experiment_base_folder,'overview.xls'))
def generaExcelRankeds(listaPartidas, nombre): rutaArchivo = vars.directorioRanked + nombre + "_" + str(datetime.now().strftime("%d_%m_%Y_%H%M")) + ".xls" wb = Workbook() sheet = wb.add_sheet("Analisis Stats Ranked", cell_overwrite_ok=True) # estilos####### # color azul xlwt.add_palette_colour("custom_green_color", 0x21) wb.set_colour_RGB(0x21, 191, 255, 215) # color rojo xlwt.add_palette_colour("custom_red_color", 0x22) wb.set_colour_RGB(0x22, 251, 204, 150) styleBold = xlwt.easyxf('font: bold 1') styleNormalBlue = xlwt.easyxf( 'align: vert centre, horiz center; pattern: pattern solid, fore_colour custom_green_color') styleNormalRed = xlwt.easyxf( 'align: vert centre, horiz center; pattern: pattern solid, fore_colour custom_red_color') # /estilos###### #Ancho columnas try: sheet.col(0).width = 256 * 12 sheet.col(1).width = 256 * 24 sheet.col(2).width = 256 * 6 sheet.col(3).width = 256 * 6 sheet.col(4).width = 256 * 10 sheet.col(5).width = 256 * 15 sheet.col(6).width = 256 * 15 sheet.col(7).width = 256 * 5 sheet.col(8).width = 256 * 5 sheet.col(9).width = 256 * 5 sheet.col(10).width = 256 * 16 sheet.col(11).width = 256 * 15 sheet.col(12).width = 256 * 10 sheet.col(13).width = 256 * 5 sheet.col(14).width = 256 * 12 sheet.col(15).width = 256 * 13 sheet.col(16).width = 256 * 13 sheet.col(17).width = 256 * 13 sheet.col(18).width = 256 * 14 sheet.col(19).width = 256 * 14 sheet.col(20).width = 256 * 13 sheet.col(21).width = 256 * 15 sheet.col(22).width = 256 * 13 sheet.col(23).width = 256 * 15 sheet.col(24).width = 256 * 12 sheet.col(25).width = 256 * 12 sheet.col(26).width = 256 * 12 sheet.col(27).width = 256 * 13 sheet.col(28).width = 256 * 13 except ValueError: pass #Escribir en el excel escribeLinea(sheet,vars.titulosPlayerStatsRanked,0,styleBold) i = 1 for stats in listaPartidas: if stats[2] == "Win": escribeLinea(sheet, stats, i, styleNormalBlue) else: escribeLinea(sheet, stats, i, styleNormalRed) i = i + 2 wb.save(rutaArchivo)