html string in excel
Posted: Mon May 05, 2008 3:29 am
I have a string that contains html and it is written to a .xls file via a excel writer class. When I open the file with excel the column that contains the html renders in the column...I know nothing about excel but I was expecting to see just the raw string. When I attempt to save the file as a text tab delimited file the html disappears. I want to retain the html. Is there a special way to encode the html string before writing it to a file? Do I need to escape the html somehow?
Thanks.
Thanks.