|
31. Create Excel from Form Input
|
ASP form input can be transformed into most any type of format that youd 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. This example will show you how to 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. 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.
Hits: 3 Rating: 0.00 Votes: 0
|
| Member Reviews |
 |
Visitor Ratings |
 |
Google PR |
 |
|
|
32. 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 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.
Hits: 3 Rating: 0.00 Votes: 0
|
| Member Reviews |
|
Visitor Ratings |
|
Google PR |
 |
|
|
33. 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 perform queries and navigate using a browser.
Hits: 2 Rating: 0.00 Votes: 0
|
| Member Reviews |
|
Visitor Ratings |
|
Google PR |
 |
|
|
34. 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." This exmaple code demonstrates how to display data from Excel using sample data of Hank Greenbergs career statistics. Example code available for download.
Hits: 3 Rating: 0.00 Votes: 0
|
| Member Reviews |
|
Visitor Ratings |
|
Google PR |
 |
|
|
35. 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.
Hits: 4 Rating: 0.00 Votes: 0
|
| Member Reviews |
|
Visitor Ratings |
|
Google PR |
 |
|
|
36. 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 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.
Hits: 4 Rating: 0.00 Votes: 0
|
| Member Reviews |
|
Visitor Ratings |
|
Google PR |
 |
|
|
37. Create Excel from Form Input
|
ASP form input can be transformed into most any type of format that youd 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. This example will show you how to 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. 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.
Hits: 2 Rating: 0.00 Votes: 0
|
| Member Reviews |
|
Visitor Ratings |
|
Google PR |
 |
|
|
38. Excel Spreadsheet Loader
|
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.)
Hits: 2 Rating: 0.00 Votes: 0
|
| Member Reviews |
|
Visitor Ratings |
|
Google PR |
 |
|
|
39. Passing HTML Data to Excel Using ASP
|
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.
Hits: 2 Rating: 0.00 Votes: 0
|
| Member Reviews |
|
Visitor Ratings |
|
Google PR |
 |
|
|
40. Excel Data
|
This is a simple ASP script demonstrating how to connect and display Excel data using ADO From ASP.
Hits: 2 Rating: 0.00 Votes: 0
|
| Member Reviews |
|
Visitor Ratings |
|
Google PR |
 |
|
|
|
