Use: The component will use MS Excel installed on your system to generate a GIF file. The data to be plotted is provided to the component as a ADO recordset and hence live data from any ADO compliant data source can be used. The type of charts is only limited by what is available in MS EXCEL. The GIF file so generated can be rendered to even the thinnest client with a simple HTML file using the <IMG> tag. The key is that NO ACTIVE-X or Java classes/Applets on the clients. Zero-deployment on the client and still the best quality charts.
More Info: We have written a two-part article on asptoday.com but the site now requires a modest subscription fee, so its your choice. But the article provides complete explanation with trouble shooting. http://www.asptoday.com/articles/20000303.htm and http://www.asptoday.com/articles/20000310.htm TRY IT OUT
Download: ExcelChart ZIP file with example and component source code in VB.
| DataForChart.htm | start from here, takes input for preparing chart |
| BuildAndShowChart.asp | core file, uses the component and generates chart |
| create_production_table.sql | sql script example to create a table in MS SQL server |
| ExcelChart.inc | include file for constants |
| ExcelChart.DLL | what u r looking for, the COM component |
| cExcelChart.cls | component source code |
| ExcelChart.vbp | VB 6 project |
Our Testing: Our test environment was NT 4 service Pack 5, IIS 4, ASP, MS Excel 2000. Sorry it does not work with PWS but works fine with Win2K and IIS 5. We have not tested it using VC.
TroubleShooting: Things to remember or common errors
1. MS Excel should be installed so that the component can invoke it as Automation server
2. Component should be resgistered using regsvr32
3. The directory on which you are exporting must have write permission for the user-context, e.g IUSER_MACHINENAME
More help: We don't commit but you can try us at vikash_agarwal@hotmail.com or rohitn@iname.com with subject ExcelChart