Checks for duplicate values for a column in an Excel file. Requires libreoffice.

dups.sh

# usage:
# arg1: xls file
# arg2: col position to check for dups
#
# file name without extension
base_name=$(echo $1 | cut -d. -f1)

# convert to csv
libreoffice --headless --convert-to csv $1 --outdir .

# cut out the column specified and check for dups
cut -d, -f${2} "${base_name}.csv" | sort | uniq -d > "$base_name.dups"

echo "$(wc -l "$base_name.dups") duplicated column values"

rm ${base_name}.csv