Velocity Reviews - Computer Hardware Reviews

Velocity Reviews > Newsgroups > Programming > ASP .Net > ASP General > ASP to Excel

Reply
Thread Tools

ASP to Excel

 
 
Ben Moen
Guest
Posts: n/a
 
      12-31-2003
I'm not sure which group is most appropriate for this
question; I'll also post this in office solutions
development. I am running into problems with something
that seems to be a popular requirement - porting data from
an asp page to an Excel workbook to allow users to
manipulate data. I have a few different methods working,
but also with some issues. I want to know if these are
technical limitations, or if there is another direction to
take such as web query...

I have successfully used the "Response.ContentType
= "application/vnd.ms-excel" in ASP to stream everything
in the page as an Excel document. However, when I use
this, simple SUM() formulas do not work in the resulting
Excel worksheet. The worksheet does not recognize results
from my dataset as true number types.

In response to a previous post, I tried using another
method - constructing, and manipulating a worksheet object
using ActiveX. This allows the user to play with the
resulting worksheet, however, they would be required to
change their default IE settings. This is a corporate
intranet app, and requiring our entire user base to tweak
their browser settings is going to be unreasonable.

I am trying to stay away from writing out distinct Excel
files on the server for performance, and security
concerns. As I understand it, web query will generate a
physical file to download. Can web query instead stream
content to a browser? Any other suggestions?

THANKS,

Ben
 
Reply With Quote
 
 
 
 
Greg Griffiths
Guest
Posts: n/a
 
      01-01-2004
using the code from http://www.greggriffiths.org/webdev/both/excel/ you
should be able to get a working sample where the XL file is created on
the server side and then a link is returned to the uesr allowing them to
open the file in their browser.

Ben Moen wrote:

> I'm not sure which group is most appropriate for this
> question; I'll also post this in office solutions
> development. I am running into problems with something
> that seems to be a popular requirement - porting data from
> an asp page to an Excel workbook to allow users to
> manipulate data. I have a few different methods working,
> but also with some issues. I want to know if these are
> technical limitations, or if there is another direction to
> take such as web query...
>
> I have successfully used the "Response.ContentType
> = "application/vnd.ms-excel" in ASP to stream everything
> in the page as an Excel document. However, when I use
> this, simple SUM() formulas do not work in the resulting
> Excel worksheet. The worksheet does not recognize results
> from my dataset as true number types.
>
> In response to a previous post, I tried using another
> method - constructing, and manipulating a worksheet object
> using ActiveX. This allows the user to play with the
> resulting worksheet, however, they would be required to
> change their default IE settings. This is a corporate
> intranet app, and requiring our entire user base to tweak
> their browser settings is going to be unreasonable.
>
> I am trying to stay away from writing out distinct Excel
> files on the server for performance, and security
> concerns. As I understand it, web query will generate a
> physical file to download. Can web query instead stream
> content to a browser? Any other suggestions?
>
> THANKS,
>
> Ben


 
Reply With Quote
 
 
 
Reply

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
From an ASP page, is there a way write to an EXCEL file without having EXCEL installed on the IIS machine ? fniles ASP General 6 04-27-2009 10:33 PM
How to return an excel file or excel data from ASP.NET Anonieko ASP .Net 2 02-12-2008 07:03 PM
Problem with Excel reports ::::Excel 2003 Migration To Excel 2007 =?Utf-8?B?c2hhc2hhbmsga3Vsa2Fybmk=?= ASP .Net 15 10-24-2007 01:34 PM
Export to excel in asp.net using excel template Grey ASP .Net 4 10-17-2007 08:08 AM
asp.net extracting excel charts from an Excel file Robbe Morris [C# MVP] ASP .Net 0 12-15-2006 03:03 AM



Advertisments