Use EPPlus to translate the location of the Excel Cell
<p>I am new to using <a href="https://www.nuget.org/packages/EPPlus" rel="nofollow noreferrer">EPPlus</a>. </p>

<p>I want to adress a cell, relative to a starting point, what is the best way to achieve this?</p>

<p>E.g: </p>

<pre><code>var startLocation = "C5";
var newLocation1 = TLoc(startLocation, 2, 3); //E8
var newLocation2 = TLoc(startLocation, 0, 1); //C6
</code></pre>

<p>For now I wrote this method myself, because I am unfamiliar with EPPlus functionality:</p>

<pre><code>/// &lt;summary&gt;
/// Use EPPlus to translate the Location.
/// &lt;/summary&gt;
/// &lt;param name="startLocation"&gt;&lt;/param&gt;
/// &lt;param name="columns"&gt;&lt;/param&gt;
/// &lt;param name="rows"&gt;&lt;/param&gt;
/// &lt;returns&gt;&lt;/returns&gt;
private string TLoc(string startLocation, int columns, int rows)
{
    using (ExcelPackage tmpPack = new ExcelPackage())
    {
        var tmpWs = tmpPack.Workbook.Worksheets.Add("temp");
        var startCell = tmpWs.Cells[startLocation];

        int startColumn = startCell.Start.Column;
        int startRow = startCell.Start.Row;

        int tColumn = startColumn + columns;
        int tRow = startRow + rows;

        ExcelAddress translatedAddress = new ExcelAddress(tRow, tColumn, tRow, tColumn);

        return translatedAddress.ToString();
    }
}
</code></pre>

<p>Please show me an example or link me to documentation. Thank you!</p>

<p>To be more specific: examples of using EPPlus to achieve this functionality. </p>

<p>I like to use proven technology when available instead of risking the introduction of new bugs.</p>