Range + Calc support

Topics: Developer Forum
Jul 24, 2009 at 4:11 AM
Edited Jul 24, 2009 at 4:12 AM

This is a very very handy library for working with excel packages!

Though unfortunately it seems its not yet catering for ranges and there fore not able to cater for calculations either :(

Very often you would want to open a document get a value of a cell (which is calculated in the background from a phormula in that cell) and then use that calculated value somewhere without the user having to actually open the document in excel. This would be most advantageous but I guess Im gonna have to quickly come up with my own extension to this library :)

But this is by far the best helper lib I have seen so far!

Kyryll

Oct 1, 2009 at 5:14 AM

I'd love to see calc too, but this is an Excel file access library, not an Excel app replacement :) 

I assume supporting all the Excel formulas would be a huge project, far exceeding the current size of the app.

You can probably get away with just doing the few specific calculations you need.

Btw, what do you mean by "ranges"?

Oct 1, 2009 at 5:19 AM

Sorry I knew that needed more explanation! :)

By ranges I mean ability create named ranges like excel does.

And yeas you are right - providing a calc engine is a huge project but oh so enticing!

Thanks for your reply :)