search.py

#!/usr/bin/python
# -*- coding: utf-8 -*-

import os
import xlrd
import argparse

def find(path, word):

    l = []
    d = os.listdir(path)

    for file in d:

        filename = str(path) +'/' + str(file)

        if filename.endswith('.xlsx') or filename.endswith('.xls'):
            wb = xlrd.open_workbook(filename)
            print('Finding in %s, Sheets:%d' % (file,len(wb.sheets())))
            for ws in wb.sheets():
                for i, row in enumerate(range(ws.nrows)):
                    for j, col in enumerate(range(ws.ncols)):
                        if str(word) in str(ws.cell_value(i, j)):
                            l.append((file,ws.name,row,col))
    if l:
        print ('Word %s found %d times in:' %(word,len(l)))

        for fn, sheet,row, col in l:
            print ('File: %s, Sheet %s, row: %s ,column: %s' %(fn,sheet,row,col))
    else:
        print ('Word %s not found' %word) 


if __name__ == "__main__":
    parser = argparse.ArgumentParser()
    parser.add_argument("path", help="Path to folder with files.")
    parser.add_argument("word", help="Word to search in xlsx files.")
    args = parser.parse_args()
    
    find(args.path, args.word)