title: I create the defined names but i need to know how to use it (caxlsx gem)
body: <p>With <a href="https://github.com/caxlsx/caxlsx" rel="nofollow noreferrer">https://github.com/caxlsx/caxlsx</a> gem I'm trying to access defined names created dynamically over iteration with an <code>each_with_index</code> array method and giving each one with a name like &quot;piece-0&quot;, &quot;piece-1&quot;, &quot;piece-3&quot;... etc. On the file, the names are correctly created but I need the formula for sum many calling them by the name.</p>
  <pre><code>she.add_row [&quot;Total&quot;,&quot;&quot;,&quot;&quot;] + [&quot;--the sum of cells by name must be here--&quot;]
  </code></pre>
  <p><strong>I create the names but I need to know how to use them.</strong></p>