I've been playing around with generating excel spreedsheets on the fly from ASP. It's surprisngly simple and easy, although the results (html based files) aren't exactly perfect.
What I really wanted to do was create proper excel files, and be able to name the worksheets. This is important if your going to attempt to import data from the worksheets later, using ASP.
I tried a couple of components that were either free, or quite cheap. Neither was any real use. I also discovered I could actually create the spreadsheets through by referencing owc.dll, office web components (which happens to be installed on my development server). Again, not really the way to go from a licencing position.
I then came acorss OfficeWriter from SoftArtisans. Now it's brilliant!! It will let me create native excel and ms word files, including formatting, charts, graphs, formulas, pivot tables, etc.. basically eveything you can do in excel - but without excel, and all from ASP.
I bought a development licence and have used it with great effect and ease.
However, the production licence version is not cheap, to say the least.
Does anyone know of any other competing products that are more affordable, but just as good - or close?