public void IsSheetEmptyTest() { InteropExcel.Application application = new InteropExcel.Application(); try { InteropExcel.Workbook workbook = application.OpenWorkbook("TestData.xlsx", false); // Get the target range that will be used to set the active sheet InteropExcel.Name targetName = workbook.Names.GetNamedRange("TestRangeTarget"); // Activate the worksheet which contains the named range. ((_Worksheet)targetName.RefersToRange.Worksheet).Activate(); InteropExcel._Worksheet worksheet = workbook.ActiveSheet as InteropExcel._Worksheet; bool expected = true; bool actual; actual = WorksheetExtensions.IsSheetEmpty(worksheet); Assert.AreEqual(expected, actual); } finally { application.Close(); } }
public void GetRangeTest() { InteropExcel.Application application = new InteropExcel.Application(); try { InteropExcel.Workbook book = application.OpenWorkbook("TestData.xlsx", false); InteropExcel._Worksheet worksheet = book.ActiveSheet as InteropExcel._Worksheet; // Get the named range stored in the test data excel file. InteropExcel.Name expected = book.Names.GetNamedRange("GetRange"); InteropExcel.Range firstCell = worksheet.Cells[9, 5]; int rowSize = 8; int columnSize = 5; InteropExcel.Range actual = null; // Get the range using the custom extension methods. actual = WorksheetExtensions.GetRange(worksheet, firstCell, rowSize, columnSize); Assert.AreEqual(expected.RefersToRange.Address, actual.Address); } finally { application.Close(); } }
public static void GetCell___Should_throw_ArgumentNullException___When_parameter_worksheet_is_null() { // Arrange, Act var actual = Record.Exception(() => WorksheetExtensions.GetCell(null, A.Dummy <PositiveInteger>(), A.Dummy <PositiveInteger>())); // Assert actual.Should().BeOfType <ArgumentNullException>(); actual.Message.Should().Contain("worksheet"); }
public static void GetRange___Should_throw_ArgumentNullException___When_parameter_worksheet_is_null() { // Arrange var startRowNumber = 5; var endRowNumber = 10; var startColumnNumber = 30; var endColumnNumber = 35; // Act var actual = Record.Exception(() => WorksheetExtensions.GetRange(null, startRowNumber, endRowNumber, startColumnNumber, endColumnNumber)); // Assert actual.Should().BeOfType <ArgumentNullException>(); actual.Message.Should().Contain("worksheet"); }
public void GetRangeNameForActiveCellTest() { InteropExcel.Application application = new InteropExcel.Application(); try { InteropExcel.Workbook workbook = application.OpenWorkbook("TestData.xlsx", false); // Initialize Ranges workbook.Names.GetNamedRange("TestRangeOne").Visible = false; workbook.Names.GetNamedRange("TestRangeTwo").Visible = false; workbook.Names.GetNamedRange("TestRangeThree").Visible = false; workbook.Names.GetNamedRange("TestRangeTarget").Visible = false; // Get the target range that will be used to set the active sheet InteropExcel.Name targetName = workbook.Names.GetNamedRange("TestRangeTarget"); // Activate the worksheet which contains the named range. ((_Worksheet)targetName.RefersToRange.Worksheet).Activate(); InteropExcel._Worksheet worksheet = workbook.ActiveSheet as InteropExcel._Worksheet; // Select a cell in this sheet Range activeCell = targetName.RefersToRange.Cells[1, 1]; activeCell.Select(); Dictionary <string, string> namedRanges = new Dictionary <string, string>(); // Build the dictionary of name : address pairs namedRanges["TestRangeOne"] = workbook.Names.GetNamedRange("TestRangeOne").RefersToRange.Address; namedRanges["TestRangeTwo"] = workbook.Names.GetNamedRange("TestRangeTwo").RefersToRange.Address; namedRanges["TestRangeThree"] = workbook.Names.GetNamedRange("TestRangeThree").RefersToRange.Address; namedRanges["TestRangeTarget"] = workbook.Names.GetNamedRange("TestRangeTarget").RefersToRange.Address; string expected = "TestRangeTarget"; string actual; actual = WorksheetExtensions.GetRangeNameForActiveCell(worksheet, activeCell, namedRanges); Assert.AreEqual(expected, actual); } finally { application.Close(); } }