NEW LISTINGS 
HOT LISTINGS
TOP RATED
EDITOR PICK
ADD A LISTING
UPDATE A LISTING
GET RATED
UPGRADE A LISTING
HOT LISTINGS
TOP RATED
EDITOR PICK
ADD A LISTING
UPDATE A LISTING
GET RATED
UPGRADE A LISTING
Creating Excel Spreadsheets with Office Web Components (OWC)
2749
Creating Excel Spreadsheets with Office Web Components (OWC)
http://www.4guysfromrolla.com/webtech/022801-1.shtml
This article presents a class (ExcelGen) that generates an Excel spreadsheet based on the results of a Recordset. An enhanced version of this class is available at: Enhancing the ExcelGen Class (for Creating Excel Spreadsheets). However, make sure you've read this article completely before moving onto the next!
ASP > Tips and Tutorials > Excel and ASP
Oct 10, 2006
Write a Review
Add to My Favorite
Refer it to Friend
Report Broken Link
| |
|
||
| Bookmark Creating Excel Spreadsheets with Office Web Components (OWC): |
|||
Other links at ASP > Tips and Tutorials > Excel and ASP
This code example demonstrates how to create excel documents on your server. Using the US state info db, after reading the contents of the db instead of writing output to the browser, html text is written to the server with the .xls file extension. A link to the new document is created (in the browser) for easy navigation to the new document. The current time (server time) is also displayed to show that the excel document was created dynamically.
Category:
Generating Excel files from web pages or other applications is a major subject in many articles. I'd like to present here some solutions, part of them, already presented and well known. Some of them require MS Excel to be installed on the server, and other not.
Category:
This article shows how to use an Excel *.xls file as the database for an employee photo directory. As part of this Active Server Pages application you'll see how to configure the spreadsheet for online use, create recordsets from the rows of data, and perform queries and navigate using a browser.
Category:
Sometimes it's useful to present data to users in Excel format, so they can easily manipulate the data themselves. In this article, a very simple technique for accomplishing this is demonstrated.
Category:
ASP form input can be transformed into most any type of format that you'd like to see it in. Typically, most form input either gets delivered to a database, like Access or SQL server or the output is sent to an email address or some other application. In a previous example we?ve even demonstrated how ASP form input can be used to write a permanent html document directly to the server. ASP Form Input to HTML. In this example we will take user input and create an excel file of that input on the server. The title that the user inputs will be used to name the document, so titles containing !@#$%^&*()+= are invalid. When utilizing this script on your site please keep in mind that the directory that you execute the .asp code from must have user write authority established on the server.
Category:
Main Category
194
2041
824
286
175
1802
1238
913
1163
7489
70
909
59
2222
174
Join Mailing List
Joining mailing list will entitle you
to receive occasional emails informing you of news and
updates to the site and any special offers that may be
of interest to you.
Top 10
Directory Statistics
Links: 19539
Categories: 1275
Registered Users: 750
Mailing List Subscribers: 2046
Unique Outgoing Hits: 228131
Pagerank Statistics
PHP News