Added insert_worksheet to Workbook so we can add worksheets at a specific position

1 files changed, 8 insertions, 0 deletions

diff --git a/test/workbook/tc_workbook.rb b/test/workbook/tc_workbook.rb
index f10ad24a..1a9b9669 100644
--- a/test/workbook/tc_workbook.rb
+++ b/test/workbook/tc_workbook.rb
@@ -49,6 +49,14 @@ class TestWorkbook < Test::Unit::TestCase
     assert_equal(@wb.worksheets.first, ws, "the worksheet returned is the worksheet added")
     assert_equal(ws.name, "bob", "name option gets passed to worksheet")
   end
+  
+  def test_insert_worksheet
+    @wb.add_worksheet(:name => 'A')
+    @wb.add_worksheet(:name => 'B')
+    ws3 = @wb.insert_worksheet(0, :name => 'C')
+    assert_equal(ws3.name, @wb.worksheets.first.name)
+  end
+
   def test_relationships
     #current relationship size is 1 due to style relation
     assert(@wb.relationships.size == 1)