This tutorial shows a quick and easy way to generate Excel reports using just ASP. It allows the server to dynamically create Excel reports without taking up any space on the server, and also allows multiple concurrent users to receive these reports simultaneously. The generated reports can be complete with Excel formulas, which allows intensive calculations to be moved to the client side. This method only works with Excel 97 or later.

GenerateXLS is an ASP script that generates an Excel (XLS) file from a database. It is Copyrighted and is distributed under the GNU Public License.

This article describes using the Office Web Components (OWC) to create an Excel spreadsheet via ASP code based on the results from a database query. All of this complexity is encapsulated in a (rather basic) class.

This graphical article by ZD Journals explains how to create an ASP page that passes an HTML data stream to an Excel spreadsheet and then displays the HTML as an Excel workbook in an IE browser. Topics covered: Creating the HTML Table, and Using Standard Excel Functions in an HTML Table.

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.

Excel Spreadsheet Loader is an Active Server PagesTM (ASP) component that loads (imports) Microsoft Excel spreadsheets into your custom ASP applications. Features include: Load Microsoft Excel Spreadsheets via copy-and-paste, Preview Mode, Customizable cell validation, Add your own header and footer code, including logos, menus, etc., Choice of loading to a intermediate work table or handle each cell as you see fit, Customizable preview column titles. (Defaults to letters), and Customizable user documentation. (Default generic instructions included.)

This is a short example showing how to bring data from Access to excel where further manipulation can take place.

Quickly insert MIME Type for Excel or Word on your ASP page. These are nothing fancy, just simple shortcuts to change the MIME Type or Response.ContentType in your ASP page. Doing so will load the page in a Web browser as an Excel or Word document. The user can then save the document as Excel or Word directly from their Web browser.

This article shows how to use an Excel file as the database for an employee photo directory. As part of the Active Server Pages application it explains how to configure the spreadsheet for online use, create recordsets from the rows of data, and perform queries and navigate using a browser.

SoftArtisans ExcelWriter creates, modifies, and generates native Excel on the Web from existing Microsoft Excel spreadsheets, script, templates, or any data source. With ExcelWriter, Microsoft Excel is not required on the server, so Web applications have licensing flexibility, ease of deployment, and increased performance. ExcelWriter supports the use of existing Excel spreadsheets as templates, Excel formatting, functions, charts, Microsoft Visual Basic® for Applications (VBA), macros, pivot tables, multiple sheets, image insertion, named ranges, page layouts, and more. One click generates downloads and presentation-quality Excel reports that can be fully edited. The workbooks generated by ExcelWriter are in native Microsoft binary format. ExcelWriter can be used from any environment that supports COM, such as ASP pages (ASP), Visual Basic, and ASP.NET.