Wrox Programmer Forums
| Search | Today's Posts | Mark Forums Read
Classic ASP Basics For beginner programmers starting with "classic" ASP 3, pre-".NET." NOT for ASP.NET 1.0, 1.1, or 2.0
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Classic ASP 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 August 29th, 2003, 10:56 PM
Registered User
 
Join Date: Jul 2003
Location: , , Singapore.
Posts: 6
Thanks: 0
Thanked 0 Times in 0 Posts
Default How to export XML to Excel using ASP?

hi,

i have a ASP page that searches for a particular field(eg. Author Name) in SQL2k and the search results will be written into this xml file called 'Results.xml' which will be transform with Results.xsl into the asp page to display to users.

This asp page will display the search results and on the page itself, there is an archive button such that when user clicks on 'Archive', there would be a file dialog box prompting user to select the path where they wanted to save the excel file into their local hard disk drive.

my problem is "how to get the filedialog box out and to export the 'Results.xml' into excel file(Results.xls)

I am using vbscript for this.


 
Old August 31st, 2003, 02:14 PM
Friend of Wrox
 
Join Date: Jun 2003
Location: High Wycombe, UK, United Kingdom.
Posts: 344
Thanks: 0
Thanked 1 Time in 1 Post
Default

Check out http://www.greggriffiths.org/webdev/both/excel/ while it does not deal directly with using XML as the datasource, many of the exmaples and links could be altered to provide that functionality.
 
Old September 4th, 2003, 09:44 AM
Registered User
 
Join Date: Jul 2003
Location: , , Singapore.
Posts: 6
Thanks: 0
Thanked 0 Times in 0 Posts
Default

thanks a lot.
this site is useful and i have got it done




Similar Threads
Thread Thread Starter Forum Replies Last Post
Export to excel from ASP jayanp Classic ASP Basics 4 July 31st, 2007 03:01 PM
export from asp.net to excel RoniR ASP.NET 1.0 and 1.1 Professional 3 February 12th, 2007 11:45 AM
Export from ASP to Excel with pagebreak's Fernandito Classic ASP Basics 1 May 19th, 2004 04:46 PM
How to export xml to excel using ASP porsrari XML 1 September 5th, 2003 06:26 AM
Use ASP/SQL to export to Excel sankar Classic ASP Basics 10 July 18th, 2003 04:04 AM





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