title: pylightxl - xlsx file doesn't display newlines until after I click into the cell
body: <p>I have new lines working without issue, but the problem is they don't render until the cell is clicked. See:</p>
  <p><a href="https://youtu.be/DP1OeikETHg" rel="nofollow noreferrer">https://youtu.be/DP1OeikETHg</a></p>
  <p>Here is the code snippet writing the above:</p>
  <pre><code>db = xl.Database()
  for ip_address, inventory in device_inventories.items():
      logging.info(&quot;Processing &quot; + ip_address)
      db.add_ws(ip_address, {'A1': {'v': 10, 'f': '', 's': ''}, 'A2': {'v': 20, 'f': '', 's': ''}})  # TODO - I need to fix this
      x = 1
      for subsystem, items in inventory.items():
          y = 1
          db.ws(ip_address).update_index(row=y, col=x, val=subsystem)
          logging.debug(&quot;Processing &quot; + subsystem)
          for device, values in items.items():
              y = y + 1
              string = &quot;&quot;
              for key, value in values.items():
                  string = string + key + &quot;: &quot; + str(value) + &quot;\n&quot;
              db.ws(ip_address).update_index(row=y, col=x, val=string)
          x = x + 1
  xl.writexl(db, 'updated.xlsx')
  </code></pre>
  <p>I've tried swapping it out with <code>\r\n</code> and all that does is double space everything which tells me Excel isn't doing something like adding the <code>\r</code> in the background. At this point I'm not even sure it's a problem in code or if there's just a knob I can hit on Excel that says, &quot;Render this please.&quot;</p>