private void GenerateExcel2()
{
ExcelMaker newExcel = new ExcelMaker();
newExcel.createDoc();
foreach (clsTestResults item in lstResults)
{
newExcel.createHeaders(rowCounter, 1, "Test Number", "A" + rowCounter, "A" + rowCounter, 0, "LIGHTGRAY", true, 14, "Black", 11);
newExcel.addData(rowCounter, 2, testCounter.ToString(), "B" + rowCounter, "B" + rowCounter, "@", false, 11);
rowCounter++;
newExcel.createHeaders(rowCounter, 1, "Test Descripion", "A" + rowCounter, "A" + rowCounter, 0, "LIGHTGRAY", true, 14, "Black", 11);
newExcel.addData(rowCounter, 2, item.Description, "B" + rowCounter, "B" + rowCounter, "@", false, 11);
rowCounter++;
newExcel.createHeaders(rowCounter, 1, "Test Input", "A" + rowCounter, "A" + rowCounter, 0, "LIGHTGRAY", true, 14, "Black", 11);
newExcel.addData(rowCounter, 2, item.Input, "B" + rowCounter, "B" + rowCounter, "@", false, 11);
rowCounter++;
newExcel.createHeaders(rowCounter, 1, "Expected Output", "A" + rowCounter, "A" + rowCounter, 0, "LIGHTGRAY", true, 14, "Black", 11);
foreach (clsCondition c in item.LstCondition)
{
conditions += "Condition: " + conditionCounter + ". " + c.Condition + " Expected output is: " + c.ExpectedOutput;
if (item.LstCondition.Count > 1)
{
conditions += Environment.NewLine;
}
conditionCounter++;
}
//reset counter
conditionCounter = 1;
newExcel.addData(rowCounter, 2, conditions, "B" + rowCounter, "B" + rowCounter, "@", false, 11);
rowCounter++;
newExcel.createHeaders(rowCounter, 1, "Actual Output", "A" + rowCounter, "A" + rowCounter, 0, "LIGHTGRAY", true, 14, "Black", 11);
conditions = "";
foreach (clsCondition c in item.LstCondition)
{
conditions += "Condition: " + conditionCounter + ". " + c.Condition + " Actual outcome is: " + c.Result;
if (item.LstCondition.Count > 1)
{
conditions += Environment.NewLine;
}
conditionCounter++;
}
//reset counter
conditionCounter = 1;
newExcel.addData(rowCounter, 2, conditions, "B" + rowCounter, "B" + rowCounter, "@", false, 11);
rowCounter++;
newExcel.createHeaders(rowCounter, 1, "Result", "A" + rowCounter, "A" + rowCounter, 0, "LIGHTGRAY", true, 14, "Black", 11);
newExcel.addData(rowCounter, 2, item.Result, "B" + rowCounter, "B" + rowCounter, "@", false, 11);
rowCounter += 2;
testCounter++;
conditions = "";
}
if (newExcel.SaveWorkBook("AutomationResults", ConfigurationManager.AppSettings["FilePath"].ToString()))
{
Console.WriteLine("Saved Excel");
}
else
{
Console.WriteLine("Failed to save excel");
}
}
private void GenerateExcel()
{
ExcelMaker newExcel = new ExcelMaker();
newExcel.createDoc();
foreach (clsTestResults item in lstResults)
{
newExcel.createHeaders(rowCounter, 1, "Test Number", "A" + rowCounter, "A" + rowCounter, 0, "LIGHTGRAY", true, 14, "Black", 14);
newExcel.addData(rowCounter, 2, testCounter.ToString(), "B" + rowCounter, "B" + rowCounter, "@", false, 11);
rowCounter++;
newExcel.createHeaders(rowCounter, 1, "Test Descripion", "A" + rowCounter, "A" + rowCounter, 0, "LIGHTGRAY", true, 14, "Black", 14);
newExcel.addData(rowCounter, 2, item.Description, "B" + rowCounter, "B" + rowCounter, "@", false, 11);
rowCounter++;
newExcel.createHeaders(rowCounter, 1, "Test Input", "A" + rowCounter, "A" + rowCounter, 0, "LIGHTGRAY", true, 14, "Black", 14);
newExcel.addData(rowCounter, 2, item.Input, "B" + rowCounter, "B" + rowCounter, "@", false, 11);
rowCounter++;
newExcel.createHeaders(rowCounter, 1, "Expected Output", "A" + rowCounter, "A" + rowCounter, 0, "LIGHTGRAY", true, 14, "Black", 14);
newExcel.addData(rowCounter, 2, item.ExpectedOutput, "B" + rowCounter, "B" + rowCounter, "@", false, 11);
rowCounter++;
newExcel.createHeaders(rowCounter, 1, "Actual Output", "A" + rowCounter, "A" + rowCounter, 0, "LIGHTGRAY", true, 14, "Black", 14);
newExcel.addData(rowCounter, 2, item.ActualOutput, "B" + rowCounter, "B" + rowCounter, "@", false, 11);
rowCounter++;
newExcel.createHeaders(rowCounter, 1, "Result", "A" + rowCounter, "A" + rowCounter, 0, "LIGHTGRAY", true, 14, "Black", 14);
newExcel.addData(rowCounter, 2, item.Result, "B" + rowCounter, "B" + rowCounter, "@", false, 11);
rowCounter++;
testCounter++;
}
System.Threading.Thread.Sleep(5000);
if (newExcel.SaveWorkBook("AutomationResults", filePath))
{
Console.WriteLine("Saved Excel");
}
else
{
Console.WriteLine("Failed to save excel");
}
}