Search inside xlsx files (excel)

xlsx_grep

#!/usr/bin/env sh

#WIP

if [ $# -ne 2 ]; then
    echo "Usage: $0 \"search_string\" file.xlsx"
    echo " e.g.: $0 \"foo\" *.xlsx"
    exit 1
fi


ls "$2" | xargs -IXXX sh -c "xlsx2txt 'XXX' | sed s/^/XXX\:\ /g" | grep "$1"

xlsx_grep.md

Compile and install xlsx

cat for xlsx files:

ls *.xlsx | xargs -IXXX sh -c "xlsx2txt 'XXX' | sed s/^/XXX\:\ /g"

alias for that cat:

alias xlsx_grep="ls *.xlsx | xargs -IXXX sh -c \"xlsx2txt 'XXX' | gsed s/^/XXX\:\ /g\""

now grep:

xlsx_grep | grep "searched_string"

TODO:

• make script to support arguments. e.g.:

    xlsx_grep "searched_string" *.xlsx