예제 #1
0
 def get_lists_from_excel(self):
     xls = CommonExcel(basic.get_excel_path(self.name, self.d['file']))
     self.ordered = True
     try:
         self.url_list = xls.read_excel_collumn_for_urls(4, 1)
         self.id_list = xls.read_excel_collumn_for_ids(0, 1)
         self.shop_look_list = xls.read_excel_collumn(1, 1)
         self.shop_line_list = xls.read_excel_collumn(2, 1)
         try:
             self.order_list = xls.read_excel_collumn_for_ids(6, 1)
         except:
             self.ordered = False
             self.log.add_message("No order provided in this sheet.")
     except IOError as e:
         msg = "I/O error {0}: {1}".format(e.errno, e.strerror)
         msg += "\nError occurred for given file: {0}".format(self.d['file'])
         self.exc.code_handler(103, msg=msg)
     except StandardError:
         msg = "Error reading excel file"
         msg += "\nError occurred for given file: {0}".format(self.d['file'])
         self.exc.code_handler(103, msg=msg)
예제 #2
0
파일: shop.py 프로젝트: marjevtic/testMarko
 def __init__(self, xls_file, xml):
     from modules.excel import CommonExcel
     path = "xls/express/{0}.xls".format(xls_file)
     self.excel = CommonExcel(path)
     self.xls_file = xls_file
     self.xml = xml