require 'dullard'

describe "dullard" do
  before(:each) do
    @file = File.open("testfiles/SHAPE5_CorePrePost.xlsx")
    @xlsx = Dullard::Workbook.new @file
  end
  it "can open a file" do
    @xlsx.should_not be_nil
  end

  it "can find sheets" do
    @xlsx.sheets.count.should == 3
  end

  it "can read rows" do
    @xlsx.sheets[0].rows.first.should == ["S.NO",	"PAPER ID",	"TOPIC", "AUTHOR DETAILS", "DATE OF PRESENTATION"]
  end

  it "reads the right number of rows" do
    count = 0
    @xlsx.sheets[0].rows.each do |row|
      puts row
      count += 1
    end
    count.should == 115
  end
end