Exemplo n.º 1
0
        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");
            }
        }
Exemplo n.º 2
0
        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");
            }
        }