def test_16_error_report_cell_refs_columns(self): sheet = reapplication.open_csv("invalid.csv") with self.assertRaises(reapplication.ContentValidationException): try: fcs, skip = reapplication.validate_csv_contents(sheet) except reapplication.ContentValidationException as e: report = reapplication.generate_spreadsheet_error_object(sheet, e) assert report["6529-5440"].has_key(56), report["6529-5440"] assert report["6529-5440"][56] == ( "6529-5440", "53) Enter the URL where this information can be found **", 56, "AO", # the 41st column should be AO. AA is the 27th, AO is 14 after that (O is the 15th letter in the alphabet) "Invalid URL." ), report["6529-5440"][56] raise e
def test_15_error_report_cell_refs_rows(self): sheet = reapplication.open_csv("invalid.csv") with self.assertRaises(reapplication.ContentValidationException): try: fcs, skip = reapplication.validate_csv_contents(sheet) except reapplication.ContentValidationException as e: report = reapplication.generate_spreadsheet_error_object(sheet, e) assert report["4567-8901"].has_key(56), report["4567-8901"] assert report["4567-8901"][56] == ( "4567-8901", "53) Enter the URL where this information can be found **", 56, "E", "Invalid URL." ), report["4567-8901"][56] raise e