Move Excel extensions to own project

1 files changed, 47 insertions, 0 deletions

diff --git a/RhSolutions.ExcelExtensions/Column.cs b/RhSolutions.ExcelExtensions/Column.cs
new file mode 100644
index 0000000..53a1f3d
--- /dev/null
+++ b/RhSolutions.ExcelExtensions/Column.cs
@@ -0,0 +1,47 @@
+using System.Collections;
+
+namespace RhSolutions.ExcelExtensions;
+
+public sealed class Column : Table, IEnumerable<TableCell>
+{
+    public string Header
+    {
+        get => Range.Cells[1, 1].Value.ToString();
+    }
+    public int Index
+    {
+        get => Range.Column - ParentTable.Range.Column;
+    }
+    public int Length
+    {
+        get => Range.Rows.Count;
+    }
+
+    public Column(Range range, Table table) : base(range, table)
+    {
+        Range = range;
+        ParentTable = table;
+    }
+
+    public TableCell this[int index]
+    {
+        get => new(Range.Cells[index + 1, 1], ParentTable);
+    }
+
+    public IEnumerator<TableCell> GetEnumerator()
+    {
+        return new ColumnEnumerator(Range, ParentTable);
+    }
+
+    IEnumerator IEnumerable.GetEnumerator() => GetEnumerator();
+
+
+    public Column AddLeft()
+    {
+        Range.EntireColumn
+            .Insert(XlInsertShiftDirection.xlShiftToRight,
+                XlInsertFormatOrigin.xlFormatFromRightOrBelow);
+
+        return ParentTable.Columns[this.Index - 1];
+    }
+}