/usr/lib/python2.7/dist-packages/openpyxl/reader/tests/test

from __future__ import absolute_import
# Copyright (c) 2010-2015 openpyxl

import pytest

import codecs
from io import BytesIO
from zipfile import ZipFile

# package imports
from openpyxl.reader.excel import load_workbook
from openpyxl.utils.indexed_list import IndexedList
from openpyxl.styles.styleable import StyleArray
from openpyxl.xml.functions import fromstring

from openpyxl.styles import (
    borders,
    numbers,
    Color,
    Font,
    PatternFill,
    GradientFill,
    Border,
    Side,
    Alignment,
    Protection,
)
from openpyxl.xml.functions import Element


@pytest.fixture
def StyleReader():
    from ..style import SharedStylesParser
    return SharedStylesParser


@pytest.mark.parametrize("value, expected",
                         [
                         ('f', False),
                         ('0', False),
                         ('false', False),
                         ('1', True),
                         ('t', True),
                         ('true', True),
                         ('anyvalue', True),
                         ])
def test_bool_attrib(value, expected):
    from .. style import bool_attrib
    el = Element("root", value=value)
    assert bool_attrib(el, "value") is expected


def test_unprotected_cell(StyleReader, datadir):
    datadir.chdir()
    with open ("worksheet_unprotected_style.xml") as src:
        reader = StyleReader(src.read())
    from openpyxl.styles import Font
    reader.font_list = IndexedList([Font(), Font(), Font(), Font(), Font()])
    reader.protections = IndexedList([Protection()])
    reader.parse_cell_styles()
    styles  = reader.cell_styles
    assert len(styles) == 3
    # default is cells are locked
    assert styles[0] == StyleArray()
    assert styles[1] == StyleArray([4,0,0,0,0,0,0,0,0])
    assert styles[2] == StyleArray([3,0,0,0,1,0,0,0,0])


def test_read_cell_style(datadir, StyleReader):
    datadir.chdir()
    with open("empty-workbook-styles.xml") as content:
        reader = StyleReader(content.read())
    reader.parse()
    styles  = reader.cell_styles
    assert len(styles) == 2
    assert reader.cell_styles[0] == StyleArray()
    assert reader.cell_styles[1] == StyleArray([0,0,0,9,0,0,0,0,1])


def test_read_xf_no_number_format(datadir, StyleReader):
    datadir.chdir()
    with open("no_number_format.xml") as src:
        reader = StyleReader(src.read())

    from openpyxl.styles import Font
    reader.font_list = [Font(), Font()]
    reader.parse_cell_styles()

    styles = reader.cell_styles
    assert len(styles) == 3
    assert styles[0] == StyleArray()
    assert styles[1] == StyleArray([1,0,1,0,0,0,0,0,0])
    assert styles[2] == StyleArray([0,0,0,14,0,0,0,0,0])


def test_read_complex_style_mappings(datadir, StyleReader):
    datadir.chdir()
    with open("complex-styles.xml") as content:
        reader = StyleReader(content.read())
    reader.parse()
    styles  = reader.cell_styles
    assert len(styles) == 29
    assert styles[-1] == StyleArray([6,5,0,0,0,0,0,0,0])


def test_read_complex_fonts(datadir, StyleReader):
    from openpyxl.styles import Font
    datadir.chdir()
    with open("complex-styles.xml") as content:
        reader = StyleReader(content.read())
    fonts = list(reader.parse_fonts())
    assert len(fonts) == 8
    assert fonts[7] == Font(size=12, color=Color(theme=9), name="Calibri", scheme="minor")


def test_read_complex_fills(datadir, StyleReader):
    datadir.chdir()
    with open("complex-styles.xml") as content:
        reader = StyleReader(content.read())
    fills = list(reader.parse_fills())
    assert len(fills) == 6


def test_read_complex_borders(datadir, StyleReader):
    datadir.chdir()
    with open("complex-styles.xml") as content:
        reader = StyleReader(content.read())
    borders = list(reader.parse_borders())
    assert len(borders) == 7


