public void GetTextBoxesCountFromSheet1()
{
List <string> textBoxes = ExcelEditorServices.GetTextBoxes("Chart.xlsx", "Sheet1");
int count = textBoxes.Count;
Assert.AreEqual(count, 1);
}
public void GetWorkSheetCountTest()
{
List <string> sheets = ExcelEditorServices.GetWorksheetNames("Chart.xlsx");
int count = sheets.Count;
Assert.AreEqual(4, count);
}
private void btn_doWork_Click(object sender, EventArgs e)
{
if (cb_removeFormulas.Checked == true)
{
var result2 = ExcelEditorServices.ReplaceFormulasWithValues(tb_inputFile.Text);
}
MessageBox.Show("Job Done");
}
public void GetTextBoxesCountFromSheet3()
{
List <string> textBoxes = ExcelEditorServices.GetTextBoxes("Chart.xlsx", "Sheet3");
}
public void RemoveFormulasTest()
{
bool success = ExcelEditorServices.ReplaceFormulasWithValues("Chart.xlsx");
Assert.AreEqual(success, true);
}
