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.

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.

Excel can act as a database. It's not the fastest or the best. However, 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. For this example, we've taken our db on the career statistics of hank Greenberg and place it insided an excel spreadsheet. We've also named the range of his statistics, including the header rows hamerin_hank. This is not to be confused with naming a sheet in an excel. You must highlight the full range of cells you want to query. From the toolbar in excel select insert -> Name -> define. Name the cell range (I would avoid spaces and special characters) and click OK. Other the directing the query to the excel driver instead of the Access data most everything is the same as displaying an Access db.

Writing from a database to a web page is certainly useful, but sometimes putting data to a web page is just as useless as printing it on paper when it comes to doing analysis. Fortunately, if you can bring data to a browser you can bring it to excel where further manipulation can take place. This only difference between the code below and a .asp page that would output to the browser is <%Response.ContentType = "application/vnd.ms-excel"%> which opens Excel within the browser window and providing that MSExcel97 or better is installed on the PC it will output to an excel spreadsheet.

Active Server Pages allow for the easy ability to create dynamic views of your data on a web server, but you can also create word and excel documents on the server. This can be particularly useful if you wish to distribute your information on CD or in document form. The following example will utilize our 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. All observations (states) will be a unique row within the excel that is created with its corresponding info displayed as well. 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.

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.

Learn how to use Excel 2000 and Active Server Pages to create a photo directory.

This tutorial focuses on extracting data from a Microsoft Excel Spreadsheet. This tutorial will walk you through step-by-step to setup the spreadsheet and how to write the code in ASP to get the required data.

This section makes it possible to gather a whole of techniques or scripts which have the originality to manage to solve a difficulty with the least effort or which are particularly effective...The grayed entries relate to the future headings which will supplement soon this toolbox.