Can I access excel mathematical functions from flex action script through vbscript injection?

Question

We are looking to do display some mathematical data in a Flex GUI chart. We need to do plot for two array of data the following.

cross-correlation of both auto-correaltion of each and correlation coefficient

It looks like Flex does not support scientific formula like cross-correlation,auto-correlation and co-relation co-efficient natively. Please correct me if I am wrong or if there are reasonable alternatives at this point.

While looking for alternatives I did come across the article at actionscript.org [--not allowed--]

and I am presently trying to see whether I can invoke excel formulas from the actionscript. It looks like there might be some complexity involved in passing the data between flex and vbscript. Will this be the right approach?

This is for a POC and as such we are looking for a quick hack only.

Answer 1

I have never used VBScript, but I know that you can access JavaScript from AS3 and vice versa using the ExternalInterface class in AS3. And as far as I know, you can also access VB functions embedded in web pages from JavaScript. So, it shouldn't be too hard to invoke VB functions from Flash.

Answer 2

Using ActionScript you can write your own version of COREL to do the calculation. That will be much easier than trying to communicate with Excel. Certainly there is no direct way to communicate with Excel from a Flex app.