Re: MVC framework for Excel?

Many years ago, I was looking at xslt to the same
( Your data feed will be xml which will be passed through xslt transformations )

On Mon, Feb 15, 2016 at 3:54 PM,  <[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
_______________________________________________
ajug-members mailing list
[email protected]
Manage your subscription and unsubscribe http://lists.ajug.org/mailman/listinfo/ajug-members