import_gunzip.py

import xlrd
import os
import gzip

workbook  = xlrd.open_workbook("example.xlsx")
worksheet = workbook.sheet_by_index(0)

for row_num in range(0, worksheet.nrows):
    row_values = [v.value for v in worksheet.row(row_num) if v.value]
    
    if not any(row_values):
        continue

    if row_values[0] in ['FileName', 'File Name']:
        continue

    filepath = "~/" + '/'.join(reversed(row_values))
    fullpath = os.path.expanduser(filepath)

    with gzip.open(fullpath, 'r') as f:
        for line in f:
            col_nums = len(str(line).split(','))
            print(col_nums)
            break