Excel Chart

[samycbe]

can anyone please explain how to make a chart from asp in excel. i have a tables in database. i want to make an excel chart for that. if u explain with some basic examples it will be greatful to me,

samy

[jhardman]

I'm not sure I understand. You have a table of data in an excell file and you want to make an ASP graph of the data so the graph is available on the internet? I've done this before, generating pie graphs and histograms, and it is not that hard. Please confirm that this is what you want, and breifly explain the format of the data table.

[samycbe]

Dear Friend,

Please help me. I have data in sqlserver. Lets example 1 table named emp with empname and salary fields. i want to generate a graph for that, when the user click a button in browser. that graph should be in excel.

please do the needful.

[jhardman]

Okay, so you have data in a sql server db, you want an ASP to open the db, extract the data, and generate a graph (or update a graph) in an excell file?

I have a few questions. First, would it be enough if an existing graph was updated? I think I could get that to work. I'm not sure I could create a graph in excel from an asp.

Second, Do you need to display the updated graph, or just save it? It should be easy to save an updated graph, but I'm not sure I could get an asp to open the graph. Maybe generate one that looks a bit like an excel graph. Would that be enough?

Third, with which parts of this do you need help? Do you know how to open the sql server db and extract the raw data? Do you know how to manipulate it into the form of data an excel file could use to generate a graph? Do you know how to save data from an asp into an excel file? If the last question is the only one with which you need help, then that is doable, If you need help with the whole thing, it's time to offer money to a programmer who could do it for you.

Jared

[samycbe]

Dear Friend

1. I want to display the graph based on the sql data in excel

2. I want to just open - display the excel file and the user will save it

3. I know to fetch and manipulate data in asp from db. only excel display part i need a help

4. if u give code with some basic example, it will be beyond price for me

thanks

[jhardman]

4. if u give code with some basic example, it will be beyond price for me

Ok, here is what I worked up:

<% option explicit %>
<!-- #include virtual="common/adovbs.inc" -->
<%
dim objConn, objRS, query, file, names(5), hours(5), i
 
names(0) = "George"
names(1) = "Freeda"
names(2) = "Hercules"
names(3) = "Agatha"
names(4) = "Francois"
hours(0) = 17
hours(1) = 25
hours(2) = 40
hours(3) = 12
hours(4) = 36
 
file = "graphAspTest.xls"
set objConn = server.createobject("ADODB.connection")
objConn.open "Provider = Microsoft.Jet.OLEDB.4.0;Data Source="&_
   server.mapPath(File)&"; Extended Properties=Excel 8.0;"
 
query = "SELECT * FROM [data$]"
query = query & " ORDER BY nums"
set objRS = server.createobject("adodb.recordset")
objRS.open query, objConn, adopenDynamic, adlockOptimistic
 
for i = 0 to 4
   objRS("names") = names(i)
   objRS("hoursWorked") = hours(i)
   objRS.update
   objRS.movenext
next
 
objRS.close
objConn.close
response.redirect "graphAspTest.xls"
%>
 

So I made an Excel file with one worksheet titled "data" which had just a few columns ("names" and "hoursWorked"). I entered dummy data that Excel could use to generate a graph, then put the graph on as a separate sheet. I saved it with the graph showing.

Then when I run the asp, it opens the Excel file, changes the dummy data to the actual data I want to graph, and closes it, then redirects the user to open the excel file (which opens showing the graph page).

I tested it at the following URL:
www.worksonline.org/temp/graphAspTest.asp

The drawbacks are that you need the excel file and the graph to already exist. I tried to re-size the number of data points on the graph, but I couldn't get it to work. Sorry. It looks like if you ever need a different number of data points, you will need to modify the excel file using MS Excel.

I don't know if there is any other way to do this, maybe you could look up the data format for a WMF (recognized by all of the MS office software, and can be used to store graphs) and generate one that way, but I'm not sure many browsers would be able to handle it.

Please let me know if this helps.

Jared

[samycbe]

Thanks. I will try