1 files changed, 47 insertions, 0 deletions
diff --git a/RhSolutions.AddIn/ExcelTable/ExcelColumn.cs b/RhSolutions.AddIn/ExcelTable/ExcelColumn.cs
new file mode 100644
index 0000000..7d72cd5
--- /dev/null
+++ b/RhSolutions.AddIn/ExcelTable/ExcelColumn.cs
@@ -0,0 +1,47 @@
+using System.Collections;
+
+namespace RhSolutions.ExcelTable;
+
+public sealed class ExcelColumn : ExcelTable, IEnumerable<ExcelTableCell>
+{
+    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 ExcelColumn(Range range, ExcelTable table) : base(range, table)
+    {
+        Range = range;
+        ParentTable = table;
+    }
+
+    public ExcelTableCell this[int index]
+    {
+        get => new(Range.Cells[index + 1, 1], ParentTable);
+    }
+
+    public IEnumerator<ExcelTableCell> GetEnumerator()
+    {
+        return new ExcelColumnEnumerator(Range, ParentTable);
+    }
+
+    IEnumerator IEnumerable.GetEnumerator() => GetEnumerator();
+
+
+    public ExcelColumn AddLeft()
+    {
+        Range.EntireColumn
+            .Insert(XlInsertShiftDirection.xlShiftToRight,
+                XlInsertFormatOrigin.xlFormatFromRightOrBelow);
+
+        return ParentTable.Columns[this.Index - 1];
+    }
+}