Sha256: b5ffbf621f2cf89a3009c583d9ee701a86f8c6f61b41bbb9c484f72c3bbe213c
Contents?: true
Size: 1.21 KB
Versions: 1
Compression:
Stored size: 1.21 KB
Contents
require_relative '../lib/rubyfromexcel' def convert(basename) # Need the original spreadsheet spreadsheet = File.join(File.dirname(__FILE__),'sheets',"#{basename}.xlsx") # A place to put an unzipped version of the spreadsheet (could be a tmp dir, but helpful for debugging if local) unzipped_spreadsheet = File.join(File.dirname(__FILE__),'unzipped-sheets',basename) # A place to put the resulting ruby version ruby_version = File.join(File.dirname(__FILE__),'ruby-versions',"#{basename}-ruby") puts "Converting #{spreadsheet} into #{ruby_version}" # The spreadsheet needs to be unzipped before starting puts `unzip -uo #{spreadsheet} -d #{unzipped_spreadsheet}` RubyFromExcel::Process.new do self.source_excel_directory = unzipped_spreadsheet self.target_ruby_directory = ruby_version self.skip_tests = false if basename == "pruning" self.prune_except_output_sheets = ['Outputs'] self.convert_independent_of_input_sheets = ['Inputs'] end end.start! puts end if ARGV[0] convert ARGV[0] else %w{array-formulas complex-test namedReferenceTest sharedFormulaTest table-test pruning}.each do |basename| convert basename end end
Version data entries
1 entries across 1 versions & 1 rubygems
Version | Path |
---|---|
rubyfromexcel-0.0.4 | examples/create_and_test_examples.rb |