def test_to_excel_styleconverter(ext): from openpyxl import styles hstyle = { "font": {"color": "00FF0000", "bold": True}, "borders": {"top": "thin", "right": "thin", "bottom": "thin", "left": "thin"}, "alignment": {"horizontal": "center", "vertical": "top"}, "fill": {"patternType": "solid", "fgColor": {"rgb": "006666FF", "tint": 0.3}}, "number_format": {"format_code": "0.00"}, "protection": {"locked": True, "hidden": False}, } font_color = styles.Color("00FF0000") font = styles.Font(bold=True, color=font_color) side = styles.Side(style=styles.borders.BORDER_THIN) border = styles.Border(top=side, right=side, bottom=side, left=side) alignment = styles.Alignment(horizontal="center", vertical="top") fill_color = styles.Color(rgb="006666FF", tint=0.3) fill = styles.PatternFill(patternType="solid", fgColor=fill_color) number_format = "0.00" protection = styles.Protection(locked=True, hidden=False) kw = _OpenpyxlWriter._convert_to_style_kwargs(hstyle) assert kw["font"] == font assert kw["border"] == border assert kw["alignment"] == alignment assert kw["fill"] == fill assert kw["number_format"] == number_format assert kw["protection"] == protection
def test_to_excel_styleconverter(ext): from openpyxl import styles hstyle = { "font": { "color": '00FF0000', "bold": True, }, "borders": { "top": "thin", "right": "thin", "bottom": "thin", "left": "thin", }, "alignment": { "horizontal": "center", "vertical": "top", }, "fill": { "patternType": 'solid', 'fgColor': { 'rgb': '006666FF', 'tint': 0.3, }, }, "number_format": { "format_code": "0.00" }, "protection": { "locked": True, "hidden": False, }, } font_color = styles.Color('00FF0000') font = styles.Font(bold=True, color=font_color) side = styles.Side(style=styles.borders.BORDER_THIN) border = styles.Border(top=side, right=side, bottom=side, left=side) alignment = styles.Alignment(horizontal='center', vertical='top') fill_color = styles.Color(rgb='006666FF', tint=0.3) fill = styles.PatternFill(patternType='solid', fgColor=fill_color) number_format = '0.00' protection = styles.Protection(locked=True, hidden=False) kw = _OpenpyxlWriter._convert_to_style_kwargs(hstyle) assert kw['font'] == font assert kw['border'] == border assert kw['alignment'] == alignment assert kw['fill'] == fill assert kw['number_format'] == number_format assert kw['protection'] == protection
def _formatComparisonWorksheet(self, worksheet): for character in 'ABCDEFGHIJKLMNOPQRSTUVWXYZ': for index in range(1, len(self.snp_table)): cell_index = character + str(index) cell = worksheet[cell_index] print(cell) value = cell.value if value == '.': cell.fill = styles.Fill(bgColor = styles.Color('00000000'), fill_type = 'solid') elif value == 'X': cell.fill = styles.PatternFill(bgColor = styles.Color('12345678'), fill_type = 'solid') return worksheet
def write(self, **kwargs): sheet = self.Sheet if "sheet" in kwargs: sheet = kwargs["sheet"] sheet.cell(row=self.Row, column=self.Column).value = self.Nickname # стиль ячейки не может быть изменён, только перезаписан fill_pattern = excel_styles.PatternFill( patternType='solid', fgColor=excel_styles.Color(CodesToColor[self.PrevCode])) sheet.cell(row=self.Row, column=self.Column).fill = fill_pattern
from rekall_lib import utils from rekall.ui import renderer from rekall.ui import text import six if six.PY3: long = int # pylint: disable=unexpected-keyword-arg,no-value-for-parameter # pylint: disable=redefined-outer-name HEADER_STYLE = styles.Style(font=styles.Font(bold=True)) SECTION_STYLE = styles.Style( fill=styles.PatternFill( fill_type=fills.FILL_SOLID, start_color=styles.Color(colors.RED))) FORMAT_STYLE = styles.Style( alignment=styles.Alignment(vertical="top", wrap_text=False)) class XLSObjectRenderer(renderer.ObjectRenderer): """By default the XLS renderer delegates to the text renderer.""" renders_type = "object" renderers = ["XLSRenderer"] STYLE = None def _GetDelegateObjectRenderer(self, item): return self.ForTarget(item, "TextRenderer")( session=self.session, renderer=self.renderer.delegate_text_renderer)
wb.save('snapshot-3.xlsx') # 시트 이름 변경 ws2.title = '이름변경 시트' wb.save('snapshot-4.xlsx') # 셀 병합 ws2.merge_cells('A1:E1') wb.save('snapshot-5.xlsx') # 셀 폰트, 정렬, 채우기 c = ws2['A1'] c.font = styles.Font('굴림', 16, True) c.alignment = styles.Alignment('center', 'center') c.fill = styles.PatternFill(patternType='solid', fgColor=styles.Color('FFC000')) wb.save('snapshot-6.xlsx') # 데이터 넣기 mat = [[1, 2, 3], [4, 5, 6], [7, 8, 9]] for r, row in enumerate(mat): for c, ele in enumerate(row): ws2.cell(r + 2, c + 1).value = ele wb.save('snapshot-7.xlsx') # 데이터 읽기 wb2 = load_workbook('snapshot-7.xlsx') ws2 = wb2.active for row in ws2.rows: print(row) for ele in row: