empiricalthought

PS1=[\d/\t] \h:\W \u$

empiricalthought

from openpyxl import load_workbook
workbook = load_workbook(filename='./tmp/book.xlsx', read_only=True)
range = workbook.defined_names['a_named_range']
for sheet_title, sheet_coords in range.destinations:
    sheet = workbook[sheet_title]
    for row in sheet[sheet_coords]:
        print "\t".join(str(cell.value) for cell in row)

empiricalthought

#!/usr/bin/env awk -f

NR > 1 {
    for (i = 1; i <= header_count; i++) {
        print headers[i], $i
    }
}

NR == 1 {
    header_count = split($0, headers)