def make_sertifyMe(id, sp1, sp2, xfile, doemail): data = pd.read_excel(xfile) # name_list = data["Name"].tolist() # email_list = data["Email"].tolist() # Make certificate and check if it was successful if id == '03': for i in data.iloc: filename = Draw.Certi03(i[0], sp1, sp2) if doemail: EmailDo(filename) elif id == '04': for i in data.iloc: filename = Draw.Certi04(i[0], sp1, sp2) if doemail: EmailDo(filename) elif id == '05': for i in data.iloc: filename = Draw.Certi05(i[0], sp1, sp2) if doemail: EmailDo(filename) elif id == '06': for i in data.iloc: filename = Draw.Certi06(i[0], sp1, sp2) if doemail: EmailDo(filename) elif id == '07': for i in data.iloc: filename = Draw.Certi07(i[0], sp1, sp2) if doemail: EmailDo(filename) elif id == '08': for i in data.iloc: filename = Draw.Certi08(i[0], sp1, sp2) if doemail: EmailDo(filename)