title: xlwings output to iterative cell range
body: <p>I have a large dataset that I do not have direct access to and am trying to convert the data headers into column headings using Python and then returning it back to Excel. </p>
  
  <p>I have created the function to do this and it works but I have hit a snag. What I want the Excel VBA to do is loop down the range and if the cell's value matches the criteria call the Python function and return the resulting list items in the columns moving across from the original cell.  For example:</p>
  
  <p><code>A1</code> holds the string to format, the functions returns <code>B1</code>, <code>C1</code>, <code>D1</code>, and so on. I can only get this to work if I hard code <code>B1</code>, <code>C1</code>, <code>D1</code>, etc.</p>
  
  <p>Is there a way to do this via the <code>get_address()</code> range method? I think I can then use the <code>offset()</code> method but am not sure.</p>