From 448af8ecd7bf9db070e090c4b434da693ba0ae89 Mon Sep 17 00:00:00 2001
From: Sergey Chebotar <s.chebotar@gmail.com>
Date: Sat, 1 Apr 2023 15:58:42 +0300
Subject: Move Excel extensions to own project

---
 RhSolutions.ExcelExtensions/Column.cs | 47 +++++++++++++++++++++++++++++++++++
 1 file changed, 47 insertions(+)
 create mode 100644 RhSolutions.ExcelExtensions/Column.cs

(limited to 'RhSolutions.ExcelExtensions/Column.cs')

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];
+    }
+}
-- 
cgit v1.2.3