Re: MVC framework for Excel?

Hey Andrew,

The first thought I had was "why does the executive not just hire a
skilled administrative assistant to prepare the reports for him?"

Jesse


On Monday, February 15, 2016, <[email protected]> wrote:

> 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