Move Excel extensions to own project

1 files changed, 54 insertions, 0 deletions

diff --git a/RhSolutions.ExcelExtensions/ColumnEnumerator.cs b/RhSolutions.ExcelExtensions/ColumnEnumerator.cs
new file mode 100644
index 0000000..9880b5d
--- /dev/null
+++ b/RhSolutions.ExcelExtensions/ColumnEnumerator.cs
@@ -0,0 +1,54 @@
+using System.Collections;
+
+namespace RhSolutions.ExcelExtensions;
+
+public class ColumnEnumerator : IEnumerator<TableCell>
+{
+    public Range Range { get; }
+    public Table ParentTable { get; }
+    private int position = 0;
+    object IEnumerator.Current
+    {
+        get
+        {
+            return Current;
+        }
+    }
+
+    public TableCell Current
+    {
+        get
+        {
+            try
+            {
+                return new TableCell(Range.Cells[position, 1], ParentTable);
+            }
+            catch (IndexOutOfRangeException)
+            {
+                throw new InvalidOperationException();
+            }
+        }
+    }
+
+    public ColumnEnumerator(Range range, Table table)
+    {
+        Range = range;
+        ParentTable = table;
+    }
+
+    public bool MoveNext()
+    {
+        position++;
+        return (position <= Range.Rows.Count);
+    }
+
+    public void Reset()
+    {
+        position = 0;
+    }
+
+    public void Dispose()
+    {
+
+    }
+}