Replying to my own post, looks like ex is more straightforward.

  ex -sc '0r header.txt' -c wq spreadsheet.csv

And ugly, but works for stdin:

  echo "whee" | ex -sc '0r /dev/stdin' -c wq somefile