Re: problem converting xml to excel

Sorry for not being clear in my initial question.The xml itself is generated 
from another source so I cant make changes to it. 

I was wondering if I can check if the string-length for a element is greater 
than 0 and then display the required results.

Is there any method like that?

Thanks,
Anna.


On Friday 12 March 2004 12:14 pm, Wendell Piez wrote:
> 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@xxxxxxxxxxxxxxxx
> 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


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