public static void EnableFileForEditing(string filePath)
{
WaitHelpers.ExplicitWait();
ExcelPackage.LicenseContext = LicenseContext.NonCommercial;
var xlWorkbook = new ExcelPackage(new FileInfo(filePath));
var workSheet = xlWorkbook.Workbook.Worksheets[0];
workSheet.Protection.IsProtected = true;
xlWorkbook.Save();
}
public static void GoTo(string url)
{
WebDriver.Navigate().GoToUrl(url);
WaitHelpers.WaitUntilNoPendingAjaxRequests();
}
public static void RefreshPage()
{
WebDriver.Navigate().Refresh();
WaitHelpers.WaitUntilNoPendingAjaxRequests();
}