Contents

# -*- encoding : utf-8 -*-
require File.join(File.dirname(__FILE__), 'helper')
module Readers
  class TestXlsxWriter < Test::Unit::TestCase
    def test_open
      w = Workbook::Book.new
      w.open 'test/artifacts/book_with_tabs_and_colours.xlsx'
      assert_equal([:a, :b, :c, :d, :e],w.sheet.table.header.to_symbols)
      assert_equal(90588,w.sheet.table[2][:b].value)
      assert_equal(DateTime.new(2011,11,15),w.sheet.table[3][:d].value)
     # assert_equal("#CCFFCC",w.sheet.table[3][:c].format[:background_color]) #colour compatibility turned off for now...
      assert_equal(8,w.sheet.table.first[:b].format[:width].round)
      assert_equal(4,w.sheet.table.first[:a].format[:width].round)
      assert_equal(25,w.sheet.table.first[:c].format[:width].round)
    end
    def test_open_native_xlsx
      w = Workbook::Book.new
      w.open 'test/artifacts/native_xlsx.xlsx'
      
      assert_equal([:datum_gemeld, :adm_gereed, :callnr],w.sheet.table.header.to_symbols)
      
      assert_equal("Callnr.",w.sheet.table[0][:callnr].value)
      assert_equal("2475617.00",w.sheet.table[3][:callnr].value)
      assert_equal("2012-12-03T12:30:00+00:00",w.sheet.table[7][:datum_gemeld].value.to_s)
      assert_equal("2012-12-03T09:4",w.sheet.table[6][:datum_gemeld].value.to_s[0..14])
    end

  end
end

Version data entries

5 entries across 5 versions & 1 rubygems

Version	Path
workbook-0.4.2	test/test_readers_xlsx_reader.rb
workbook-0.4.1	test/test_readers_xlsx_reader.rb
workbook-0.4	test/test_readers_xlsx_reader.rb
workbook-0.3.1	test/test_readers_xlsx_reader.rb
workbook-0.3.0	test/test_readers_xlsx_reader.rb