public void ThenICanActivateWorksheetsByNameIndex()
{
ExcelInteropHelper.ActivateSheet();
Assert.AreEqual("Test1", ExcelInteropHelper.GetActiveSheetName());
ExcelInteropHelper.ActivateSheet(2);
Assert.AreEqual("Test2", ExcelInteropHelper.GetActiveSheetName());
ExcelInteropHelper.ActivateSheet("Test1");
Assert.AreEqual("Test1", ExcelInteropHelper.GetActiveSheetName());
}
public void ThenIShouldGetActiveWorkheetName()
{
string activeSheetName = ExcelInteropHelper.GetActiveSheetName();
AssertHelpers.AssertEquals("Test1", activeSheetName);
}