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

7116

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:ExcelWorkshe et> 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

1780

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 large at over 46,000 <atl_client> nodes <?xml version="1.0" encoding="UTF-8"?> <xsl:stylesheet version="1.0"...

.NET Framework

2552

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: http://www.drpt.virginia.gov/temp1.gif All the fields on this form have validation controls on them so they can not submit the form unless all...

ASP.NET

1446

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" name="customerId" value="5" /><br /> <input type="text" name="customerName" value="Johnson" /><br />

ASP.NET

3186

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 property to 'true'...then I open the workbook in question via my code..... However, when I try this using ASP.NET. It does not work. I've...

ASP.NET

5625

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 'gvSearch' of type 'GridView' must be placed inside a form tag with runat=server.

ASP.NET

955

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: Dim appExcel As New Microsoft.Office.Interop.Excel.Application appExcel.ActiveWorkbook.Close() appExcel.Quit()

ASP.NET

4218

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, but it won't work for me. Here's what I did. 1. Created a new folder named "testlogin" 2. Turned that folder into an application using the IIS...

ASP.NET

2297

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 modify the data in the excel sheet. Then i need to get the data from modified excel sheet and generate the graphical Chart. But the machine need...

ASP.NET

1531

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

15402

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 save any more documents because there is not enough available memory or disk space. â€¢ To make more memory available, close workbooks or programs...

ASP.NET

7700

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, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main...

General

7614

Changing the language in Windows 10

by: Hystou | last post by:

Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language...

Windows Server

7924

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, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. ...

C / C++

8125

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 tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that...

Online Marketing

7676

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 Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For...

Windows Server

5513

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 presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes...

Microsoft Access / VBA

5219

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 then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert...

C# / C Sharp

3642

Windows Forms - .Net 8.0

by: adsilva | last post by:

A Windows Forms form does not have the event Unload, like VB6. What one acts like?

Visual Basic .NET

1221

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