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:
