I have generated Bar, Line and Pie charts using the MSOWC.DLL and its fantastic.
The ONLY problem I have encountered is when generating Pie charts it shows the quntities of each piece inside the Pie chart and its very hard to read. But in Excel it shows outside the Pie chart. So, I want to find out a solution for this.
I need to generate some reports with graphical charts (line, pie, bar and polar). I want to generate those charts which represent database values. Hope I have to use a 3rd party control for this.
how I can generate xl bar charts from ASP page. For example, just a click, take the input (recordset), put in a chart and open up/open a xl sheet, show the chart through excel application.
I tried with user defined class, but this isn't working with excel.
I have a new approach to saving charts from server-side Excel when ASP pages are processed. The charts show weather data that is updated every 15 minutes in a database, and instead of just automating the chart production so that every chart is generated every 15 minutes, 24 hrs/day, it seems smarter to generate up to date charts when people want to look at them. But I'm not sure if this is the best approach.
This is what I can do from an ASP page to dynamically chart data:
- run Excel on the server - open a Worksheet that has a customized chart for a range of cells. - insert new data in the charted range of cells (chart auto-updates). - save the chart to a gif file. - insert the gif into the html page viewed by the client.
Using this approach is convenient because I can customize charts to look exactly as I want without having to find the documentation to automate the chart formatting.
Is it possible to run Excel once on the server, and let all requests for charts use this one running instance of Excel? The alternative is that Excel will run once for each chart request, this seems like it could get out of hand pretty quickly if a lot of people are trying to look at charts at the same time.
Are there better ways to generate charts dynamically on the server?
first, say I have a payment processing scheme, and after a value is returned letting the program know that a sucessful payment is made, that somehow I dynamically create a GUID, (or something of the like). I want to have it somehow embedded in the program as well as well as sent to the buyer so that he can enter in that GUID and it unlocks the program.
So somehow I want to generate a GUID, either inside the program or outside of it which either way is incorperated into the program, and so that I have a copy of it. I want this all to be able to be done dynamically and I assume it would have to be done in ASP.NET as it doesen't seem feasable to run a .exe program on the web.
Any leads? Or perhaps there is some sort of "shell" that I can embed my program in that will do this for me. Any ideas?
I'm building a site in our intranet that reports out hits and issues in our loaders coming from a SQL Server and I was exploring the use of MS Charts, but unfortunately, all the example I got from MSDN was MS charts used in VB. Is there a way you can call the MS chart in an ASP page?
I am trying to figure out how do I create graphs and charts in ASP without having to use third party solutions. I was told that I can create dynamic graphs and charts using ASP.Net but when I read up on this, came up at a dead end. Any ideas anyone?
Generally before going for development, i like to put everything on paper. something like a flow are there any tools by which i can create these flow chart or mock ups with less pain
I want to display the data from Access in form of Bar charts and Pie charts. I know this is possible by using the OWC components. But i am not familiar to them.Can anybody give me an outline/example of how to do this?
I have recently found myself involved with a very small company who is being contracted by a very large company to develop a PowerPoint type application for their sales people (18 slides and about 3,000 active users) which must include charts and graphs. It doesn't have to be in real time and we may render the graphics each night instead of on the fly. The slides will be dynamic and represent up to 30 different companies querying about 29,000 rows of data per company.
I oddly enough don't feel as worried as I probably should be.
Suggestions, Possible Pitfalls, and Previous Experience building an application like this.
Working off of MS SQL and planning to do it all in ASP.
I looking for a tutorial on charts/graphs which would take information from the DB table. I have a column about 31000 records and numbered field of 001-0022. I hav another field which contains texts.
What I'm looking for is to show graphically on a scale of 001-022 as in the first field how many time does the search criteria appear.
For example: I search a keyword "hello"
and the graph would show 001: 30 times, 002: 4 times...022: 1 time, but as a chart.
I think it would be nice to add a percentage calculation too.
Using OWC version 2000 I am trying to input a recordset into an OWC Spreadsheet. I can pass the variables and create the SQL fine in the ASP page, but I need to pass the SQL to a vbscript function outside of the <% asp code %[color=blue] >. Is there any way to call the function? ASP doens't seem[/color] to recognize the function.
Does anyone now were I can get a script for an out of office page for an intranet. A very basic one would do, something that displays when they leave and other basic details,for a company of about 40. All staff would be using it.
I'm trying to use Activer Server Pages (ASP) to display a graph based on user's selection criteria. To achieve this, I would like to use Office Web Components (OWC 9 or 10), a Microsoft ActiveX component. My questions are:
* Can you use it with NT operating systems or Must it be in Windows 2000/XP? * Do anyone has experience in using it? and if yes, Are they easy and reliable to use? * Are there any other free components out there?
any decent resources for using the Office Chart components? I've had a look around the MSDN but it's not very comprehensive and doesn't actually have any reference guides. Most resources say to refer to the help file that comes with the package but I can't find any versions of this.
I'm looking for a way to create over 100 Excel *charts* programmatically. We've just run a large online survey and the data is being fed back to us in a single spreadsheet - each respondent on a row and their dimensions (division, department, etc) and each of their responses in columns.
This data has to be sliced by a number of dimensions - this will require that just over 100 separate charts will have to be created. I'm looking for a way to create these charts in the most efficient way. I'm happy to normalise the data and load it into SQL Server, and can then easily extract each required subset. The output of the extract process will probably be spreadsheets in TSV format.
Last time I had to graphically report this sort of data I loaded it into a mart and used PivotCharts. The owners of they survey don't need the flexibility of Analysis Services so I'm happy to pre-define the charting requirements if it'll mean I'm able to create these charts automatically. Manipulating 100 PivotCharts was too much for them. Each chart will ultimately be fed back to users in a Word document or Powerpoint presentation with the appropriate analyses. Code:
Does anyone know of a way to access the document properties of an office document using ASP? I need to be able to read things like the Title, Author, and Comments fields and pull that information into a web page.
Is it possible to connect and asp page to the Microsoft Office Thesaurus? I would like to be able to pass a word to it and get back all of the synonyms as either a string, array, or collection.
Are there any asp scripts that I can use to allow people to view my powerpoint, excel, and word files over the internet without having to download then? The must run from the server.
I am facing some problems with generating the word documents usin ASP pages. This is the automated process and it is breaking often Since Microsoft is not providing any support for this issue, I though using WordPerfect 12 for the automated document generation would hel me a lot. Is there any possibility of facing the same problem with wor perfect too?
How easy is it to access the metadata from office files and PDF's? That is, Author, Title, Keywords, Comments etc...
I want to be able to scan a directory and provide links with descriptions (ie Comments field) for each file within. I can use automation to open and read the office files, but I imagine this would produce too big a load on the webserver. Is there a simple and slick way of doing this?
