Move Excel extensions to own project

1 files changed, 24 insertions, 0 deletions

diff --git a/RhSolutions.ExcelExtensions/TableCell.cs b/RhSolutions.ExcelExtensions/TableCell.cs
new file mode 100644
index 0000000..822673e
--- /dev/null
+++ b/RhSolutions.ExcelExtensions/TableCell.cs
@@ -0,0 +1,24 @@
+namespace RhSolutions.ExcelExtensions;
+
+public sealed class TableCell : Table
+{
+    public Row ParentRow
+    {
+        get => ParentTable.Rows[ParentTable.Range.Row - Range.Row];
+    }
+    public Column ParentColumn
+    {
+        get => ParentTable.Columns[ParentTable.Range.Column - Range.Column];
+    }
+    public object Value
+    {
+        get => Range.Cells[1, 1].Value2;
+        set => Range.Cells[1, 1].Value2 = value;
+    }
+
+    public TableCell(Range range, Table table) : base(range, table)
+    {
+        Range = range;
+        ParentTable = table;
+    }
+}