Sep 1, 2010 at 6:04 PM
Edited Sep 7, 2010 at 5:13 PM
I am trying to output an Excel worksheet where some of the cells have double quotes. On one web server, the worksheet is created fine without any problems. However, on my production server, any text with double quotes gets truncated at the double
I have a feeling that it is related to ensuring the output is UTF-8, and have tried using the iconv functions, but the documentation is not very detailed about how this should be done. Can someone provide more detail, or perhaps this is related to
a different issue.
As further detail, when I use the function SetCellValueExplicit() to set the cell value and explicitly format it as text, nothing is placed in the cell if the text has double quotes. The truncation occurs when I set the cell value using just SetCellValue()
I am using phpExcel 1.7.4
The web server that works is running Apache on Windows XP. The web server that does not work is running IIS. The issue happens with both double-quotes and dashes that have a space preceding them. (And perhaps other yet-undiscovered characters).
I have tried utf8-encode(). This causes the text to no longer get truncated, but the offending character (double-quote, etc) is displayed as some unknown character.