Re: problem converting xml to excel

Play the video

Subject: Re: problem converting xml to excel
From: Wendell Piez <wapiez@xxxxxxxxxxxxxxxx>
Date: Fri, 12 Mar 2004 12:14:46 -0500

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

Current Thread

problem converting xml to excel
- Anna Bikkina - Thu, 11 Mar 2004 17:06:49 -0500 (EST)
  - Anna Bikkina - Fri, 12 Mar 2004 11:36:52 -0500 (EST)
    - Michael Kay - Fri, 12 Mar 2004 12:07:29 -0500 (EST)
    - Wendell Piez - Fri, 12 Mar 2004 12:31:09 -0500 (EST) <=
      - Anna Bikkina - Fri, 12 Mar 2004 13:38:29 -0500 (EST)
      - Wendell Piez - Fri, 12 Mar 2004 14:36:40 -0500 (EST)
      - Roger L. Costello - Fri, 12 Mar 2004 14:54:57 -0500 (EST)
      - Wendell Piez - Fri, 12 Mar 2004 15:34:41 -0500 (EST)

<- Previous	Index	Next ->
RE: problem converting xml to, Michael Kay	Thread	Re: problem converting xml to, Anna Bikkina
Re: Create XSL with Saxon, Wendell Piez	Date	RE: Trouble with namespaces a, James J. Ramsey
	Month

PURCHASE STYLUS STUDIO ONLINE TODAY!

Purchasing Stylus Studio from our online shop is Easy, Secure and Value Priced!

Download The World's Best XML IDE!

Accelerate XML development with our award-winning XML IDE - Download a free trial today!

Subscribe in XML format

RSS 2.0
Atom 0.3

XML Editor - Download a 15 Day Free Trial Now >

See What's New in Stylus Studio >

Buy Stylus Studio - XML Editor - Now >