Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- # Open workbook and assign worksheet
- try:
- wb = openpyxl.load_workbook(metadata)
- shtEditionLNM = wb.worksheets[0] # Edition date & latest NM
- shtChartsTitles = wb.worksheets[1] # Charts & Titles
- shtDepthHeight = wb.worksheets[4] # Depth & heights
- shtChartProj = wb.worksheets[7] # Chart Projection
- except:
- raise SystemExit(0)
- new = wb.create_sheet()
- new.title = "MT_CHARTS INFO"
- new.sheet_properties.tabColor = "1072BA"
- shtMeta = wb.get_sheet_by_name("MT_CHARTS INFO")
- for row in shtChartsTitles.rows:
- shtMeta.append([row[0].value, row[1].value, row[2].value, row[4].value])
- for row in shtEditionLNM.rows:
- shtMeta.append([row[3].value, row[4].value])
- wb.save('OW - Quarterly Extract of Metadata for Raster Charts Dec 2015.xlsx')
- x=0
- for row in shtEditionLNM.rows:
- x+=1
- shtMeta.cell(coordinate="E{}".format(x)).value = row[3].value
- shtMeta.cell(coordinate="F{}".format(x)).value = row[4].value
Add Comment
Please, Sign In to add comment