public void SaveExcelToOriginalFile_ColumnsChanged() { Excel.Application xlApp; Excel.Workbook xlWorkBook; bool result = ExcelImporterExporter.LoadExcelFromFile( Environment.CurrentDirectory + @"\TestData\TestALFScheduler", out xlApp, out xlWorkBook); if (!result) { Assert.Fail(); } Excel.Worksheet xlWorkSheet = (Excel.Worksheet)xlWorkBook.Worksheets.get_Item(1); xlWorkSheet.Cells[1, 1] = "TEST"; xlWorkSheet.Cells[1, 2] = "VALUES"; result = ExcelImporterExporter.SaveWorkbookToOriginalFile(xlWorkBook); if (!result) { Assert.Fail(); } ExcelImporterExporter.CloseExcelApp(xlApp, xlWorkBook); result = ExcelImporterExporter.LoadExcelFromFile( Environment.CurrentDirectory + @"\TestData\TestALFScheduler", out xlApp, out xlWorkBook); if (!result) { Assert.Fail(); } xlWorkSheet = (Excel.Worksheet)xlWorkBook.Worksheets.get_Item(1); Assert.AreEqual("TEST", xlWorkSheet.Cells[1, 1].Value.ToString()); Assert.AreEqual("VALUES", xlWorkSheet.Cells[1, 2].Value.ToString()); ExcelImporterExporter.CloseExcelApp(xlApp, xlWorkBook); }
public void LoadExcelFromFile_Success() { Excel.Application xlApp; Excel.Workbook xlWorkBook; bool result = ExcelImporterExporter.LoadExcelFromFile( Environment.CurrentDirectory + @"\TestData\TestALFScheduler", out xlApp, out xlWorkBook); if (!result) { Assert.Fail(); } Assert.IsTrue(result); ExcelImporterExporter.CloseExcelApp(xlApp, xlWorkBook); }
public void LoadExcelFromFile_VerifyColumns_Success() { Excel.Application xlApp; Excel.Workbook xlWorkBook; bool result = ExcelImporterExporter.LoadExcelFromFile( Environment.CurrentDirectory + @"\TestData\TestALFScheduler", out xlApp, out xlWorkBook); if (!result) { Assert.Fail(); } Excel.Worksheet xlWorkSheet = (Excel.Worksheet)xlWorkBook.Worksheets.get_Item(1); Assert.AreEqual("ID", xlWorkSheet.Cells[1, 1].Value.ToString()); Assert.AreEqual("Name", xlWorkSheet.Cells[1, 2].Value.ToString()); ExcelImporterExporter.CloseExcelApp(xlApp, xlWorkBook); }
public static void CreateExcelFileForTests(TestContext textContext) { InitializeTestDirectory(); Excel.Application xlApp = new Excel.Application(); Excel.Workbook WorkBook = xlApp.Workbooks.Add(Type.Missing); Excel.Worksheet xlWorkSheet = (Excel.Worksheet)WorkBook.Worksheets.get_Item(1); xlWorkSheet.Cells[1, 1] = "ID"; xlWorkSheet.Cells[1, 2] = "Name"; xlWorkSheet.Cells[2, 1] = "1"; xlWorkSheet.Cells[2, 2] = "One"; xlWorkSheet.Cells[3, 1] = "2"; xlWorkSheet.Cells[3, 2] = "Two"; xlApp.DisplayAlerts = false; WorkBook.SaveAs(Environment.CurrentDirectory + @"\TestData\TestALFScheduler", Microsoft.Office.Interop.Excel.XlFileFormat.xlWorkbookDefault, Type.Missing, Type.Missing, false, false, Microsoft.Office.Interop.Excel.XlSaveAsAccessMode.xlNoChange, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing); ExcelImporterExporter.CloseExcelApp(xlApp, WorkBook); }