Wrox Programmer Forums
Go Back   Wrox Programmer Forums > ASP.NET and ASP > ASP.NET 2.0 > ASP.NET 2.0 Basics
|
ASP.NET 2.0 Basics If you are new to ASP or ASP.NET programming with version 2.0, this is the forum to begin asking questions. Please also see the Visual Web Developer 2005 forum.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the ASP.NET 2.0 Basics section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old June 28th, 2006, 02:40 PM
Registered User
 
Join Date: Jun 2006
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default XSLT to Excel transfer too slow

I am attempting to transfer an XML file to an Excel File using XSLT. I am using XmlDataDocument and it slows down greatly on large data sets. A workaround was found on MSDN: http://support.microsoft.com/kb/318580/EN-US/, But I am not sure how to implement it.

Below is what I am currently using:

Code:
<%@ Page Language="c#" %>

<%@ Import Namespace="System.Data" %>

<%@ Import Namespace="System.Xml" %>

<%@ Import Namespace="System.Xml.Xsl" %>

<script language="C#" runat="server">

public void Page_Load(Object sender, EventArgs E) {

string reportname = Request.QueryString["Name"];

string xmlpath = "e:/Program Files/Apache Software Foundation/Tomcat 5.5/webapps/ROOT/reportdata";

xmlpath += "/";

xmlpath += reportname;

xmlpath += ".xml";

string xslpath = reportname;

xslpath += "/";

xslpath += reportname;

xslpath += ".xsl";

Response.ContentType = "application/vnd.ms-excel";

Response.Charset = "";

DataSet ds = new DataSet();

ds.ReadXml(xmlpath);

XmlDataDocument xdd = new XmlDataDocument(ds);

XslTransform xt = new XslTransform();

xt.Load(Server.MapPath(xslpath));

xt.Transform(xdd, null, Response.OutputStream);

Response.End();

}

</script>
Any help is appreciated!!!





Similar Threads
Thread Thread Starter Forum Replies Last Post
Very Slow Excel Files vikashtiwari Excel VBA 9 April 22nd, 2008 01:56 PM
Transfer data from Excel to Access JezLisle Excel VBA 0 December 13th, 2007 01:25 PM
Data transfer from Access to Excel swaroop Access VBA 2 June 1st, 2007 10:30 AM
Excel transfer question bmbrmnky Excel VBA 4 March 30th, 2006 04:37 PM
VB-Excel Slow Sometimes Brian149 Excel VBA 4 January 7th, 2005 03:29 AM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.