Possibly you could help or point me in the right direction with my next
adventure in Excel.I would like to purchase a very expensive piece of software to dynamically update charts (graphs) on our server, it is from http://www.globfx.com/products/ (Swiff Chart Generator 3.2) $900
Before the outlay of that money I need to know that I can easily import a
sets of cells i.e. A1:B25 into one of many forms, the samples are located in the link below.
http://www.globfx.com/support/kb/swfchartgen.php.
The support department is not the best, but the software is great. They
suggested I might try using an Excel COM object to import the cells into one of there PHP code samples located in the link above.
There are many ways the generator can send the information to the charts
PHP, Cold Fusion, Java Servlet and others. I need to get these from Excel into something that the Chart Generator can read.
Another possible option is we have MYsql on our Apache server and can generate the charts from there with ease, is there a way to get 150 columns (150 separate graphs) of data from Excel into MYsql, this data will be generated on a DAILY bases so it would need to be a solution that can be done with ease.
Thanks
donbmjr
