def assemble_chemtable(): os.chdir(projectroot + "/ALLXLFLZ/") shouldbe = [ "Vegyszer neve", "CAS száma", "Tisztasága", "Szükséges mennyiség", "Cikkszám" ] lndir = len(os.listdir(".")) strln = len(str(lndir)) chain = "\t".join(["FILE"] + shouldbe) + "\n" for i, (flnm, ws) in enumerate(iter_flz("."), start=1): print("\rProgress: {:>{w}}/{} @ {}".format(i, lndir, flnm, w=strln), end="") result = locate_table_header(ws, flnm) if not result: chain += flnm + "\t" + "-\t" * len(shouldbe) + "\n" continue row, col, extractor = result data = extract_matrix(ws, extractor, row, col, flnm) if not data: chain += flnm + "\t" + "-\t" * len(shouldbe) + "\n" continue chain += "\n".join("\t".join(line) for line in data) + "\n" print() with open(projectroot + "chem.csv", "w") as handle: handle.write(chain.replace("None", "-"))
def main(): os.chdir(project_root + "ALLXLFLZ") lndir = len(os.listdir(".")) strln = len(str(lndir)) chain = "FILE\tFOUND\tDJN_READ\tMN_READ\tAKKR\tDJN_INFERRED\tDJNAME_INF\tP\n" for i, (flnm, ws) in enumerate(iter_flz("."), start=1): print("\rProgress: {:>{w}}/{} @ {}".format(i, lndir, flnm, w=strln), end="") djname, mn, ak = extract_info(ws, flnm) djnum = extract_djnum_easy(ws) cndnm, rfnm, rno, p = infer_djnum_from_string(djname, flnm) chain += "\t".join(map(str, (flnm, djname, djnum, mn, ak, rno, rfnm, p))) + "\n" with open(project_root + "djname.csv", "w") as handle: handle.write(chain)
def main(): os.chdir(project_root + "ALLXLFLZ") chain = "FILE\tMTIME\tTTIME\tMNAME\tTNAME\n" lndir = len(os.listdir(".")) strln = len(str(lndir)) for i, (flnm, ws) in enumerate(iter_flz("."), start=1): print("\rDoing file: {:>{w}}/{}".format(i, lndir, w=strln), end="") results = extract_ws(ws, flnm) chain += flnm + "\t" chain += "\t".join(map(str, results)) + "\n" print() with open(project_root + "timereq.csv", "w") as handle: handle.write(chain)
def assemble_item_data(output=None): os.chdir(projectroot + "ALLXLFLZ") lndir = len(os.listdir(".")) strln = len(str(lndir)) chain = "FILE\tNAME\tQUANT\tOTHER_INFO->" for i, (flnm, ws) in enumerate(iter_flz("."), start=1): print("\rProgress: {:>{w}}/{} @ {}".format(i, lndir, flnm, w=strln), end="") row, col = locate_table(ws, flnm) data = extract_matrix(ws, row, col, flnm) if not data: chain += flnm + "\t" + "\t".join("-" for _ in range(3)) + "\n" continue chain += "\n".join("\t".join(line) for line in data) + "\n" with open(output, "w") as handle: handle.write(chain.replace("None", "-"))
def main(): os.chdir(project_root + "/ALLXLFLZ/") lndir = len(os.listdir(".")) strln = len(str(lndir)) chain = "FILE\tINSTRUMENT\tUSAGE\tOTHER_INFO->\n" for i, (flnm, ws) in enumerate(iter_flz("."), start=1): print("\rProgress: {:>{w}}/{} @ {}".format(i, lndir, flnm, w=strln), end="") row, col = locate_table(ws, flnm) data = extract_matrix(ws, row, col, flnm) if not data: chain += flnm + "\t" + "\t".join("-" for _ in range(3)) + "\n" continue chain += "\n".join("\t".join(line) for line in data) + "\n" with open(project_root + "instrument.csv", "w") as handle: handle.write(chain.replace("None", "-"))
def crawl(destination, source=sourceroot): cleanup(destination) for xlworksheet, xlpath in iter_flz(source): method = Method(xlpath, xlworksheet) method.dump(destination)