Guest User

Untitled

a guest
Jun 21st, 2018
67
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.08 KB | None | 0 0
  1. # Open workbook and assign worksheet
  2. try:
  3. wb = openpyxl.load_workbook(metadata)
  4. shtEditionLNM = wb.worksheets[0] # Edition date & latest NM
  5. shtChartsTitles = wb.worksheets[1] # Charts & Titles
  6. shtDepthHeight = wb.worksheets[4] # Depth & heights
  7. shtChartProj = wb.worksheets[7] # Chart Projection
  8. except:
  9. raise SystemExit(0)
  10.  
  11. new = wb.create_sheet()
  12. new.title = "MT_CHARTS INFO"
  13. new.sheet_properties.tabColor = "1072BA"
  14. shtMeta = wb.get_sheet_by_name("MT_CHARTS INFO")
  15.  
  16. for row in shtChartsTitles.rows:
  17. shtMeta.append([row[0].value, row[1].value, row[2].value, row[4].value])
  18. for row in shtEditionLNM.rows:
  19. shtMeta.append([row[3].value, row[4].value])
  20.  
  21.  
  22. wb.save('OW - Quarterly Extract of Metadata for Raster Charts Dec 2015.xlsx')
  23.  
  24. x=0
  25. for row in shtEditionLNM.rows:
  26. x+=1
  27. shtMeta.cell(coordinate="E{}".format(x)).value = row[3].value
  28. shtMeta.cell(coordinate="F{}".format(x)).value = row[4].value
Add Comment
Please, Sign In to add comment