def test_delete_sheets(self):
     """Can delete by sheet name"""
     b1 = pe.load_book(self.testfile)
     assert len(b1.sheet_names()) == 3
     del b1["Sheet1"]
     assert len(b1.sheet_names()) == 2
     del b1["Sheet1"]  # bang, already deleted

 def test_delete_sheets2(self):
     """Can delete by index"""
     b1 = pe.load_book(self.testfile)
     assert len(b1.sheet_names()) == 3
     del b1[2]
     del b1[1]
     assert len(b1.sheet_names()) == 1
     del b1[1]  # bang, already deleted

 def test_delete_sheets2(self):
     """repetitively delete first sheet"""
     b1 = pyexcel.load_book(self.testfile)
     del b1[0]
     assert len(b1.sheet_names()) == 2
     del b1[0]
     assert len(b1.sheet_names()) == 1
     del b1[0]
     assert len(b1.sheet_names()) == 0

 def test_read_multiple_csv_into_book(self):
     book = pe.load_book(self.testfile)
     assert book.sheet_names() == ["Sheet1", "Sheet2", "Sheet3"]
     book["Sheet1"].format(int)
     assert self.content["Sheet1"] == book["Sheet1"].to_array()
     book["Sheet2"].format(int)
     assert self.content["Sheet2"] == book["Sheet2"].to_array()
     book["Sheet3"].format(int)
     assert self.content["Sheet3"] == book["Sheet3"].to_array()

 def test_read_custom_made_csvz_multiple_hseet(self):
     data = [[1, 4, 9], [2, 5, 8], [3, 6, 7]]
     book = pe.load_book(os.path.join("tests", "fixtures", "test-multiple.csvz"))
     assert book.sheet_names() == ["sheet1", "sheet2", "sheet3"]
     book[0].format(int)
     book[1].format(int)
     book[2].format(int)
     assert data == book[0].to_array()
     assert data == book[1].to_array()
     assert data == book[2].to_array()

 def test_issue_03(self):
     file_prefix = "issue_03_test"
     csv_file = "%s.csv" % file_prefix
     xls_file = "%s.xls" % file_prefix
     my_sheet_name = "mysheetname"
     data = [[1,1]]
     sheet = pe.Sheet(data, name=my_sheet_name)
     sheet.save_as(csv_file)
     assert(os.path.exists(csv_file))
     sheet.save_as(xls_file)
     book = pe.load_book(xls_file)
     assert book.sheet_names()[0] == my_sheet_name
     os.unlink(csv_file)
     os.unlink(xls_file)

 def test_delete_sheets(self):
     b1 = pyexcel.load_book(self.testfile)
     assert len(b1.sheet_names()) == 3
     del b1["Sheet1"]
     assert len(b1.sheet_names()) == 2
     try:
         del b1["Sheet1"]
         assert 1==2
     except KeyError:
         assert 1==1
     del b1[1]
     assert len(b1.sheet_names()) == 1
     try:
         del b1[1]
         assert 1==2
     except IndexError:
         assert 1==1

 def test_load_a_single_sheet4(self):
     pyexcel.load_book(self.testfile, sheet_name="Not exist")

 def test_load_a_single_sheet3(self):
     pyexcel.load_book(self.testfile, sheet_index=10000)

 def test_load_a_single_sheet2(self):
     b1 = pyexcel.load_book(self.testfile, sheet_index=2)
     assert len(b1.sheet_names()) == 1
     assert b1['Sheet3'].to_array() == self.content['Sheet3']

 def test_book_reader_to_dict2(self):
     r = pe.load_book(self.testfile)
     actual = r.to_dict()
     self.assertEqual(self.content, actual)

 def test_delete_sheets3(self):
     """Test float in []"""
     b1 = pe.load_book(self.testfile)
     del b1[1.1]

 def test_load_a_single_sheet2(self):
     b1 = pe.load_book(self.testfile, sheet_index=1)
     b1['Sheet2'].format(int)
     assert len(b1.sheet_names()) == 1
     assert b1['Sheet2'].to_array() == self.content['Sheet2']

 def test_book_reader_to_dict2(self):
     r = pe.load_book(self.testfile)
     actual = r.to_dict()
     assert actual == self.content