<br> tag create seperate row in exported excel

ColdFusion Add comments

Exporting data into excel sheet with HTML <br> tag creates separate row which really cause problem sorting excel column when there are multiple column. After doing lots of googling I found really simple solution which will line break in excel cell in spite of creating separate row.

Add following css definition in header section and it will solve your problem. 

<style>
    br {mso-data-placement:same-cell;}
</style>

1 response to “&lt;br&gt; tag create seperate row in exported excel ”

  1. Ads Says:
  2. personal fitness gold coast Says:
    I subscribed to your blog when is the next post

Leave a Reply




Powered by Mango Blog. Design and Icons by N.Design Studio | Menu Apycom
RSS Feeds