Parse Excel Submission Form

parse-submission-form.py

from openpyxl import load_workbook


wb = load_workbook(filename = 'SubmissionForm.xlsx')
sheet = wb.get_sheet_by_name(wb.sheetnames[0])
header_row = sheet.rows[0]

for row in sheet.rows[1:]:

    # Ignore empty rows 
    if row[0].value is None:
        continue

    for header, cell in zip(header_row, row):
        if header.value is None:
            continue

        print('{}\n\t{}'.format(header.value, cell.value))

Output:

Sample Name (no caps)
    example123
Species
    Homo Sapiens
Type of sample (Cell, Tissue DNA/RNA, etc.)
    HEK293T DNA Extract
Researcher 
    John Smith
Concentration [ng/uL] (if applicable)
    100 ng/uL
Service (Select from drop-down menu)
    DNA seq
Volume (if applicable)
    75 uL
Dissolved in (select from drop-down menu)
    TE Buffer
Additional Notes
    cells are mutated with radiation