def __init__(self, **keywords):
        if ("filename" in keywords): 
            self.filename = keywords["filename"]
        if self.filename:
            try:
                xbook = xlrd.open_workbook(self.filename)        
            except IOError:
                xbook = xlrd.open_workbook(music21.trecento.__path__[0] + os.sep + self.filename)

            
            if ("sheetname" in keywords): 
                self.sheetname = keywords["sheetname"]
            
            self.sheet = xbook.sheet_by_name(self.sheetname)
            self.totalRows = self.sheet.nrows
            self.rowDescriptions = self.sheet.row_values(0)
Example #2
0
if (sys.argv[1].count(':') == 1):
    (book1name, sheetname1) = sys.argv[1].split(':')
    if (book1name.count('.xls') == 0):
        book1name += ".xls"
else:
    raise ("First name must be in form filename:sheetname")

if (sys.argv[2].count(':') == 1):
    (book2name, sheetname2) = sys.argv[2].split(':')
else:
    (book2name, sheetname2) = (sys.argv[2], sheetname1)

if (book2name.count('.xls') == 0):
    book2name += ".xls"
    
book1 = xlrd.open_workbook(book1name)
book2 = xlrd.open_workbook(book2name)

sheet1 = book1.sheet_by_name(sheetname1)
sheet2 = book2.sheet_by_name(sheetname2)

totalRows1 = sheet1.nrows
totalRows2 = sheet2.nrows
extraRows = 0
longsheet = 0

if (totalRows1 > totalRows2):
    longsheet = 1
    extraRows = (totalRows1 - totalRows2)
    minRows = totalRows2
elif (totalRows1 < totalRows2):