Contents

require'spec_helper'
describe 'Axlsx template handler' do

  AB = ActionView::Template::Handlers::AxlsxBuilder
  VT = Struct.new(:source)

  let( :handler ) { AB.new }

  let( :template ) do
    VT.new("wb = xlsx_package.workbook;\nwb.add_worksheet(name: 'Test') do |sheet|\n\tsheet.add_row ['one', 'two', 'three']\n\tsheet.add_row ['a', 'b', 'c']\nend\n")
  end

  context "Rails #{Rails.version}" do
    # for testing if the author is set
    # before do
      # Rails.stub_chain(:application, :config, :axlsx_author).and_return( 'Elmer Fudd' )
    # end

    it "has xlsx format" do
      expect(handler.default_format).to eq(mime_type)
    end

    it "compiles to an excel spreadsheet" do
      xlsx_package, wb = nil
      eval( AB.call template )
      xlsx_package.serialize('/tmp/axlsx_temp.xlsx')
      expect{ wb = Roo::Excelx.new('/tmp/axlsx_temp.xlsx') }.to_not raise_error
      expect(wb.cell(2,3)).to eq('c')
    end

    #TODO:
    # Test if author field is set - does roo parse that?
  end
end

Version data entries

2 entries across 2 versions & 1 rubygems

Version	Path
axlsx_rails-0.5.1	spec/axlsx_builder_spec.rb
axlsx_rails-0.5.0	spec/axlsx_builder_spec.rb