def test_excel_range_parser(self, ranges, expected_result):
     result = WorksheetData.parse_excel_notation(ranges)
     assert len(expected_result) == len(result)
     for match in range(len(expected_result)):
         for param in expected_result[match]:
             assert param in result[match] and result[match][
                 param] == expected_result[match][param]
    def test_defined_ranges_different_inputs(self, path, ranges, defined_names,
                                             expected_result_path):
        wb_path = os.path.join(os.path.dirname(__file__), path)
        wb = WorksheetData(
            wb_path, {
                "ranges": WorksheetData.parse_excel_notation(ranges),
                "named_ranges": defined_names
            })
        wb.parse()
        res_path = os.path.join(os.path.dirname(__file__),
                                expected_result_path)
        with open(res_path, 'r') as file:
            expected = file.read()

        assert json.loads(expected.strip()) == json.loads(
            json.dumps(wb.result, default=WorksheetData.serializer))
    def test_worksheet_data_multiple_sheets(self, path, ranges, defined_names,
                                            expected_result_path):
        wb_path = os.path.join(os.path.dirname(__file__), path)
        wb = WorksheetData(
            wb_path, {
                "ranges":
                WorksheetData.parse_excel_notation(ranges),
                "named_ranges":
                WorksheetData.parse_defined_names_notation(defined_names)
            })
        wb.parse()
        res_path = os.path.join(os.path.dirname(__file__),
                                expected_result_path)
        with open(res_path, 'r') as file:
            expected = file.read()
        expected = json.loads(expected.strip())
        actual = json.loads(
            json.dumps(wb.result, default=WorksheetData.serializer))
        # Python 3.6 and 2.7 have different dictionary iteration order, so the _keys
        # are the same, but in different order
        expected["sheets"]["_keys"].sort()
        actual["sheets"]["_keys"].sort()

        expected = sort_json_arrays(expected)
        actual = sort_json_arrays(actual)
        assert expected == actual
 def test_defined_ranges_different_wrong_inputs(self, path, ranges,
                                                defined_names,
                                                expected_result_path):
     wb_path = os.path.join(os.path.dirname(__file__), path)
     wb = WorksheetData(wb_path, {
         "ranges": ranges,
         "named_ranges": defined_names
     })
     with pytest.raises((FunctionError_, FunctionException_)):
         wb.parse_sheet_ranges(ranges)
         wb.parse_named_ranges(defined_names)
 def test_no_arguments_fails(self, path, ranges, defined_names,
                             expected_result_path):
     # Test that wrong input raises a FunctionError
     with pytest.raises((FunctionException_, FunctionError_)):
         wb_path = os.path.join(os.path.dirname(__file__), path)
         wb = WorksheetData(
             wb_path, {
                 "ranges":
                 WorksheetData.parse_excel_notation(ranges),
                 "named_ranges":
                 WorksheetData.parse_defined_names_notation(defined_names)
             })
         wb.parse()
 def test_worksheet_data_single_cell(self, path, ranges, defined_names,
                                     expected_result_path):
     wb_path = os.path.join(os.path.dirname(__file__), path)
     wb = WorksheetData(
         wb_path, {
             "ranges":
             WorksheetData.parse_excel_notation(ranges),
             "named_ranges":
             WorksheetData.parse_defined_names_notation(defined_names)
         })
     wb.parse()
     res_path = os.path.join(os.path.dirname(__file__),
                             expected_result_path)
     with open(res_path, 'r') as file:
         expected = file.read()
     # comparing objects is a work around for the difference in iteration through dictionaries in Python 2 and 3
     # which creates different json dumps
     assert json.loads(expected.strip()) == json.loads(
         json.dumps(wb.result, default=WorksheetData.serializer))
    def test_defined_names(self, path, ranges, defined_names,
                           expected_result_path):
        wb_path = os.path.join(os.path.dirname(__file__), path)
        wb = WorksheetData(
            wb_path, {
                "ranges":
                WorksheetData.parse_excel_notation(ranges),
                "named_ranges":
                WorksheetData.parse_defined_names_notation(defined_names)
            })
        wb.parse()
        res_path = os.path.join(os.path.dirname(__file__),
                                expected_result_path)
        with open(res_path, 'r') as file:
            expected = file.read()

        expected = sort_json_arrays(json.loads(expected.strip()))
        actual = sort_json_arrays(
            json.loads(json.dumps(wb.result,
                                  default=WorksheetData.serializer)))
        assert expected == actual