I have a db table with user data. One of the columns contains comments. I am trying to format my data to pass to a class for output in XLS and CSV. Every field is working great but when it comes to comments I am having the hardest time to get it to work in XLS. I was able to make it work in CSV output by stripping all line breaks and encoding HTML characters:
$comm = htmlspecialchars(str_replace(array("
", "", "
"), "", $tx->comm));
What can I possibly do to make it work with XLS???