XML Editor
Sign up for a WebBoard account Sign Up Keyword Search Search More Options... Options
Chat Rooms Chat Help Help News News Log in to WebBoard Log in Not Logged in
Show tree view Topic
Topic Page 1 2 3 4 5 6 7 8 9 Go to previous topicPrev TopicGo to next topicNext Topic
Postnext
becky goodfordSubject: xml to excel
Author: becky goodford
Date: 29 Mar 2006 02:43 PM
Originally Posted: 29 Mar 2006 11:55 AM
I know there are other discussions about this topic, but I am unable to get an answer or example of what I need. I have been creating xml to xsl:fo and html output, but now need to create an excel spreadsheet as output.<br> I have started a stylesheet and am successful, except that I am getting blank lines where in between rows.<br> In my xml I have different headings, so a row will have heading columns then data - that might be different from previous heading and data.<br> there are three sections (headings with different elements to print)<br> all the elements - however are in the xml doc, which I don't see as a problem...but as you can see by the results I need to eliminate the blank rows between my different Headings which in the xml doc is titled Section_title for the fors section_title Experience .... I only want to show the first 7 elements...then for the next section_title UBH Follow...I want to show the elements starting with a_few_days thru four_or_more and for the last section_title Impact...I want to show the last 7 elements


UnknownAstraZ.xls


UnknownAstraZeneca.xml


UnknownAstraZ(1).xls

Posttop
Minollo I.Subject: xml to excel
Author: Minollo I.
Date: 29 Mar 2006 01:48 PM
Becky,
generic XSLT questions are better asked (and answered) on the xsl-list mailing list, which specializes in general-purpose XSLT issues.

See http://www.mulberrytech.com/xsl/xsl-list/

 
Topic Page 1 2 3 4 5 6 7 8 9 Go to previous topicPrev TopicGo to next topicNext Topic
Download A Free Trial of Stylus Studio 6 XML Professional Edition Today! Powered by Stylus Studio, the world's leading XML IDE for XML, XSLT, XQuery, XML Schema, DTD, XPath, WSDL, XHTML, SQL/XML, and XML Mapping!  
go

Log In Options

Site Map | Privacy Policy | Terms of Use | Trademarks
Stylus Scoop XML Newsletter:
W3C Member
Stylus Studio® and DataDirect XQuery ™are from DataDirect Technologies, is a registered trademark of Progress Software Corporation, in the U.S. and other countries. © 2004-2016 All Rights Reserved.