Fail to handle xlsx by using Astrogrep.
So here it is.
A solution to recursively read through all sheets, columns and rows in all excel files within a folder, including subfolders.
Look for any keywords you want.
requirement: openpyxl
simply pip.
用Astrogrep搞不定xlsx,干脆自己写了个
遍历目录下(包括子目录下)所有excel文件,读取所有sheet、行以及列,搜索指定关键词。
所需包: openpyxl
直接pip安装