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)
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):