new line in innerText not preserving when xml is opend in Excel

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: "Supriya" <supriya_pcl@xxxxxxxxx>
Date: Thu, 20 Dec 2007 14:21:26 +0530

Hi All,
I need to set innerText of a cell element like "line1\nline2" in XML.
When I open the xml file in Excel new line in that cell is missing.
When I insert new line in cell in Excel using ALT + ENTER and save
it is creating innerText "line1
line2".When I tried to set same value to
innerText in XML from code,
it is converting to "line1\nline2".So I am unable to get the correct cell
information when I open in Excel.
Please help me, how to set new line in the middle of innerText sothat I can
see the line when I open in Excel.
Thanks in advance.
Supriya

.

Prev by Date: Re: help - Convert XmlDocument to string
Next by Date: How to add prefix to root element?
Previous by thread: Re: help - Convert XmlDocument to string
Next by thread: How to add prefix to root element?
Index(es):
- Date
- Thread

Relevant Pages

Re: Value Metadata
... I added the two xml files but when opened in Excel it was all rejected. ... I suppose if you only need to know if the file contains metadata, ... box has no formula in it - the cell seems to be value only. ...
(microsoft.public.excel.programming)
Re: Parsing Excel spreadsheets
... I presume you talking about using Excel 2003 and saving as ... "XML Spreadsheet ". ... I extracted primarily cell contents, though I did some very limited ...
(comp.lang.python)
Re: Value Metadata
... You are right about the xml file. ... You are also right about opening the xls file in Excel 2007, but if you do so it seems that Excel 2007 treats the cell differently and the formula box has no formula in it - the cell seems to be value only. ... I converted the file to Excel 2003 format, but I couldn't find any of the metadata examples you describe below. ...
(microsoft.public.excel.programming)
Re: Value Metadata
... I was expecting you to post the xml for a sheet with only a single cell ... I converted the file to Excel 2003 format, but I couldn't find any of the ... metadata examples you describe below. ...
(microsoft.public.excel.programming)
Excels XML to HTML using data islands
... The problem with an excel created XML file is that values are all labeled "Cell" whereas in most other regular XML, the individual values have their own label: ... But I want to use the html code shown above repeatedly reading out each cell from a row, just as it does read out and displays each row from the 'root' automatically. ...
(comp.text.xml)