def __init__(self, theBkNam):
# App takes an "excel.xlsx" file type
print"-" * 40
print " Reading Workbook"
print"-" * 40
self.techBucket = []#part of TechUnitsToExel(app)/fieldBooks(app)
self.UniqueList = []
self.inBook = theBkNam
# Column number is the Tech column of worksheet
self.data = None
self.techs = openBook(self.inBook).sheet_by_index(0).col(9)#part of TechUnitsToExel(app)
# Sheet is the the first sheet in the book
self.sheet = openBook(self.inBook).sheet_by_index(0) #part of TechUnitsToExel(app)
self.outBook = Workbook()
self.techOutBook = Workbook('TechList.xlsx')
self.booklist = []
self.newSheetList = ['1st', '2nd', '3rd', 'Monthly'] #part of fieldBooks(app)
def lookAtBook(self, bkNme):
return openBook(bkNme)
def newDataSheet(self, bkNme, shtIndex): self.data = openBook(bkNme).sheet_by_index(shtIndex) return self.data
def newDataset(self, bkNme, shtIndex, columnNumber):
self.data = openBook(bkNme).sheet_by_index(shtIndex).col(columnNumber)
return self.data
