Subject: Re: problem converting xml to excel
From: Anna Bikkina <anna@xxxxxxxxxxxxxx>
Date: Fri, 12 Mar 2004 13:38:19 -0500
|
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
|