def test_read_simple_style_mappings(datadir, StyleReader):
    datadir.chdir()
    with open("simple-styles.xml") as content:
        reader = StyleReader(content.read())
    reader.parse()
    styles  = reader.cell_styles
    assert len(styles) == 4
    assert styles[1].numFmtId == 9
    assert styles[2].numFmtId == 164


def test_read_complex_style(datadir):
    datadir.chdir()
    wb = load_workbook("complex-styles.xlsx")
    ws = wb.active
    assert ws.column_dimensions['A'].width == 31.1640625

    #assert ws.column_dimensions['I'].font == Font(sz=12.0, color='FF3300FF', scheme='minor')
    assert ws.column_dimensions['I'].fill == PatternFill(patternType='solid', fgColor='FF006600', bgColor=Color(indexed=64))

    assert ws['A2'].font == Font(sz=10, name='Arial', color=Color(theme=1))
    assert ws['A3'].font == Font(sz=12, name='Arial', bold=True, color=Color(theme=1))
    assert ws['A4'].font == Font(sz=14, name='Arial', italic=True, color=Color(theme=1))

    assert ws['A5'].font.color.value == 'FF3300FF'
    assert ws['A6'].font.color.value == 9
    assert ws['A7'].fill.start_color.value == 'FFFFFF66'
    assert ws['A8'].fill.start_color.value == 8
    assert ws['A9'].alignment.horizontal == 'left'
    assert ws['A10'].alignment.horizontal == 'right'
    assert ws['A11'].alignment.horizontal == 'center'
    assert ws['A12'].alignment.vertical == 'top'
    assert ws['A13'].alignment.vertical == 'center'
    assert ws['A15'].number_format == '0.00'
    assert ws['A16'].number_format == 'mm-dd-yy'
    assert ws['A17'].number_format == '0.00%'

    assert 'A18:B18' in ws._merged_cells

    assert ws['A19'].border == Border(
        left=Side(style='thin', color='FF006600'),
        top=Side(style='thin', color='FF006600'),
        right=Side(style='thin', color='FF006600'),
        bottom=Side(style='thin', color='FF006600'),
    )

    assert ws['A21'].border == Border(
        left=Side(style='double', color=Color(theme=7)),
        top=Side(style='double', color=Color(theme=7)),
        right=Side(style='double', color=Color(theme=7)),
        bottom=Side(style='double', color=Color(theme=7)),
    )

    assert ws['A23'].fill == PatternFill(patternType='solid', start_color='FFCCCCFF', end_color=(Color(indexed=64)))
    assert ws['A23'].border.top == Side(style='mediumDashed', color=Color(theme=6))

    assert 'A23:B24' in ws._merged_cells

    assert ws['A25'].alignment == Alignment(wrapText=True)
    assert ws['A26'].alignment == Alignment(shrinkToFit=True)


def test_none_values(datadir, StyleReader):
    datadir.chdir()
    with open("none_value_styles.xml") as src:
        reader = StyleReader(src.read())
    fonts = tuple(reader.parse_fonts())
    assert fonts[0].scheme is None
    assert fonts[0].vertAlign is None
    assert fonts[1].u is None


def test_alignment(datadir, StyleReader):
    datadir.chdir()
    with open("alignment_styles.xml") as src:
        reader = StyleReader(src.read())
    reader.parse_cell_styles()
    styles = reader.cell_styles
    assert len(styles) == 3
    assert styles[2] == StyleArray([0,0,0,0,0,2,0,0,0])

    assert reader.alignments == [
        Alignment(),
        Alignment(textRotation=180),
        Alignment(vertical='top', textRotation=255),
        ]


def test_style_names(datadir, StyleReader):
    datadir.chdir()
    with open("complex-styles.xml") as src:
        reader = StyleReader(src.read())

    def sorter(value):
        return value.name

    names = reader._parse_style_names()
    references = [dict(style) for style in sorted(names.values(), key=sorter)]
    assert references == [
        {'builtinId': '9', 'name': 'Followed Hyperlink', 'xfId': '10', 'hidden':'1'},
        {'builtinId': '8', 'name': 'Hyperlink', 'xfId': '9', 'hidden':'1'},
        {'builtinId': '0', 'name': 'Normal', 'xfId': '0'}
    ]


