# excel2text - convert MS Excel files to ASCII text
#
# Written by Gary Johnson <garyjohn@spk.agilent.com>.

prog=${0##*/}

if [ $# -ne 1 ]
then
    echo "Usage: $prog file" >&2
    exit 2
fi

xlHtml -te "$1" |
perl -pe 's/>-{21,}</><HR></g' |	# This replaces long lines of
					# hyphens with HTML <HR> tags so
					# that these lines adapt to the
					# width of the cell.  "21" is a
					# value that works for the
					# tables I'm sent.
w3m -dump -T text/html |
perl -pe '
	s/\xa0/ /gs;			# Change A0 spaces to ASCII
					# spaces.
'