MVC framework for Excel?

There has got to be something around to assist with this but it does not 
seem to be easily Googled, at least by me, so any insight would be 
appreciated.

We provide an ever increasing number of data feeds for assorted uses. 
Commonly they are to be consumed using Excel. For simplicity we prefer to 
provide the feed as CSV which makes the generation pretty straight 
forward. However there is a growing trend to provide "executive" reporting 
in Excel, which is another way of indicating a consumer that does not have 
time (or does not know how) to use Excel to extract the desired results.

We have produced Excel using JExcel API/Apache POI which adds a lot of 
complexity to the data feed code, so I am not a fan of this in a single 
step. We are now looking at taking a skeleton spreadsheet, which may 
include pie charts, etc., and loading the data section of it so the 
formatting is not being generated by code.

I think we should go all the way and divorce the data feed (model) from 
Excel (view) through a mapping (controller) to separate the concerns.

Is there some framework available that supports this already? Is this even 
a reasonable approach? Any suggestions greatly appreciated.

This is in a Groovy and Grails environment if that has any bearing on the 
topic.

Thanks!


Andrew Goodspeed
"How *reliable* [is he]? How shallow is the ocean? How cold is the sun?" 
-Douglas Adams (Arthur Dent)

_______________________________________________
ajug-members mailing list
[email protected]
Manage your subscription and unsubscribe http://lists.ajug.org/mailman/listinfo/ajug-members