Create an Employee Photo Directory with Excel and ASP
2747Create an Employee Photo Directory with Excel and ASPhttp://www.devx.com/upload/free/features/webbuilder/2000/wb0600/kcox0600.aspThis 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.ASP > Tips and Tutorials > Excel and ASPOct 10, 2006
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.
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!
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.
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.
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.
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.