You could also consider simply using XSLT with EXPath to insert your
XML data directly into an Excel template file. This is after all just
a zip compressed package comprising XML files - if you're using Excel
2007/2010. This would allow you to use cell formatting and styles
already setup in your template file.
The EXPath Zip module functions take care of the zip file insertion
(and extraction), more details at:
http://www.expath.org/modules/zip/
Phil Fearon
http://qutoric.com
On Tue, Mar 2, 2010 at 9:04 PM, Kendall Shaw <kshaw(_at_)kendallshaw(_dot_)com>
wrote:
"KARR, DAVID (ATTSI)" <dk068x(_at_)att(_dot_)com> writes:
-----Original Message-----
From: Martin Honnen [mailto:Martin(_dot_)Honnen(_at_)gmx(_dot_)de]
Sent: Tuesday, March 02, 2010 10:53 AM
To: xsl-list(_at_)lists(_dot_)mulberrytech(_dot_)com
Subject: Re: [xsl] How to prevent "question mark in block" characters
converting xml to csv?
KARR, DAVID (ATTSI) wrote:
This is partially an Excel question, but I'm writing a stylesheet to
convert an XML file to a CSV, and I have to do some things to make
it
a
valid CSV, like quoting the values, escaping quotes, etcetera. One
thing that I don't see how to solve is that if the resulting CSV
field
has embedded newlines, when I view the result in Excel, the end of
each
embedded line has a "question mark in block" character. How do I
have
to massage the transformed xml data to prevent that?
Maybe using
for carriage return/line break suffices to make Excel happy.
Thanks, but that doesn't appear to help. It results in two consecutive
"question mark in block" characters". No response on the Excel
newsgroup so far.
Maybe you are asking how to avoid producing newlines in the output? If
that is the case, it would depend on your XSLT, the data you are
processing and possibly your xslt processor.
Kendall
--~------------------------------------------------------------------
XSL-List info and archive: http://www.mulberrytech.com/xsl/xsl-list
To unsubscribe, go to: http://lists.mulberrytech.com/xsl-list/
or e-mail:
<mailto:xsl-list-unsubscribe(_at_)lists(_dot_)mulberrytech(_dot_)com>
--~--
--~------------------------------------------------------------------
XSL-List info and archive: http://www.mulberrytech.com/xsl/xsl-list
To unsubscribe, go to: http://lists.mulberrytech.com/xsl-list/
or e-mail: <mailto:xsl-list-unsubscribe(_at_)lists(_dot_)mulberrytech(_dot_)com>
--~--