def init(): args = sys.argv[1:] if len(args) == 0: route = raw_input("> [route_parser] Insert a route to query with, or nothing to run a test route.] \n \ > ") if len(args) == 0: route = "4-40 Beach Dr Even#, 650-776 Mountjoy Ave Even#, 2019-2027 Runnymede Ave Odd# (19)" print "[route_parser] No args provided - Running the following test route: " print route parsedroute = parse(route) print "[route_parser] Parsed the test route: \n", parsedroute ex = Export() ex.set_login_details(None, None) ex.set_parsed_routes(parsedroute) ex.generate_excel() print "[route_parser] Successfully parsed route description and wrote data to file." return wb = load_workbook(filename = '%s' % args[0], read_only=True) ws = wb[wb.get_sheet_names()[0]] print ws result = [] for row in ws.iter_rows(): for cell in row: if cell.column == 5 and cell.value != None: print cell.value print result
def test_basic_export(): ex = Export() ex.set_login_details(None, None) searchdict = {"City": "Colwood"} ex.set_search_dict(searchdict) ex.generate_excel()
def test_basic_export(): ex = Export() ex.set_login_details(None, None) ex.set_parsed_routes([["SELLECK WAY",[3223]]]) ex.generate_excel()
def test_parse_export(): ex = Export() ex.set_login_details(None, None) parsedroutes = route_parser.parse("4-40 Beach Dr Even#, 650-776 Mountjoy Ave Even#, 2019-2027 Runnymede Ave Odd# (19)") ex.set_parsed_routes(parsedroutes) ex.generate_excel()
def test_basic_export(): ex = Export() ex.set_login_details(None, None) searchdict = {"City" : "Colwood"} ex.set_search_dict(searchdict) ex.generate_excel()