xsl-list
[Top] [All Lists]

Re: problem converting xml to excel

2004-03-12 10:14:46
At 11:36 AM 3/12/2004, you wrote:
I am still having the same problem. Can someone please help.

Anna, this is a long shot since I haven't touched Excel's XML import.

But try putting a literal space (using <xsl:text> </xsl:text>) or a non-breaking space (use <xsl:text>& #160;</xsl:text> with *no space* as it appears here to protect it from email-munging) into the field and see if that helps.

The commonest use for the non-breaking space (represented as '& nbsp;' in HTML, again with no space, or '& #160;' or '& #xA0;' in XML, or using whatever entity you'd like if you declare it) is probably to protect the appearance of table cells in HTML, which disappear if they have no content. You might be running into something similar.

Good luck,
Wendell


======================================================================
Wendell Piez                            
mailto:wapiez(_at_)mulberrytech(_dot_)com
Mulberry Technologies, Inc.                http://www.mulberrytech.com
17 West Jefferson Street                    Direct Phone: 301/315-9635
Suite 207                                          Phone: 301/315-9631
Rockville, MD  20850                                 Fax: 301/315-8285
----------------------------------------------------------------------
  Mulberry Technologies: A Consultancy Specializing in SGML and XML
======================================================================


XSL-List info and archive:  http://www.mulberrytech.com/xsl/xsl-list