daily pastebin goal
28%
SHARE
TWEET

Untitled

a guest Oct 12th, 2017 39 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. import openpyxl
  2. import xlrd
  3. import xlwt
  4.  
  5.  
  6. wb1 = openpyxl.load_workbook('LB_migration.xlsx')
  7. ws1 = wb1.get_sheet_by_name('Servers')
  8. #IP should be placed in Column 'J2' and continue down for as much as needd.
  9.  
  10. wb2 = openpyxl.load_workbook('ME06.xlsx')
  11. ws2 = wb2.get_sheet_by_name('Dependency_Details')
  12. #Migration server IPs are listed in Column P starting with row 2.
  13.  
  14. wb3 = openpyxl.load_workbook('MAS.xlsx')
  15. ws3 = wb3.get_sheet_by_name('massheet')
  16. #All servers listed in Netscaler configs are in column C starting in row 2
  17. #This should be the list that is parsed with the Migration server IPs
  18.  
  19. ws1.iter_rows('A1:A235')
RAW Paste Data
Top