title: Use EPPlus to translate the location of the Excel Cell
body: <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>