aboutsummaryrefslogtreecommitdiff
path: root/RhSolutions.Tests
diff options
context:
space:
mode:
authorSergey Chebotar <s.chebotar@gmail.com>2023-04-06 08:29:39 +0300
committerSergey Chebotar <s.chebotar@gmail.com>2023-04-06 08:29:39 +0300
commitbfd7702939a162f62c46375762ceec9cd524f66a (patch)
treed496cd01929df64f013a9bfa6be7702afe30b4eb /RhSolutions.Tests
parent448af8ecd7bf9db070e090c4b434da693ba0ae89 (diff)
DI Refactoring
Diffstat (limited to 'RhSolutions.Tests')
-rw-r--r--RhSolutions.Tests/ExcelTablesTests.cs65
1 files changed, 0 insertions, 65 deletions
diff --git a/RhSolutions.Tests/ExcelTablesTests.cs b/RhSolutions.Tests/ExcelTablesTests.cs
deleted file mode 100644
index 78264ac..0000000
--- a/RhSolutions.Tests/ExcelTablesTests.cs
+++ /dev/null
@@ -1,65 +0,0 @@
-namespace RhSolutions.Tests;
-
-[ExcelTestSettings(OutOfProcess = true, Workbook = @"TestWorkbooks\ExcelTableTest.xlsx")]
-public class ExcelTablesTests : IDisposable
-{
- ExcelExtensions.Table table;
-
- public ExcelTablesTests()
- {
- Util.Application.Workbooks.Add();
-
- Worksheet worksheet = Util.Workbook.Sheets[1];
- Range range = worksheet.Range["E7:G9"];
- table = new(range);
- }
-
- [ExcelFact]
- public void CanReadExcelTable()
- {
- Assert.Equal(3, table.Columns.Where(c => c.Header.StartsWith("Столбец")).Count());
- Assert.Equal("Столбец 1", table.Rows.First()[0].Value);
- Assert.Equal("Столбец 2", table[0, 1].Value);
- Assert.Equal(123d, table[1, 1].Value);
- Assert.Null(table[1, 2].Value);
- }
-
- [ExcelFact]
- public void CanModifyTableCells()
- {
- table[2, 1].Value = 1;
- table[1, 1].Value = (double)table[1, 1].Value + 123;
- Assert.Equal(1d, table[2, 1].Value);
- Assert.Equal(246d, table[1, 1].Value);
- }
-
- [ExcelFact]
- public void CanFindInTable()
- {
- table[2, 0].Value = "Find!";
- table[2, 1].Value = "Find this!";
- table[2, 2].Value = "Find that!";
-
-
- var cells = table.Find("Find");
- Assert.Collection(cells, item => Assert.Equal("Find!", item.Value),
- item => Assert.Equal("Find this!", item.Value),
- item => Assert.Equal("Find that!", item.Value));
- Assert.Equal(0, table.Find("Значение").First().ParentColumn.Index);
- Assert.Equal(3, table.Rows[2].Find("Find").Count());
- Assert.Empty(table.Columns[1].Find("Пусто"));
- }
-
- [ExcelFact]
- public void CanAddColumns()
- {
- int originalCount = table.Columns.Count();
- table.Columns[1].AddLeft();
- Assert.Equal(originalCount + 1, table.Columns.Count());
- }
-
- public void Dispose()
- {
- Util.Application.ActiveWindow.Close(SaveChanges: false);
- }
-}