Multiple Workseets in Excel using XSLT transforms form XML(ASP.Net)

sadc1986

1 New Member

How does one introduce multiple worksheets in a excel using Xslt Transforms
my code... Please suggest

Expand|Select|Wrap|Line Numbers

 
<xsl:stylesheet

    version="1.0"

    xmlns:xsl="http://www.w3.org/1999/XSL/Transform"

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

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

  <xsl:output method="html" encoding="UTF-8"/>

  <xsl:template match="/">

    <html>

      <head>

        <title></title>

        <xml>

          <x:ExcelWorkbook>

            <x:ExcelWorksheets>

              <x:ExcelWorksheet>

                <x:Name>Sheet 1</x:Name>

                <x:Table>

                <xsl:apply-templates select="DeptData"></xsl:apply-templates>

                </x:Table>

                <x:WorksheetOptions>

                  <x:DefaultRowHeight>210</x:DefaultRowHeight>

                  <x:Print>

                    <x:FitHeight>0</x:FitHeight>

                    <x:ValidPrinterInfo/>

                    <x:Scale>100</x:Scale>

                    <x:HorizontalResolution>600</x:HorizontalResolution>

                    <x:VerticalResolution>600</x:VerticalResolution>

                  </x:Print>

                  <x:Selected/>

                  <x:DoNotDisplayGridlines>False</x:DoNotDisplayGridlines>

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

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

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

                </x:WorksheetOptions>

                <x:PageBreaks>

                </x:PageBreaks>

              </x:ExcelWorksheet>

              <x:ExcelWorksheet>

                <x:Name>Sheet 2</x:Name>

                <x:Table>

                  <xsl:apply-templates select="EmpData"></xsl:apply-templates>

                </x:Table>

                <x:WorksheetOptions>

                  <x:DefaultRowHeight>210</x:DefaultRowHeight>

                  <x:Print>

                    <x:FitHeight>0</x:FitHeight>

                    <x:ValidPrinterInfo/>

                    <x:Scale>100</x:Scale>

                    <x:HorizontalResolution>600</x:HorizontalResolution>

                    <x:VerticalResolution>600</x:VerticalResolution>

                  </x:Print>

                  <x:Selected/>

                  <x:DoNotDisplayGridlines>False</x:DoNotDisplayGridlines>

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

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

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

                </x:WorksheetOptions>

                <x:PageBreaks>

                </x:PageBreaks>

              </x:ExcelWorksheet>    

            <x:ProtectStructure>False</x:ProtectStructure>

            <x:ProtectWindows>False</x:ProtectWindows>

              </x:ExcelWorksheets>

          </x:ExcelWorkbook>

        </xml>

      </head>

      <body>

        <table>

          <tr>

            <td >Group</td>

            <td >Code</td>

          </tr>

          <xsl:for-each select="//ResultItemDeptSearch">

            <tr>

              <td >

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

              </td>

              <td >

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

              </td>

            </tr>

          </xsl:for-each>

        </table>

      </body>

      <body>

        <table>

          <tr>

            <td >Business Group</td>

            <td >Department Code</td>

          </tr>

          <xsl:for-each select="//ResultItemDeptSearch">

            <tr>

              <td >

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

              </td>

              <td >

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

              </td>

            </tr>

          </xsl:for-each>

        </table>

      </body>

    </html>

  </xsl:template>

  </xsl:stylesheet>

this is putting all the data in sheet 1
sheet 2 is blank

Aug 21 '07 #1

Subscribe Reply

7106

jkmyoung

2,057

Recognized Expert Top Contributor

Would need to see your xml source, but I'm guessing that the
EmpData nodes are not at the same level as the DeptData nodes.

I'm assuming you have not listed your templates for EmpData and DeptData?

Are employees under the Dept nodes?

You might be able to fix by simply changing EmpData to //EmpData

Aug 21 '07 #2

souravXML

New Member

What i have to do ,if i want some other contents in sheet2 i.e not a blank sheet
Thanks

Mar 20 '08 #3

jkmyoung

