xslt

Create Excel (SpeadsheetML) output with XSLT

I have this XML file and I want to create an XSL file to convert it to Excel. Each row should represent a logo. The columns will be the key attributes like color, id, description plus any other key for other logos. <Top> <logo> <field key="id">172-32-1176</field> <field key="color">Blue</field> <field key="description"><p...

Output table from excel using xslt

Hi I would like to output a table to a webpage. The table is stored in an excel sheet (xls). Is it possible to use xslt for this? The table is the cells are in this range: A26 - P36 (16 columns and 11 rows) If an exmaple file is need here is a link: http://finans.opengate.dk/media/6704/2010-01-13.xls Update: A daily file is uploaded....

How can i search in xsl with jquery

i want search data from xml through xsl i create xsl stylesheet and show it with jquery and now i want when the people input the keyword or select combobox macth with value of xml the xsl will show the true value example One Two and when people input One or select on combobox One and click button Find The XSL will show result is One ...

How to sum the values of several nodes in XSLT

I need a loop up to a specific node position() and sum of these nodes. For example: if my position is 2 then node[1] + node[2] if my position is 5 then node[1] + node[2] + node[3] + node[4] + node[5] How can that be done in XSLT? do have following xml <?xml-stylesheet type="text/xsl" href="sum.xsl"?><root><FIDetail Node1="5" Nod...

XSL: let raw HTML through

Im making a XSL transform. The XML I'm transforming has a node which contains html. <xml> <text> <p><b>Hello</b><em>There</em></p> </text> </xml> Applying the transform: <xsl:template match="text"> <div class="{name()} input"> <xsl:value-of select="."/> </div> </xsl:template> I get the output: <div...

How to convert XML to something else using xslt stylesheet?

How to convert XML to something else using xslt stylesheet? In C++ C# PHP or ActionScript? For example I have this html2wiki xslt stylesheet I want to send to my programm my XML (in this case HTML file ) and get back a file (in this case Wiki mark up text ) So How to translate one text file into another text file using XSLT styles...

Where to get TracWiki Formatting xslt stylesheet?

Where to get TracWiki Formatting xslt stylesheet? I'm asking because we all use TRACK SVN and TRACK WIKI so I need to do all my dok tables in it's wiki... BTW: Just in case you searched for simple Wiki xslt can be found here ...

How to write a predicate to match the dollar sign character?

Given the following document: <foo> <object> <property name="value"> <!-- MATCH THIS NODE --> <string>alpha</string> </property> <property name="name"> <string>$A$</string> </property> </object> <object> <property name="value"> <string>bravo</string> </property> <property name="name...

xslt transformation from xhtml to custom xml

For a custom application I need to transform xhtml to (custom) xml. After some experimentation I decided to give php5's XSLT functionality a try, but so far I'm unable to transform nested p tags to their xml equivalent. Basicly we have code like this: <p>Some text</p> <ol> <li><p>Some more text</p></li> .. </ol> This needs to b...

php xslt transformation always adds xmlns=""

Guess the title says it al, somehow my xslt transformation with php always adds xmlns="" as an attribute to all root elements. Is there a way to prevent this? ...

XSLT: Select following-sibling until reaching a specified tag

I am attempting to write XSLT that will run a for-each on the selected following-siblings but stop when another tag (h1) is reached. Here's the Source XML: <?xml version="1.0"?> <html> <h1>Test</h1> <p>Test: p 1</p> <p>Test: p 2</p> <h1>Test 2</h1> <p>Test2: p 1</p> <p>Test2: p 2</p> <p>Test2: p 3</p> </html...

XSL: passing variables between templates

Is it possible to pass a variable from one parent template to its child element ? <xsl:template match="structure"> <xsl:variable name="var"><xsl:value-of select="@path" /></xsl:variable> <xsl:apply-templates select="folders"> <xsl:with-param name="var1" select="'{var}'"/> </xsl:apply-templates> </xsl:template> this template...

xslt transformation needed urgently

I am a fresh bee in xslt. i have time constraint where i have to deliver something very urgently. Could you please help me out. Thank you in advance. I am pasting the xml samples below. Here is small explanation I have input.xml and output.xml. these both files need to be merged as they have different formats. both files need to be merg...

Custom providers using XML as their data store - should I use XPath/XSLT or DOM?

Hi I’d like to learn how to create custom providers ( say custom membership provider or custom profiles ) that use XML as their data store. Is ( using C# ) best way to accomplish this using XPath/XSLT or DOM? thanx ...

XSLT. How to add a node in the leftmost leaf, with the given name?

I woud like to add a node in the leftmost leaf, with the given name. For example, <root> <aaa name="a"> <aaa name="x"/> </aaa> <aaa name="b"> <aaa name="y"> <aaa name="z"/> </aaa> </aaa> <aaa name="c"> <aaa name="z"/> </aaa> </root> Given name= "z" and given new node is <aaa name="w">. New tree should...

how to display &nbsp; in Mozilla using XSL.

How can I display &nbsp; in Mozilla using XSL. I've tried CDATA but that didn't work. I am using Firefox 3.5.5 ...

Need help with XSLT 1.0 and grouping

I have the following XML file: <Promotions> <Promotion> <Category>Arts &amp; Entertainment</Category> <Client>Client Five</Client> <Title>Get your Free 2</Title> </Promotion> <Promotion> <Category>Arts &amp; Entertainment</Category> <Client>Client 5</Client> <Title>Get your Free 4</Title> </Promotion> <...

Grouping several groups in XSLT 2

I'm trying to add hierarchy to some grotty extruded typesetting XML. I can't seem to manage grouping several kinds of groups in the same parent element at once. What I have (simplified, obviously): <article> <h1>A section title here</h1> <p>A paragraph.</p> <p>Another paragraph.</p> <bl>Bulleted list item.</bl> <bl>Another bu...

How can I exclude elements with xsi:nil="true" from a transformation?

Hi, I've got some XML files that recently changed so that some of the nodes now have the attribute xsi:nil="true". I've got an XSLT style sheet that renders the XML into HTML for some quick eyeballing of data. Currently to make things easier on myself I strip out the namespaces out of the XML before I apply the style sheet. That worke...

What am I doing wrong here, having issues with XSLT using C#

Please take a look at the following code, as I get the error at this line: xslt.Transform(mydoc.CreateReader(), writer); Error: Step into: Stepping over non-user code 'System.Xml.Linq.XNode.CreateReader' A first chance exception of type 'System.NullReferenceException' occurred in System.Data.SqlXml.dll ((System.NullReferenceExceptio...