I'm not sure if this is the most appropriate group to post this question, but I'm sure if it isn't, someone will point me to a better group for this.
I have an ASP.NET (v1.1) VB program that is generating an XML file that automatically loads into Excel via changing the ContentHeader. That part is working fine. In fact the entire thing is working, EXCEPT for my attempt to get multiple lines via a line break within a single cell. Before anyone asks, yes, the style of the cell allows for wrapping. :-) I've figured out that what needs to be in the XML where the line break occurs is the string " ". However, when I try to append that value to the text, and export to the XML stream, it gets interpreted and changed to "
", which of course doesn't produce the line feed. I can't seem to figure out how I can get this to end up as the proper string in the final XML output. I've done a bunch of Googling, but haven't found a real answer that pertains to how I am coding this. Any advice would be much appreciated! Thanks, Larry