2,057

Recognized Expert Top Contributor

To answer your original question,

Create another <x:ExcelWorksheet> node, and put your data in there.

Did you want one Worksheet per EmpNode?

My original response was off, sorry.

Mar 24 '08 #4

ritzkandy

New Member

What i have to do ,if i want some other contents in sheet2 i.e not a blank sheet
Thanks

SouravXML, just wanted to know if you were able to achieve contents in multiple excel worksheets. I have a similar requirement and wanted to know..

Thanks!

Sep 11 '08 #5

Similar topics

1777

Attempt to identify unique keys using .NET xsltransform hangs, but works fine in MSXML 4.0

by: LarryR | last post by:

The following XSLT works fine using MSXML 4.0 (e.g I receive a result in about 20 seconds), but effectively hangs in both .NET 1.0 sp2 with the XML hot fix and NET 1.1. My source XML file is...

.NET Framework

2549

Multiple asp:buttons on one form but ONLY one should submit?

by: D. Shane Fowlkes | last post by:

Sorry for the length of this post. I have created a rather complex form which has a header/line item (parent and child records) structure. It's for an intranet. A screenshot can be seen here: ...

ASP.NET

1443

Uploading files using ASP.NET problem

by: darin dimitrov | last post by:

Hello, I have the following Html form: <form name="submitForProcess" action="http://localhost/xml/process.aspx" method="post" enctype="multipart/form-data"> <input type="text"...

ASP.NET

3178

Opening an Existing Excel Document using ASP.NET

by: Josh Behl | last post by:

When I try to programmatically open an existing Excel document using a custom windows form, it works perfectly. I instanciate a new instance of the Excel.ApplicationClass and then set the Visible...

ASP.NET

5615

Export to Excel - ASP.net 2.0

by: Not Me | last post by:

Hi, I'm trying to export from a gridview control, to an excel file using code intended for a datagrid control (it's all over the web, can post if requested) I get the error. Control...

ASP.NET

951

Can't release Excel from memory using ASP.NET

by: Wesley | last post by:

Hi, I'm creating a report in Excel using asp.net, but I can't release the Excel instance from memory. Excel.exe stays in the Windows Task Manager. Below is an example of the code I'm using: ...

ASP.NET

4210

Can't create simple login page using asp:login control

by: Sasquatch | last post by:

I'm having trouble creating a simple login page using the asp:login control. I followed some instructions in a WROX book, "Beginning ASP.NET 2.0," and the instructions are very straight forward,...

ASP.NET

2293

Excel Report using ASP.NET

by: Rajesh | last post by:

Hi, Please help me to do an EXCEL report generation using ASP.NET. I am building an website. This should work in all machine. I need do load the data from SQL tables to excel sheet and user can...

ASP.NET

1530

Search and Find a Record from Excel using ASP

by: micawber | last post by:

I would like to search and find records from Excel using ASP. Here is what I have so far, Can anyone help me? Thanks. <% Option Explicit Dim strConnection, conn, rs, strSQL, freephone

ASP / Active Server Pages

15392

To create an Excel Sheet using ASP.NET 2.0 with C#

by: =?Utf-8?B?Sm9zaW4gSm9obg==?= | last post by:

I could create MS Excel sheet using ASP.NET 2.0 with C# but it is not being created in some systems, following error occurs when the program compiles : Microsoft Office Excel cannot open or...

ASP.NET

7212

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

7296

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++

7364

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

7017

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

7470

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

5026

Access Europe - Using VBA to create a class based on a table - Wed 1 May

by: isladogs | last post by:

The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new...

Microsoft Access / VBA

4696

Couldn’t get equations in html when convert word .docx file to html file in C#.

by: conductexam | last post by:

I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and...

C# / C Sharp

3186

Trying to create a lan-to-lan vpn between two differents networks

by: TSSRALBI | last post by:

Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The...

Networking - Hardware / Configuration

751

How to add payments to a PHP MySQL app.

by: muto222 | last post by:

How can i add a mobile payment intergratation into php mysql website.

PHP