

def precrawl(url):
    'Grab HTML from a link, parse links and add a row per link to spreadsheet.'
    fcols = ['linksto', 'depth', 'crawl']
    therange = ('B1:%s2' % globs.letter[(len(fcols) + 1)])
    CellList = globs.sheet.range(therange)
    vals = (((fcols + []) + []) + [])
    for (i, val) in enumerate(vals):
        CellList[i].value = val
    globs.sheet.update_cells(CellList)
    links = setolinks(CellList)
    if links:
        y = len(links)
        linkslist = zip(([url] * y), links, (['0'] * y), (['?'] * y))
        InsertRows(globs.sheet, linkslist, 2)
        return ''
    else:
        return "can't reach"

dataset/ETHPy150Open miklevin/pipulate/common.py precrawl/VarMisuse@109/176 `url`->`CellList`