Sha256: f762226a34d6cf12cd1edd9133a5e2fb13ccad9ef6980865251dc2e746f8be4c

Contents?: true

Size: 1.08 KB

Versions: 3

Compression:

Stored size: 1.08 KB

Contents

require 'test_helper'

class SpreadsheetToArrayTest < ActiveSupport::TestCase
  
  def test_values_are_read_correctly
    assert_nothing_raised do
      
      array = array_from_excel('valid_excel_import.xls')
      
      first_line_values       = ['Objectif', 5936.535, 7730.663, 9524.791 , 11318.919, 13113.047, 14907.175, 16701.303, 18495.431]
      second_line_values      = ['Réalisé', 4635.394, 9695.558, 14755.722, 19815.886, 24876.050, 29936.214, 34996.378, 40056.542]     
      

      excel_first_line_values = array[2]
      
      excel_sec_line_values   = array[3]
      
      # Les comparaisons sont faites en string pour éviter les problèmes de précision des flottants
      assert_equal            first_line_values.map(&:to_s) , excel_first_line_values.map(&:to_s)
      assert_equal            second_line_values.map(&:to_s),   excel_sec_line_values.map(&:to_s)
    end
  end
  
  def test_exception_is_thrown_when_byte_array_entry_is_not_valid
    assert_raise RuntimeError do
      array_from_excel('invalid_file_format.txt')
    end    
  end
  
end

Version data entries

3 entries across 3 versions & 1 rubygems

Version Path
export_to_spreadsheet-0.1.2 test/spreadsheet_to_array_test.rb
export_to_spreadsheet-0.1.1 test/spreadsheet_to_array_test.rb
export_to_spreadsheet-0.1.0 test/spreadsheet_to_array_test.rb