#!/usr/bin/env Python3

import openpyxl

#print(workbook['Sheet1']) # replacement of get sheet by name

wb = openpyxl.Workbook()

sheet=wb['Sheet']
print(sheet)
sheet['A1'].value== None
sheet['A1']=42
sheet['A2']="hrllo"

import os
os.chdir('FileDirectory')

wb.save('Exanoke.xlsx')

print(os.getcwd())

sheets = wb.create_sheet('YMsheet')
print(wb.sheetnames)
sheets.title='My new sheet'
print(wb.sheetnames)
wb.save('example2.xlsx')
wb.create_sheet(index=1,title='My other sheet')
wb.save('example3.xlsx')