def test_named_styles(datadir, StyleReader):
    from openpyxl.styles.named_styles import NamedStyle
    from openpyxl.styles.fonts import DEFAULT_FONT
    from openpyxl.styles.fills import DEFAULT_EMPTY_FILL

    datadir.chdir()
    with open("complex-styles.xml") as src:
        reader = StyleReader(src.read())

    reader.border_list = list(reader.parse_borders())
    reader.fill_list = list(reader.parse_fills())
    reader.font_list = list(reader.parse_fonts())
    reader.parse_named_styles()
    assert set(reader.named_styles.keys()) == set(['Followed Hyperlink', 'Hyperlink', 'Normal'])

    followed = reader.named_styles['Followed Hyperlink']
    assert followed.name == "Followed Hyperlink"
    assert followed.font == reader.font_list[2]
    assert followed.fill == DEFAULT_EMPTY_FILL
    assert followed.border == Border()

    link = reader.named_styles['Hyperlink']
    assert link.name == "Hyperlink"
    assert link.font == reader.font_list[1]
    assert link.fill == DEFAULT_EMPTY_FILL
    assert link.border == Border()

    normal = reader.named_styles['Normal']
    assert normal.name == "Normal"
    assert normal.font == reader.font_list[0]
    assert normal.fill == DEFAULT_EMPTY_FILL
    assert normal.border == Border()


def test_no_styles():
    from .. style import read_style_table
    archive = ZipFile(BytesIO(), "a")
    assert read_style_table(archive) is None


def test_rgb_colors(StyleReader, datadir):
    datadir.chdir()
    with open("rgb_colors.xml") as src:
        reader = StyleReader(src.read())

    reader.parse_color_index()
    assert len(reader.color_index) == 64
    assert reader.color_index[0] == "00000000"
    assert reader.color_index[-1] == "00333333"


def test_custom_number_formats(StyleReader, datadir):
    datadir.chdir()
    with codecs.open("styles_number_formats.xml", encoding="utf-8") as src:
        content = src.read().encode("utf8") # Python 2.6, Windows
        reader = StyleReader(content)

    reader.parse_custom_num_formats()
    assert reader.custom_number_formats == {
        43:'_ * #,##0.00_ ;_ * \-#,##0.00_ ;_ * "-"??_ ;_ @_ ',
        176: "#,##0.00_ ",
        180: "yyyy/m/d;@",
        181: "0.00000_ "
    }
    assert reader.number_formats == [
        '_ * #,##0.00_ ;_ * \-#,##0.00_ ;_ * "-"??_ ;_ @_ ',
        "#,##0.00_ ",
        "yyyy/m/d;@",
        "0.00000_ "
    ]


def test_assign_number_formats(StyleReader):

    reader = StyleReader("<root />")
    reader.custom_number_formats = {43:'_ * #,##0.00_ ;_ * \-#,##0.00_ ;_ * "-"??_ ;_ @_ '}
    reader.number_formats = IndexedList(['_ * #,##0.00_ ;_ * \-#,##0.00_ ;_ * "-"??_ ;_ @_ '])

    node = fromstring("""
    <xf xmlns="http://schemas.openxmlformats.org/spreadsheetml/2006/main"
         numFmtId="43" fontId="2" fillId="0" borderId="0"
         applyFont="0" applyFill="0" applyBorder="0" applyAlignment="0" applyProtection="0">
          <alignment vertical="center"/>
    </xf>
    """)
    styles = reader._parse_xfs(node)

    assert styles[0] == StyleArray([2, 0, 0, 164, 0, 1, 0, 0, 0]) #StyleId(numFmtId=164, fontId=2, alignmentId=1)
python-openpyxl 2.3.0-1 / usr / lib / python2.7 / dist-packages / openpyxl / reader / tests / test_style.py
