Python cell2code示例

示例#1

文件： test_compile.py 项目： tactycHQ/Saturn

    def test_string_quotes(self):
        cell = Cell(address="A1", sheet="sheet1")
        cell.value = u"hello \"world'"

        code, ast = cell2code(cell, named_ranges=[])

        assert code == u'u"hello \\"world\'"'

        RangeCore
        assert eval(code) == u"hello \"world'"

示例#2

文件： test_compile.py 项目： tactycHQ/Saturn

    def test_formula(self):
        cell = Cell(address="A1", sheet="sheet1")
        cell.formula = "10+20"

        code, ast = cell2code(cell, named_ranges=[])

        assert code == 'RangeCore.apply("add",10,20,(1, \'A\'))'

        RangeCore
        assert eval(code) == 30

示例#3

文件： test_compile.py 项目： tactycHQ/Saturn

    def test_formula_string_unicode(self):
        cell = Cell(address="A1", sheet="sheet1")
        cell.formula = "=IF(1, \"a☺\", \"b☺\")"

        code, ast = cell2code(cell, named_ranges=[])

        assert code == u'("a☺" if 1 else "b☺")'

        RangeCore
        assert eval(code) == u"a☺"

示例#4

    def test_string_unicode(self):
        cell = Cell(address="A1", sheet="sheet1")
        cell.value = u"hello world ☺"

        code, ast = cell2code(cell, named_ranges=[])

        assert code == u'"hello world ☺"'

        RangeCore
        assert eval(code) == u"hello world ☺"

示例#5

文件： test_compile.py 项目： anthill/koala

    def test_formula(self):
        cell = Cell(address="A1", sheet="sheet1")
        cell.formula = "10+20"

        code, ast = cell2code(cell, named_ranges=[])

        assert code == 'RangeCore.apply("add",10,20,(1, \'A\'))'

        RangeCore
        assert eval(code) == 30

示例#6

文件： test_compile.py 项目： anthill/koala

    def test_string_quotes(self):
        cell = Cell(address="A1", sheet="sheet1")
        cell.value = u"hello \"world'"

        code, ast = cell2code(cell, named_ranges=[])

        assert code == u'u"hello \\"world\'"'

        RangeCore
        assert eval(code) == u"hello \"world'"

示例#7

文件： test_compile.py 项目： anthill/koala

    def test_formula_string_unicode(self):
        cell = Cell(address="A1", sheet="sheet1")
        cell.formula = "=IF(1, \"a☺\", \"b☺\")"

        code, ast = cell2code(cell, named_ranges=[])

        assert code == u'("a☺" if 1 else "b☺")'

        RangeCore
        assert eval(code) == u"a☺"