Transferring data to Excel

Please support our ASP.NET advertiser: Intel Parallel Studio Home
Reply

Join Date: Jun 2006
Posts: 7
Reputation: danae is an unknown quantity at this point 
Solved Threads: 0
danae danae is offline Offline
Newbie Poster

Transferring data to Excel

 
0
  #1
Sep 26th, 2006
Hi, everyone. Hope someone can offer some help on this. I need to generate a chart, preferably, by using Microsoft Excel. I need to retrieve some data from an aspx form and use the data to generate the chart in Excel. Okay, there are some input fields in the aspx form and by retrieving the input data, an Excel chart can be generated, after the user clicks a button. The user might be directed to another page displaying the chart. Is it possible or does someone have any other way of doing it? Urgent. By the way, I am using ASP.NET with VB. Thanks.
Last edited by danae; Sep 26th, 2006 at 11:36 pm. Reason: left out something
Reply With Quote Quick reply to this message  
Join Date: Dec 2004
Posts: 1,655
Reputation: tgreer is an unknown quantity at this point 
Solved Threads: 35
Team Colleague
tgreer tgreer is offline Offline
Made Her Cry

Re: Transferring data to Excel

 
0
  #2
Sep 26th, 2006
Excel is not a server application. Asking it to be a "chart server" for your web application is not going to lead to a scalable application. I would suggest either:

1) creating your own charts directly, which is possible using the Graphics namespace. Create images based on form data, and stream them right back to the user, or

2) get an ASP.NET compatible charting component.
Last edited by tgreer; Sep 26th, 2006 at 11:56 pm.
Reply With Quote Quick reply to this message  
Join Date: Jun 2006
Posts: 7
Reputation: danae is an unknown quantity at this point 
Solved Threads: 0
danae danae is offline Offline
Newbie Poster

Re: Transferring data to Excel

 
0
  #3
Oct 3rd, 2006
Originally Posted by tgreer View Post
Excel is not a server application. Asking it to be a "chart server" for your web application is not going to lead to a scalable application. I would suggest either:

1) creating your own charts directly, which is possible using the Graphics namespace. Create images based on form data, and stream them right back to the user, or

2) get an ASP.NET compatible charting component.
Hi, tgreer. Thanks alot for the reply. However, I have a problem. I went to the ASP.NET compatible charting component link. Because I need to draw line chart, so I clicked the line charts link. I saw one component that seems compatible enough for my project, the TimeDataPlot. Unfortunately, it couldn't be downloaded, due to unknown reason. The other suggested controls couldn't be used because they require the updated versions of ASP.NET 2006 and .NET Framework v2.0. I am using ASP.NET 2003 and .NET Framework SDK v1.1. And, can you please provide the Graphics namespace definition? I couldn't find it. Sorry for the trouble, I am a beginner using ASP.NET with VB. Thanks alot for the help.
Reply With Quote Quick reply to this message  
Join Date: Dec 2004
Posts: 1,655
Reputation: tgreer is an unknown quantity at this point 
Solved Threads: 35
Team Colleague
tgreer tgreer is offline Offline
Made Her Cry

Re: Transferring data to Excel

 
0
  #4
Oct 3rd, 2006
I have no control over the asp.net website. In any case, you really need to update to .NET Framework 2.0. I understand that may not be under your control.

I have to apologize. I said "Graphics", when I meant "Drawing". Use the System.Drawing namespace.

There are a few articles on the topic, such as this one.
Reply With Quote Quick reply to this message  
Reply

This thread is more than three months old.
Perhaps start a new thread instead?
Message:


Thread Tools Search this Thread



About Us | Contact Us | Advertise | DaniWeb | Acceptable Use Policy | RSS Feed

©2003 - 2009 DaniWeb® LLC