PHP Classes

File: xsl/workbooks.xsl

Recommend this page to a friend!
  Classes of Karl Holz  >  PHP Convert Excel to JSON  >  xsl/workbooks.xsl  >  Download  
File: xsl/workbooks.xsl
Role: Auxiliary data
Content type: text/plain
Description: XSLT stylesheet, already embedded into class
Class: PHP Convert Excel to JSON
Convert data from Excel spreadsheet to JSON format
Author: By
Last change: Update of xsl/workbooks.xsl
Date: 1 month ago
Size: 1,129 bytes
 

Contents

Class file image Download
<?xml version="1.0" encoding="UTF-8"?> <xsl:stylesheet xmlns:o="http://schemas.openxmlformats.org/spreadsheetml/2006/main" xmlns:xsl="http://www.w3.org/1999/XSL/Transform" xmlns:r="http://schemas.openxmlformats.org/officeDocument/2006/relationships" version="1.0"> <xsl:output method="text" media-type="text/plain"/> <xsl:param name="page" select="'xl/worksheets/sheet'" /> <xsl:param name="r" select="'true'"/> <xsl:template match="/"><xsl:apply-templates select="o:workbook|workbook" /> </xsl:template> <xsl:template match="o:workbook|workbook">[worksheets]<xsl:apply-templates select="o:sheets|sheets" /></xsl:template> <xsl:template match="o:sheets|sheets"> <xsl:for-each select="o:sheet|sheet"> title[]="<xsl:value-of select="@name"/>" <xsl:choose> <xsl:when test="$r='true'"> xml[]="<xsl:value-of select="$page"/><xsl:value-of select="substring-after(@r:id, 'rId')"/>.xml" </xsl:when> <xsl:otherwise> xml[]="<xsl:value-of select="$page"/><xsl:value-of select="@sheetId"/>.xml" </xsl:otherwise> </xsl:choose> </xsl:for-each> </xsl:template> </xsl:stylesheet>