Multi-line cell text content saved in XML

D

Dag Johansen

Hi,

I want to generate a spreadsheet as an xml file and use
text on several lines in a cell.

This works:
<Data ss:Type="String">Line 1
Line 2</Data>

This does not work:
<Data ss:Type="String">Line 1
Line 2</Data>

Trouble is, the implementation of the XML DOM I'm using
(.Net System.Xml classes) will not render the first
representation, and loading the second one in Excel
ignores the newline character.

Is this an encoding problem?
Does anyone know of a work-around?

Many thanks to all who can provide input. Regards,

Dag Johansen
dagOystein . johansen @ sage . com
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

QueryTables.Add and XML 0
Adding a dropdownlist programmatically to a ASP.NET webpage 1
xsl to xml problem during load 0
Generating Excel XML with embedded char(10)s 1
Generating Excel XML with embedded char(10)s 1
Value 1 in excel cell show as 0.99999999999999978 once save in XMLformat 3
Creating a line break (newline) in a cell with SpreadsheetML 0
How to make rows autofit when cells merge and multi line text inside 1

Top