Generate Charts In Serverside Excel Dynamically, Advisable?
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?
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 have a long recordset that i want to page through. can sql pass back say, 5 records from 20 to 25 out of 1000? i can then pass 2 variables between the pages to dynamically generate the sql and thus page through the results. can someone post up a simple example of this if its possible?
On each site there is a global.asa file that ties into an Access database. The fields from the Access database instantiate the values of session variables used in the site. I am trying to do away with the need for a database and was wondering if when I set up a site I also set the .asa file for that site.
Then if a shop wants to change something like an address, phone, number, directions, etc., they would go a toolbox area of the site and there would be a form whose field values would be populated by the session variables from the global.asa file.
When the form was submitted I was thinking I could somehow use asp to write a new global.asa file and store it in the server. Is this feasible? Also, what would this mean insofar as permissions on the root directory of the site? I'd imagine they'd have to have write permissions no? Code:
I want to create an Excel object from an ASP page. Basically, the input parameters to the Excel would be from the ASP. I know ASP and I know VBA, but I haven't used both of them together. Here's what I would like to do -
The ASP should generate an Excel report by passing 2 parameters to the Excel application (I have done this independently; without interfacing with ASP).
I know that I can create an excel handle from the ASP as -
Set MyExcel = Server.CreateObject("Excel.Application")
I dont know where the VBA code has to go? DO I have to include it in the ASP?
I am using the code below to create an excel document from data that is returned from an sql query. The formatting of the excel document is pretty and all is good unless I hit the back button and run my query a second time, or a third time (I haven't made it past 3 times). Basically what happens is every time I do this, excel does not close once I hit my back button. Does anyone have a solution to this problem? Another problem is that when I run the query it just opens excel within my browser, is there any way to make it ask if you want to save or open the file?
I basically throw this code at the top of the html doc: .....
With response.contenttype = "application/vnd.ms-excel", I can easily export my data to Excel which is embeded and shown within a browser. If I'm going to save the Excel file through ASP programming, which method can I use? I need to save the data to Excel file with dynamic name (the file name should contain key values and appended with system datetime).
I am using a SQL database, and Classic ASP and trying to generate an Excel file with my results, but the table is displaying as HTML in the browser instead of prompting the user to download/open the file. below is my code (edited data table for length). Anyone know why I am not being prompted, but shown the data via the webpage?
I am exporting data from a web application to Excel to allow users to manipulate their data. I can open up the data in Excel. If the user wants to view information about 3 separate clients, how can I put that information on 3 separate worksheets.
I can display the 3 clients on one worksheet, but I need it to be on 3 separate worksheets.
I have a database and I use asp to load it into a html table. The first cell of each row contains a button. What I want is that when a user clicks the button it calls a serverside sub that inserts additional rows from an other table of my database. Problem is that I don't now how to call a sub from the onclick event of the button. And I don't know if it's possible to insert rows in a html table. Does anybody know how I should do this?
Been looking around the web and found some examples but nothing great. wondering if any1 here has seen a script to show a dynamic clock on a webpage that displays server time (this will be for an intranet app). me and my budy have been working on different ideas but to no avail. so in the mean time thought id post to see if any1 has seen 1 or has done one.
I have a usercontrol which contains ajax toolkit controls which I am using in a SharePoint siite. When the user clicks one of the buttons on the page it fires a series of events server side (creates a new project in project server, creates an new SharePoint site ... ) each of which take quite some time. I would like to display the successful completion of each event in the control to so the user can see what progress has been made.
I am struggling to understand how I can engineer the page to perform each task in turn, post the page back after each task has occurred (to update the UI that the task has been done) then fire the next server side event. It's easy to update a control with the status changes but the updated control is only displayed to the user when all of the server side events have completed.
How do i open notepad server side in ASP .i have this so far. Code:
Dim WshShell 'remove the "server." part to run this clientside set WshShell = CreateObject("WScript.Shell") 'this is path to notepad in win2k 'You should have enough priviledges to run it... WshShell.Run "c:winntsystem32 otepad.exe" set WshShell= nothing
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 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.
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?
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.
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.
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:
how I generate a new XML file that I can then use with an XSLT file. I am trying to use an XML file generated from Microsoft Project or even better generate an XML file from the project file (MPP File) itself. Which I can then use with an XSLT file
I am new to XML and want to create a project viewer using XML, ASP and XHTML. I have an idea of how this should work but would really appritiate any help someone can offer. Is it possible to take an XML file and generate it in ASP without using an XSLT file??
I've been trying to Google this but have been getting far too many hits to be of use. Is there a slick way to generate a CSV or other Excel-friendly format and push it to the client? I'm using VBScript (and HTML and other typical stuff of course) on the ASP pages (no .NET stuff). Just a shove in the right direction is all I really need here.
