def refreshList(self, path = '/Volumes/fs3/encoding/AssetManagement/nbc_incoming/'): #set default path workbook = '/Volumes/dam/OPERATOR/AKARAMIAN/armenScripts/python/spreadsheetChecker/NBCU_Features_Series_MASTER-test.xls' print path self.incomingFilePath = path incomingList = sc.getFilenames(path) #get new filenames xlsDic = si.breakdownXLS(workbook) listofmatches = sc.findMatches(incomingList, xlsDic) #get duplicates for duplicate in listofmatches: #remove duplicates from new file list incomingList.remove(duplicate) si.insertNewRows(incomingList, xlsDic) #append new files to spreadsheet si.updateWorkbook(workbook, xlsDic) self.createListBox(0,0,80,30,"Incoming Files", incomingList) #put list information on gui self.createListBox(0,1,80,20,"Duplicates", listofmatches)
def refreshList(self): workbook = '/Volumes/dam/OPERATOR/AKARAMIAN/armenScripts/python/spreadsheetChecker/NBCU_Features_Series_MASTER.xls' TESTOUTPUT = '/Volumes/dam/OPERATOR/AKARAMIAN/armenScripts/python/spreadsheetChecker/NBCU_Features_Series_MASTER.xls' incomingList = sc.getFilenames(self.incomingFilePath) #get new filenames # print incomingList xlsDic = si.breakdownXLS(workbook) listofmatches = sc.findMatches(incomingList, xlsDic) #get duplicates for duplicate in listofmatches: #remove duplicates from new file list # print duplicate.filename incomingList.remove(duplicate) si.insertNewRows(incomingList, xlsDic) #append new files to spreadsheet si.updateWorkbook(TESTOUTPUT, xlsDic) #update .xls file self.createListBox(0,0,30,"Incoming Files", incomingList) #put list information on gui self.createListBox(0,1,20,"Duplicates",listofmatches)
def submitRows(self):
workbook = si.insertNewRows(
self.entryList,
self.excelDictionary) #append new files to spreadsheet
si.updateWorkbook(self.excelfile, workbook)
self.__init__()
def refreshList(self,
path='/Volumes/fs3/encoding/AssetManagement/nbc_incoming/'
): #set default path
workbook = '/Volumes/dam/OPERATOR/AKARAMIAN/armenScripts/python/spreadsheetChecker/NBCU_Features_Series_MASTER-test.xls'
print path
self.incomingFilePath = path
incomingList = sc.getFilenames(path) #get new filenames
xlsDic = si.breakdownXLS(workbook)
listofmatches = sc.findMatches(incomingList, xlsDic) #get duplicates
for duplicate in listofmatches: #remove duplicates from new file list
incomingList.remove(duplicate)
si.insertNewRows(incomingList,
xlsDic) #append new files to spreadsheet
si.updateWorkbook(workbook, xlsDic)
self.createListBox(0, 0, 80, 30, "Incoming Files",
incomingList) #put list information on gui
self.createListBox(0, 1, 80, 20, "Duplicates", listofmatches)
def refreshList(self,excelfile='/Volumes/fs3/encoding/AssetManagement/NBCU_Features_Series_MASTER.xls', path='/Volumes/fs3/encoding/AssetManagement/nbc_incoming/'): #set default path try: incomingList = sc.getFilenames(path) #get new filenames workbook = si.breakdownXLS(excelfile) listofmatches = sc.findMatches(incomingList, workbook) #get duplicates for duplicate in listofmatches: #remove duplicates from new file list incomingList.remove(duplicate) incomingList.sort() workbook = si.insertNewRows(incomingList, workbook) #append new files to spreadsheet si.updateWorkbook(workbook) except IndexError, e: print e
def submitRows(self):
workbook = si.insertNewRows(self.entryList, self.excelDictionary) # append new files to spreadsheet
si.updateWorkbook(self.excelfile, workbook)
self.__init__()
