Java Script library for Excel functions

[KiranJyothi]

Hello,

I am looking for a java script library for Microsoft excel spreadsheet where I can implement vlookup function.

Please let me know.

Thanks,
Jyothi

[gits]

could you explain the usecase a bit more? what do you want to do with JavaScript and Excel? the use of that in combination seems quite strange ...

[KiranJyothi]

could you explain the usecase a bit more? what do you want to do with JavaScript and Excel? the use of that in combination seems quite strange ...

Thanks for the response.

Actually, I am trying to create an excel spreadsheet control that runs in webpage using javascript/ajax and want to allow users to enter excel functions to do calculations and support multiple sheets. Basically, to simulate excel in the browser.

-Jyothi

[gits]

you might have a look here - choose the grid samples ... such Sencha/ExtJs grids could be easyly used within a tab-control -> this would create different sheets -> some premade calculations are built in already - for the formulas i guess you would need to implement your own lib. the lib-functions should be able to accept an array or object and do the calc for that input, that functions could be plugged in to the grids to be used there ... perhaps there are some premade plugins out there - probably you might search for such ...

similar controls/plugins you might find in DOJO or jQuery ...