ASP → Tips and Tutorials → Excel and ASP

Displaying Records From An Excel Database

Aim of this articles is to display records from an Microsoft Excel in an ASP. We could use general SQL command while retreving data from an excel sheet. All we need to know how to connect Excel file.

• Platforms
  • Windows
• Licenses
  • Freeware

Generate Excel files

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 serve...

• Platforms
  • Linux,
  • Windows,
  • FreeBSD,
  • Mac OSX,
  • Sun Solaris
• Licenses
  • Freeware

Create Excel from Form Input

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 appli...

• Platforms
  • Linux
• Licenses
  • Freeware

Create Excel on the Server

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...

• Platforms
  • Linux
• Licenses
  • Freeware

Create an Employee Photo Directory with Excel and ASP

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 perf...

• Platforms
  • Linux
• Licenses
  • Freeware

Display an Excel DB

The author writes &"For small data bits on a server where the chance for significant simultaneous traffic is not likely excel can perform many of the basic tasks that can be accomplished in Access or SQL Server, but on a much smaller scale.&...

• Platforms
  • Linux
• Licenses
  • Freeware

Creating Excel Spreadsheets

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.

• Platforms
  • Linux
• Licenses
  • Freeware

Dynamic Excel Reports with ASP

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 ...

• Platforms
  • Linux
• Licenses
  • Freeware

Output To MSExcel

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

• Platforms
  • Linux
• Licenses
  • Freeware