Sha256: 729d1ecd9fb7d2167adbfaef53de3cb0361262008e1a124a95873a850313bd19
Contents?: true
Size: 1.61 KB
Versions: 6
Compression:
Stored size: 1.61 KB
Contents
# encoding: utf-8 require 'spec_helper' describe SimpleSpreadsheet do describe "Open Excelx (.xlsx) file read-only mode" do before do @workbook = SimpleSpreadsheet::Workbook.read(File.join(File.dirname(__FILE__), "fixtures/file.xlsx")) end it "should can open the file" do @workbook.should_not be_nil end it "should use right class" do @workbook.class.to_s.should eq("ExcelxReader") end it "should see the right number of sheets" do @workbook.sheets.count.should eq(2) end it "should read strings from first sheets" do @workbook.cell(1,1).should eq("String1") end it "should read integer from first sheets" do @workbook.cell(1,2).should eq(1) end it "should read strings from other sheets" do @workbook.cell(1, 1, 2).should eq("String2") end it "should read integer from other sheets" do @workbook.cell(1, 2, 2).should eq(2) end it "should read strings from other sheets (way 2)" do @workbook.selected_sheet = 2 @workbook.cell(1, 1).should eq("String2") end it "should read integer from other sheets (way 2)" do @workbook.selected_sheet = 2 @workbook.cell(1, 2).should eq(2) end it "should correctly count rows" do @workbook.last_row.should eq(1) end it "should correctly count column" do @workbook.last_column.should eq(2) end # it "should parse line by line" do # @workbook.foreach(@workbook.sheets.first) do |row, index| # row[0].should eq("String1") # row[1].should eq(1.0) # index.should eq(1) # end # end end end
Version data entries
6 entries across 6 versions & 1 rubygems