To create xsl with multiple worksheet

Hi all,
I 've created an xsl file to create an excel Workbook with multiple worksheets, thro' xslt. My code works fine for sheet1. Sheet2 was created but has no data. So please help me to fill data in sheet2 also. My code is here

Expand|Select|Wrap|Line Numbers

 
<?xml version="1.0" encoding="utf-8"?>
 
<xsl:stylesheet version="1.0"

   xmlns:xsl="http://www.w3.org/1999/XSL/Transform">
 
    <xsl:template match="/">

        <html xmlns:o="urn:schemas-microsoft-com:office:office"

       xmlns:x="urn:schemas-microsoft-com:office:excel"

              xmlns:s="urn:schemas-microsoft-com:office:spreadsheet"

          xmlns="http://www.w3.org/TR/REC-html40">

            <head>

                <meta http-equiv="Content-Type" content="text/html;charset=utf-8" />

                <style>

                    .xlText{mso-number-format:"@";text-align:left;font-family:新細明體;font-size:12px;}

                    .xlHeader{font-family:新細明體;font-size:12px;background:#CCFFCC;}

                    .xlEach{font-family:新細明體;font-size:12px;}

                    .xlTitle{font-size:20px;font-family:新細明體;font-weight:bold;background:#FFFF99;height:30px;}

                    .xlDate{mso-number-format:"yyyy/mm/dd_ ";}

                </style>

                <xml>

                    <x:ExcelWorkbook>

                        <x:ExcelWorksheets>

                            <x:ExcelWorksheet>

                                <x:Name>summary</x:Name>

                                <x:WorksheetOptions>

                                    <x:ProtectContents>False</x:ProtectContents>

                                    <x:ProtectObjects>False</x:ProtectObjects>

                                    <x:ProtectScenarios>False</x:ProtectScenarios>

                                </x:WorksheetOptions>

                            </x:ExcelWorksheet>

                            <x:ExcelWorksheet >

                                <x:Name>GateMoves</x:Name>

                                <Table x:name="GateMoves"  x:FullColumns="1" x:FullRows="1">

                                    <tr>

                                        <td align="Center" class="xlHeader">Month</td>

                                        <td align="Center" class="xlHeader">Activity</td>

                                        <td align="Center" class="xlHeader">count</td>

                                        <xsl:for-each select="NewDataSet/Table">

                                            <tr>

                                                <td class="xlEach">

                                                    <xsl:value-of select="Month" />

                                                </td>

                                                <td class="xlEach">

                                                    <xsl:value-of select="Activity" />

                                                </td>

                                                <td class="xlEach">

                                                    <xsl:value-of select="count" />

                                                </td>
 
                                            </tr>

                                        </xsl:for-each>

                                    </tr>

                                </Table>

                                <x:WorksheetOptions>

                                    <x:ProtectContents>False</x:ProtectContents>

                                    <x:ProtectObjects>False</x:ProtectObjects>

                                    <x:ProtectScenarios>False</x:ProtectScenarios>

                                </x:WorksheetOptions>

                            </x:ExcelWorksheet>

                        </x:ExcelWorksheets>

                    </x:ExcelWorkbook>

                </xml>

            </head>
 
            <body >

                <table border="1" cellpadding="0" cellspacing="0" width="100%" x:worksheet="GateMoves">

                    <tr>

                        <td align="Center" class="xlHeader">Month</td>

                            <td align="Center" class="xlHeader">Activity</td>

                            <td align="Center" class="xlHeader">count</td>

                            <xsl:for-each select="NewDataSet/Table">

                                <tr>

                                    <td class="xlEach">

                                        <xsl:value-of select="Month" />

                                    </td>

                                    <td class="xlEach">

                                        <xsl:value-of select="Activity" />

                                    </td>

                                    <td class="xlEach">

                                        <xsl:value-of select="count" />

                                    </td>
 
                                </tr>

                            </xsl:for-each>

                        </tr>

                        </table>        

                        </body >                    

        </html>

    </xsl:template>
 
</xsl:stylesheet>

With Thanks,

Sudha

Dec 23 '08 #1

Subscribe Post Reply

10664

jkmyoung

2,057

Expert 2GB

Which version of excel are you using? I'm confused as to why you have a mix of html and word xml.

Would normally advise populating a table in a second worksheet node.

Expand|Select|Wrap|Line Numbers

 
<?xml version="1.0"?>

<?mso-application progid="Excel.Sheet"?>

<Workbook xmlns="urn:schemas-microsoft-com:office:spreadsheet" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:x="urn:schemas-microsoft-com:office:excel" xmlns:ss="urn:schemas-microsoft-com:office:spreadsheet" xmlns:html="http://www.w3.org/TR/REC-html40">

    <Worksheet ss:Name="Sheet1">

        <Table ss:ExpandedColumnCount="1" ss:ExpandedRowCount="1" x:FullColumns="1" x:FullRows="1">

            <Row>

                <Cell>

                    <Data ss:Type="String">Sheet1Data</Data>

                </Cell>

            </Row>

        </Table>

    </Worksheet>

    <Worksheet ss:Name="Sheet2">

        <Table ss:ExpandedColumnCount="1" ss:ExpandedRowCount="1" x:FullColumns="1" x:FullRows="1">

            <Row>

                <Cell>

                    <Data ss:Type="String">Sheet2Data</Data>

                </Cell>

            </Row>

        </Table>

    </Worksheet>

</Workbook>

Dec 23 '08 #2

Similar topics

Create Excel worksheet in .Net

by: Brian Johnson | last post by:

I am trying to create multiple (named) worksheets in excel using .Net PIA's. I have successfully created an excel document and set cell values, but have been unable to manipulate which worksheet...

.NET Framework

Create XML element with a namespace prefix

by: Krishna Tulasi via .NET 247 | last post by:

Hi, I am having trouble with creation of XML programmatically using .NET. Specifically Im trying to create an element which looks like below and insert into an existing xml doc: <Worksheet...

.NET Framework

Create Excel Worksheet in C# / VB

by: Horst Walter | last post by:

I create an Excel worksheet in C# (should be similar in VB) Connection String: "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + filename + ";" + "Extended Properties=Excel 8.0;"; Create...

C# / C Sharp

Export records to multiple worksheet under 1 workbook

by: Dayron | last post by:

Hi, I'm retreving a large bunch of records from database and I wish to disply the records in the excel workbook. unfortunately the worksheet just can support until 65,535 records in a single...

C# / C Sharp

How to create and access Excel in VB.NET?

by: James Wong | last post by:

Dear all, I have an old VB6 application which can create and access Excel object. The basic definition statements are as follows: Dim appExcel As Object Dim wkb1 As Excel.Workbook Dim wks1...

Visual Basic .NET

Running the same code for multiple worksheets/series automatically

by: yalebulldog05 | last post by:

Watsup everyone, I'm having 2 problems, both dealing with similar themes of having code work for all possible series/worksheets, so i'm wondering if there's a macro that deals with this: 1) I'd...

Visual Basic 4 / 5 / 6

How to read multiple worksheet from a single excel file

by: sejal17 | last post by:

hello Can any one tell me how to read multiple worksheets from a single excel file.I have stored that excel in xml file.so i want to read that xml that has multiple worksheet.And i want to store...

PHP

how to read multiple worksheet from an excel file using php

by: sejal17 | last post by:

hello Can any one tell me how to read multiple worksheets from a single excel file.I have stored that excel in xml file.so i want to read that xml that has multiple worksheet.And i want to store...

XML

how to create table in sql server from either a datagridview or excelfile

by: TG | last post by:

Hi! I have an application in which I have some checkboxes and depending which ones are checked those columns will show in the datagridview from sql server or no. After that I have 2 buttons:...

Visual Basic .NET

Looking to do Android software development, any suggestions? Is flutter better?

by: nemocccc | last post by:

hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?

General

Is that possible of reading the .csv file in column wise and the column have different lengths ?

by: Sonnysonu | last post by:

This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...

C / C++

How to build RAID in BIOS?

by: Hystou | last post by:

There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

Computer Hardware

What is ONU?

by: marktang | last post by:

ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...

General

Problem With Comparison Operator <=> in G++

by: Oralloy | last post by:

Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...

C / C++

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

by: jinu1996 | last post by:

In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...

Online Marketing

The easy way to turn off automatic updates for Windows 10/11

by: Hystou | last post by:

Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...

Windows Server

Discussion: How does Zigbee compare with other wireless protocols in smart home applications?

by: tracyyun | last post by:

Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...

General

AI Job Threat for Devs

by: agi2029 | last post by:

Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...

Career Advice