Wrox Programmer Forums
Go Back   Wrox Programmer Forums > XML > XML
| Search | Today's Posts | Mark Forums Read
XML General XML discussions.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the XML 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:48 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 September 5th, 2003, 06:26 AM
joefawcett's Avatar
Wrox Author
Points: 9,763, Level: 42
Points: 9,763, Level: 42 Points: 9,763, Level: 42 Points: 9,763, Level: 42
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Jun 2003
Location: Exeter, , United Kingdom.
Posts: 3,074
Thanks: 1
Thanked 38 Times in 37 Posts
Default

There are quite a few other posts in the forum on doing this. Thre are a number of ways from displaying an HTML table in Excel to transforming via XSLT into a full blown spreadsheet depending on what version of Excel your users have. Search the archives.

--

Joe




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 Classic ASP Basics 2 September 4th, 2003 09:44 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.