Sha256: fe15ef95f90a2c2ac6b94c1cb07b1cc96e58a430430bb8888b273052684b50fb
Contents?: true
Size: 838 Bytes
Versions: 4
Compression:
Stored size: 838 Bytes
Contents
#!/usr/bin/env ruby
require 'rbbt-util'
require 'rbbt/util/simpleopt'
$0 = "rbbt #{$previous_commands*""} #{ File.basename(__FILE__) }" if $previous_commands
options = SOPT.setup <<EOF
Description
$ rbbt tsv read_excel [options] <filename.xls|filename.xlsx>
Use - to read from STDIN
-k--key_field* Key field
-f--fields* Fields
-t--type* Type
-m--merge Merge from multiple rows
-z--zipped Assume data is zipped when merging (default is true)
-s2--sep2* Second level separator. Default /[,|]\\s?/
-h--help Print this help
EOF
if options[:help]
if defined? rbbt_usage
rbbt_usage
else
puts SOPT.doc
end
exit 0
end
excelfile = ARGV.first
raise ParameterException, "No excel file given" if excelfile.nil?
options[:zipped] ||= true if options[:merge]
require 'rbbt/tsv/excel'
puts TSV.excel(excelfile, options).to_s
Version data entries
4 entries across 4 versions & 1 rubygems