RhSolutions.ExcelExtensions/Cell.cs


1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26

namespace RhSolutions.ExcelExtensions;

public sealed class Cell
{
    public Table ParentTable { get; }
    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;
    }
    private Range _range;

    public Cell(Range range, Table table)
    {
        _range = range;
        ParentTable = table;
    }
}