Mickytheresurrection
New Member
I trying to combine data from one XML-file and one Excel XML-file with XSLT. I can't get it to work and wonder if I can do it like this? I have not managed to get any output and could really use some help.\[code\]<?php$xsl = new DOMDocument();$xsl->load("file1.xsl");$inputdom = new DomDocument();$inputdom->load("file1.xml");$proc = new XSLTProcessor();$xsl = $proc->importStylesheet($xsl);$proc->setParameter(null, "", "");$newdom = $proc->transformToDoc($inputdom);print $newdom-> saveXML();\[/code\].xslHow to use the ss prefix?\[code\]<?xml version="1.0" encoding="utf-8"?><xsl:stylesheet version="1.0"xmlns:xsl="http://www.w3.org/1999/XSL/Transform"xmlns:ss="urn:schemas-microsoft-comffice:spreadsheet"><xsl:variable name="file2" select="document('file2.xml')"></xsl:variable><xsl:template match="/Test"> <Test> <xsl:copy-of select="*" /> <xsl:copy-of select="$file2/Test/*" /> </Test></xsl:template></xsl:stylesheet>\[/code\]