MS Office & ASP

<< Main ASP Directory
Page : 1
Charting with Office Web Components (OWC) By For More Information ... 
Charting with Office Web Components (OWC) By For More Information on Graphing. For more information on creating graphs using ASP be sure to check out the ! There you will find articles on using a multitude of approaches to create graphs using ASP! ALSO! You can use the Office Web Components to create Excel spreadsheets on the fly through an ASP  


Creating Excel Spreadsheets with Office Web Components (OWC) By An ... 
Creating Excel Spreadsheets with Office Web Components (OWC) By An Upgrade to the Class. This article presents a class ( ExcelGen ) that generates an Excel spreadsheet based on the results of a Recordset 

Creating Excel Spreadsheets with Office Web Components (OWC), Part 2 ... 
Creating Excel Spreadsheets with Office Web Components (OWC), Part 2 By Read In we looked at some very basic code for creating, populating, and saving an Excel spreadsheet all from an ASP page! In this part we'll look at the implementation of a class that will allow you to dump the results of a Recordset object to a spreadsheet!  

Creating Excel Spreadsheets with Office Web Components (OWC), Part 3 ... 
Creating Excel Spreadsheets with Office Web Components (OWC), Part 3 By Read Read In we looked at the private member variables of our class as well as our Class_Initialize() and Class_Terminate() event handlers and our Property Let statements.  

Creating Excel WorkSheets with ASP 
In this article we will discuss and demonstrate how to create Microsoft Excel worksheets from Active Server pages. Though there are many ways that this can be done, we have chosen a method for the example that conserves server load and puts the majority work on the client 

Dynamic Excel Reports with ASP 
There are many situations in which you may wish to convert table data into an Excel spreadsheet format for the user. There are several methods available for doing this; I will describe here one of the better ones. It allows the server to dynamically create Excel reports without taking up any space on the server. It also allows multiple concurrent users to receive these reports simultaneously. Lastly, 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.  

Enhancing the ExcelGen Class (for Creating Excel Spreadsheets) By Before 
Enhancing the ExcelGen Class (for Creating Excel Spreadsheets) By Before you Begin Reading. This article is a sequel to a previous article: . The previous article examines how to use Office Web Components to create an Excel spreadsheet on the fly through an ASP page.  


Enhancing the ExcelGen Class (for Creating Excel Spreadsheets), Part 2 ... 
Enhancing the ExcelGen Class (for Creating Excel Spreadsheets), Part 2 By Read In we listed the new enhancements to the ExcelGen class and looked at the updated GenerateWorksheetFromRecordset method. In this part we'll look at how to stream Excel spreadsheets to the user! Streaming Excel  

Enhancing the ExcelGen Class (for Creating Excel Spreadsheets), Part 3 ... 
Enhancing the ExcelGen Class (for Creating Excel Spreadsheets), Part 3 By Read Read In we examined how to use the FileSystemObject to generate random file names for each spreadsheet. We also looked at how to have the out-of-date spreadsheets deleted every so often to ensure that our Web server's filesystem doesn't become overbloated with old spreadsheet files. 

Excel Data 
As bad an idea as this can be, I'm still getting a lot of requests for the ability to use Excel as a data source. Well here you go! Please be aware that while ASP is meant to handle multiple users Excel is not so you should expect problems if you put this on a server that handles multiple users. 

Page : 1

Get the best ASP hosting with DiscountASP.NET - great value, money back guarantee.

Advertisements



MembersPro

MembersPro PayPal - ASP Membership software

Plug and play ASP membership script that integrates with PayPal to let you charge recurring membership fees.

Global ASP.NET Hosting Leader - Click Here