Convert from xls/xlsx to TSV

xls2tsv

#!/usr/bin/env ruby
require 'tmpdir'

SOFFICE = '~/Applications/LibreOffice.app/Contents/MacOS/soffice'.freeze

if ARGV.size != 1
  STDERR.puts 'usage: xls2tsv filename'
  exit 1
end

Dir.mktmpdir do |dir|
  output = `#{SOFFICE} --headless --convert-to csv --infilter=CSV:9,34,UTF8 "#{ARGV[0]}" --outdir "#{dir}"`
  path = output.match(/-> (.+?) using filter :/).to_a[1]
  open(path) do |f|
    print f.read
  end
end