except (InvalidFileException, BadZipFile): return False return False def parse(binary_file): file = openpyxl.load_workbook(BytesIO(binary_file)) ws = file[file.get_sheet_names()[1]] first = True for row in ws.rows: if first: first = False continue slot = str(row[0].value) + str(row[1].value) concentration = row[4].value yield OrderedDict(( ('address', slot), ('name', "concentration"), ('value', concentration), ('units', "ng/ul"), )) make_and_add_parser("xTen", parse, accept)
def parse(file): first = True for line in file.decode('ascii').split('\n'): if first: first = False continue if not line: continue cells = line.split(",") slot = cells[2].split("_")[0] concentration = cells[8] dilution_parts = cells[2].split("_")[-2:] if concentration: yield OrderedDict((('address', slot), ('name', 'concentration'), ('value', concentration), ('units', 'nM'))) try: dilution = int(dilution_parts[0]) / int(dilution_parts[1]) * 100 except ValueError: dilution = None if dilution: yield OrderedDict((('address', slot), ('name', "dilution"), ('value', dilution), ('units', "%"))) make_and_add_parser("wgs", parse, accept)
continue cells = line.split(",") slot = cells[2].split("_")[0] concentration = cells[5] dilution_parts = cells[2].split("_")[-2:] try: dilution = int(dilution_parts[0]) / int(dilution_parts[1]) * 100 except ValueError: dilution = None if concentration: yield OrderedDict(( ('address', slot), ('name', 'concentration'), ('value', concentration), ('units', 'nM') )) if dilution: yield OrderedDict(( ('address', slot), ('name', "dilution"), ('value', dilution), ('units', "%") )) make_and_add_parser("isc", parse, accept)
continue cells = line.split(",") slot = cells[2].split("_")[0] concentration = cells[8] dilution_parts = cells[2].split("_")[-2:] if concentration: yield OrderedDict(( ('address', slot), ('name', 'concentration'), ('value', concentration), ('units', 'nM') )) try: dilution = int(dilution_parts[0]) / int(dilution_parts[1]) * 100 except ValueError: dilution = None if dilution: yield OrderedDict(( ('address', slot), ('name', "dilution"), ('value', dilution), ('units', "%") )) make_and_add_parser("wgs", parse, accept)