Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- pywintypes.com_error: (-2147467262, 'No such interface supported', None, None)
- def xl_vba(self, aop_src, aop_dst, gsrp_src, prod_src, year_of_int):
- xw.App(visible=False)
- # initialize row offsets
- file_list = os.listdir('%s' % aop_src)
- excel_file_index = 0
- prod_data_start_row = 3
- os.chdir((aop_src))
- for file in (file_list[excel_file_index:]):
- if file.endswith(".xlsx") and ("AOP" in file):
- current_book = xw.Book(file)
- if "Combined" not in file:
- project_sheet = current_book.sheets[1]
- else:
- for sheet in current_book.sheets:
- if "Project" in current_book[sheet].name:
- project_sheet = current_book[sheet]
- # Set Year of Interest
- project_sheet.range('J17').options(numbers=int).value = 2018
- # Set B48 According to DC Size
- dc_size = float(project_sheet.range('B3').value)
- if dc_size >= 2000:
- project_sheet.range('B48').value = 0.99
- else:
- project_sheet.range('B48').value = 0.98
- # Get fields
- losses = project_sheet.range('C88:N88').value
- net_gen = project_sheet.range('C90:N90').value
- ghi = project_sheet.range('M3:M14').value
- aop_prod = project_sheet.range('AM32').options(numbers=float).value
- project_code = "XX-03-"
- asset_id = project_sheet.range('B1').options(numbers=int).value
- project_name = project_sheet.range('B2').value
- my_date_handler = lambda month, day, year, **kwargs: "%02i%02i%04i" % (month, day, year)
- current_date = project_sheet.range('B9').options(dates=my_date_handler).value
- file_name = project_code + str(asset_id) + "-" + project_name + "-" + "AOP" + "-" + str(current_date) + ".xlsx"
- current_book.save('%s%s' % (aop_dst, file_name))
- current_book.close()
- production_book = xw.Book(prod_src)
- production_sheet = production_book.sheets[0]
- production_sheet.range('C%s' %prod_data_start_row).value = aop_prod
- production_book.save()
- production_book.close()
- excel_file_index += 1
Add Comment
Please, Sign In to add comment