public void TestExternSheetIndex()
{
HSSFWorkbook wb = new HSSFWorkbook();
wb.CreateSheet("Sheet1");
wb.CreateSheet("Sheet2");
Assert.AreEqual(0, wb.GetExternalSheetIndex(0));
Assert.AreEqual(1, wb.GetExternalSheetIndex(1));
//Assert.AreEqual("Sheet1", wb.FindSheetNameFromExternSheet(0));
//Assert.AreEqual("Sheet2", wb.FindSheetNameFromExternSheet(1));
////Assert.AreEqual(null, wb.FindSheetNameFromExternSheet(2));
//Assert.AreEqual(0, wb.GetSheetIndexFromExternSheetIndex(0));
//Assert.AreEqual(1, wb.GetSheetIndexFromExternSheetIndex(1));
//Assert.AreEqual(-1, wb.GetSheetIndexFromExternSheetIndex(2));
//Assert.AreEqual(-1, wb.GetSheetIndexFromExternSheetIndex(100));
}
public void ExternSheetIndex()
{
HSSFWorkbook wb = new HSSFWorkbook();
wb.CreateSheet("Sheet1");
wb.CreateSheet("Sheet2");
Assert.AreEqual(0, wb.GetExternalSheetIndex(0));
Assert.AreEqual(1, wb.GetExternalSheetIndex(1));
//The following methods are obsoleted
//Assert.AreEqual("Sheet1", wb.FindSheetNameFromExternSheet(0));
//Assert.AreEqual("Sheet2", wb.FindSheetNameFromExternSheet(1));
////Assert.AreEqual(null, wb.FindSheetNameFromExternSheet(2));
//Assert.AreEqual(0, wb.GetSheetIndexFromExternSheetIndex(0));
//Assert.AreEqual(1, wb.GetSheetIndexFromExternSheetIndex(1));
//Assert.AreEqual(-1, wb.GetSheetIndexFromExternSheetIndex(2));
//Assert.AreEqual(-1, wb.GetSheetIndexFromExternSheetIndex(100));
}