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)