Stream Excel Chart
I want to know if there is a way to get a chart on some excel worksheet and stream it as a binary png or jpg picture to an asp page.
View RepliesI want to know if there is a way to get a chart on some excel worksheet and stream it as a binary png or jpg picture to an asp page.
View RepliesI have a problem,i create an excel chart by using the asp, but due to my selected database is quite large until the chart shows the data in a messy way and it is too tight even the name for the unit also cannot see.
is any way to seperate it ? i mean show it in another way for eg show it for 10 data in a page and can click on a "next" to link another page , or create another drop down list to select for how many data to show in a page? and may i know how to write that ??
thank you very much
another question is , once created the chart , how to view it like a pic in a part of IE just like the stock market value?for your information, i connected to database and created the excel chart , and just link to show it in IE for whole.
i have a problem,i create an excel chart by using the asp, but due to my selected database is quite large until the chart shows the data in a messy way and it is too tight even the name for the unit also cannot see.
is any way to seperate it ? i mean show it in another way for eg show it for 10 data in a page and can click on a "next" to link another page , or create another drop down list to select for how many data to show in a page? and may i know how to write that ??
another question is , once created the chart , how to view it like a pic in a part of IE just like the stock market value?for your information, i connected to database and created the excel chart , and just link to show it in IE for whole.
The problem is that in XP SP2, the IE instance opened for the vbscript only
page no longer closes when Excel is closed. The user has to manually close
this window. This didn't happen in XP SP1. Obviously there is a security
change, but I have been unable to determine how to reverse it.
Does anyone know how I can get the IE instance to close when Excel closes in
XP2 SP2?
I create an excel chart by using the asp, but due to my selected database is quite large until the chart shows the data in a messy way and it is too tight even the name for the unit also cannot see.
Is any way to seperate it? i mean show it in another way for eg show it for 10 data in a page and can click on a "next" to link another page, or create another drop down list to select for how many data to show in a page? and how to write that ?
got stalled at at point that i can no longer get my thoughts together.the point, is in classic asp, stream an excel file from a firebird database.temporarly save it if necessary,stream it to the browser,delete the temp file
on googling, i found some examples but all assuming that the file is locally present.
on the other hand, i beleive that is possible to stream the binary file and the save it locally to then present it to the browser, but i can't figure out how.
I developed some code to export DataGrid to excel base on the html stream technology.
But that one works only with worksheet cell. Is there any way to output Excel Chart based on the html stream?
I am tryign to create an excel spreadsheet/chart using office web components in asp. However I seem to have a registeration problem. I'm running office2003 and IIs is also running on my pc. When the following line exceutes an error "invalid string class is thrown" :
set objChartSpace = Server.CreateObject("OWC.Chart")
I have intalled owc again but still no luck. IS it a registeration problem ?
May I want to know ASP or Javascript can generate a chart (pie chart) ?
or other method can do that?
I had downloaded your bar chart. Is it possible to read the values from the database?? If possible, how??
View Replies View RelatedI have a page which streams an Excel spreadsheet to the user. It has worked
fine for 12mths or more, but recently I found out that it wasn't working. I
suspect the problem lies with IIS, but I'm not sure...
When the user submits a form, the page should stream the file to the user -
the user is presented with a standard Open/Save/Cancel dialog, which the
would ordinarily save to their HDD. I have updoaded the code from the live
server to my development machine (IIS5.1) - and this same code works fine.
However, on the live server (IIS6), the user is presented with the dialog
box, but rather than listing myfile.xls, it lists mypage.asp as the file to
be downloaded.I think this must be an IIS6 issue but I don't know what. Some time before
the problem was noticed, work had been done on the live server, but AFAIK
nothing was done that was *intended* to affect this application.
Ineed to create a something like a horizontal bar chart connected to a db. this is all very new for me, Can some one please suggest something....
View Replies View RelatedI'm trying to develop some graphs for my site and hoped this would be a solution.
I have one question really. We've installed the MS Office 2003 components on our webserver -2003- but i seem unable to create a reference to it in the code i.e.
dim owc
set owc = createObject("owc.chart")
It comes back with an error which doesn't seem to make sense as the component is registered on the server, does anyone know what might be causing this?
Code:
I ve created a table of information and now i need to make a number of pie charts from this table.
Ive attatched an image of the table, to make it easier for you to know what i mean. a pie chart i want to make for example is, say, the number of red,yellow and green projects in Fixed Income, ie 14 red, 4 yellow and 4 green.
I'm using streams to upload a file. I get an error 800a0bbc write to file failed.
I've looked on support.microsoft.com and groups.google.com.
No luck on what a 800a0bbc error is.
how I can do this pulling from a Microsoft Access database?
View Replies View RelatedDoes anyone know how to create an attachment using a stream in classic
ASP.I can see that it can be done in ASP.Net as per the article below:
Initializes a new instance of the Attachment class with the specified
stream and name.
http://msdn2.microsoft.com/en-us/library/6sdktyws.aspx.
After the latest security update, is it still possible to use adodb.stream
on the server side?
I'm using
file.OpenAsTextStream(ForReading, _
TristateUseDefault)
and then i read some lines.
Line = TextStream.readline
Then when i finished reading it i need to go to the begiining and read some
lines again.But i dont see how to go back to the begining.
I mean, Is there a way to go back to the first line of the file if i
allready read some lines
I have been making a dynamic chart in ASP, and it's working fine so far. However there's only one thing that is not working. The color of Plotarea!
I don't know how to define the color of plotarea. I tried to specify the color of Plotarea as below but it didn't work.
set oChart = Server.CreateObject("OWC.Chart")
set objChart = oChart.Charts.Add()
objChart.PlotArea.Interior.Color ="#FFFFFF"
what the best way to produce radar charts from asp would be? I know that I will probably need to install a component on the server. Any comments on what the best / cheapest one would be?
View Replies View RelatedI've heard conflicting stories on the ability of Office Web Components to access a data source that resides on the internet (as opposed to the intranet). Some say you can, some say you cannot. I can get the owc chart to connect to my database on IIS but I would like to publish this on my webpage.I'd like to insert a chart on a page which I like to use data from an Access database on my webpage. How do I get that chart to link to a data source on my website? I use the following line to connect to my database normally:
Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" & Server.MapPath("amsydb est.mdb"))
But where do I insert this in the data connection section so I can get my OWC chart to connect to this database?
We have an application, written in ASP, that uses the ADODB.Stream to be
able to open files and write byte arrays to the Response object. If one of
our administrators patches the web servers this application runs on in
Windows Update, I'm screwed, right? You've essentially just disabled this
COM object, for not only its evil purposes, but its useful ones?
Ok, I'm stumped on something that really shouldn't be this hard. I've
created some cool code to transform a dataset via XSLT into SpreadsheetML
(XML for Excel) and I'm storing the physical file on a file server. Now... I
currently provide a hyperlink to view/save the file, but this won't work
outside the network.
So, I've been working on making this
hyperlink/linkbutton/button/whatever stream the file back to the user. How
in the name of Zeus's butthole do I do this?
So, in simpler terms; how do I take a physical file and stream the sucker
back? Ideally, I'd like this to work just like it does now with the physical
link to the file. Click the link, it prompts you to save/open/cancel.
Clicking Open pops up Excel and looky-looky, you see the file.
I prepare a owc chart in asp.
in category axis (x-axis) i want to adjust date format according to date range, For Example: if data is of 5 years then tick lables show Years as below
Large data : 2005,2006
Medium : Jan, Feb
Samll : Mon, Tue
I've tried by NumberFormat property
Chartspace.Charts(0).Axes(0).NumberFormat = "dd,mm,yy"
but it is not working.
can it be done through ASP or via SQL statement. if SQL then how
Can someone provide me sample codes to plot line chart.
View Replies View RelatedI have been asked that every user in the site should have a chart that shows individual calories, fat, carbs of items that the user selects in any restaurant so And the user would be able to plan how those items would effect their diet plan.
Also the charts and graphs will be for Weekly Progress Chart , as the site is for diet progress for the users.If anyone knows how this can be done,please help as i am stuck here and i am a newbie to ASP.
is there any component available for creating Organisation Chart. I hope, I don't have to write code for creating boxes & lines for creating this Org Chart.
View Replies View RelatedI am using ADODB.Stream for downloading the files on user machine. The code works fine when filesize is less than 10 MB. But if file size is more than 10 MB then it doesn;t get download. Can anyone tell what is the problem. I have to user some different component.
View Replies View RelatedI'm looking to have an image (say, icons for a particular document) and when it is clicked on, I would like the "Open/Save/Cancel" dialogue to open up.
I was told using an ADO data stream was the way to go, making the app an unknown so the dialogue opens:
Dim FileName
Dim FullFileName
FileName = "MyWordDocument.doc"
FullFileName = "C:WebfilesMyWordDocument.doc"
Response.ContentType = "application/x-unknown"
Response.Addheader "Content-Disposition", "attachment; filename=" & chr(34) & FileName & chr(34)
Response.Binarywrite GetBinaryFile(FullFileName)
Function GetBinaryFile(ByVal FileSpec)
Const adTypeBinary = 1
Dim objStream
Set objStream = Server.CreateObject("ADODB.Stream")
objStream.Open()
objStream.Type = adTypeBinary
objStream.LoadFromFile (FileSpec)
GetBinaryFile = objStream.Read()
Set objStream = Nothing
End Function
Is there a better way to do this? Also, I grab the file name from a SQL query which is then populated to a datagrid - the image name/etc is populated dynamically - how is this done in ASP? Is that with an anchor tag?
<asp:TemplateColumn ItemStyle-HorizontalAlign="Center"><ItemTemplate><asp:Image ID="thumb" runat="server" /></ItemTemplate></asp:TemplateColumn>
i want to be able to write an asp.net function to download files.
For example, brinkster.com hosting service has a COM component that allows a stream of binary data to the client from the server so that the client will be prompted to download the file.
here is the syntax:
Set Upload = Server.CreateObject("Persits.Upload")
Dim SysFilePath
SysFilePath = Request.QueryString("filePath")
' Parmeters:
' 1. Path to file to download
' 2. Yes, build content-xxx headers
' 3. Use this value for Content-Type header
' 4. Include the word "attachment;" to Content-Disposition to force download
Upload.SendBinary "premfs3sitespremium8jaydakissx22webrootmyFile.txt, True, "application/octet-binary", True
How can I do this in asp.net without using the "Persits.Upload" COM object?
I am trying to create a text file by using the following code. But it's not working. It just loading the page that's all.
<%
DIM fso, NewsFile
Set fso = CreateObject("Scripting.FileSystemObject")
Set NewsFile = fso.CreateTextFile("c: est1.txt", True)
NewsFile.WriteLine("Hello World!")
NewsFile.Close
%>
I have made a page to display a chart based on data from my SQL-server. I have used Office Web-component graph. Here I can set the correct SQL statement and the graph works fine.
Now I want the user to be able to input the WHERE part of the sql sentence. Can anyone point me to info or code on the web to do this ?