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