Charlene,
At 02:30 PM 6/19/2003, you wrote:
I mentioned "xml string" regarding to the StreamGenerator. It is a
well-formatted xml tree input as a stream to the
StreamGenerator. StreamGenerator will connect to a transformer (here
gnumeric + xsl) and serialize it using poi API to Excel. I can take a
look at the xml before tranforming it in my log. Basically it is working
as it should be.
Good. It's looking at the XML *result* of your transformation that you have
to figure out how to do. *Before* Excel picks it up. When you say you
"serialize it using poi API" I'm assuming that's an XML serialization. When
you say "I can take a look at the xml before transforming it in my log",
that sounds like you're looking at the source; but you also need to see the
(XML) *result* of the transform.
[source] [result]
XML => XML => Excel
X Z
The transform is happening as process X. In order to understand what X is
doing, you need to look at the XML result before process Z (which brings it
into Excel) does anything with it. Once you can look at the output of X as
XML, it's possible to see what your stylesheet is doing (not just what
process Z does with that).
It might be worth considering running the transformation over sample
instances of your source data *outside* your environment, in a conformant
processor (not necessarily the same one your process uses), for development
and testing. Then when it works, you can roll it in. This is a good way of
isolating problems so when things get sticky you don't try to solve the
wrong thing. Learning is much easier when you're actually looking at the
problem you're trying to solve, and not something else. :->
Cheers,
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