2744Generate Excel fileshttp://www.advancode.com/articles.php?page=excelGenerating 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.ASP > Tips and Tutorials > Excel and ASPOct 10, 2006AdvanCode.com
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.
Sometimes it's useful to present data to users in Excel format, so they can easily manipulate the data themselves. In this article, a very simple technique for accomplishing this is demonstrated.
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 Greenberg's career statistics. Example code available for download.
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.
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.
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.