Re: MVC framework for Excel?

You know, I have asked that question before too.

The next request in the queue is to generate the same thing in PDF, pie 
charts and all. I have offered to be the one to open the spreadsheet and 
save as PDF...

JXLS has been suggested privately by another AJUG member. That definitely 
looks like a step in the right direction.

Thanks for the ideas, and keep them coming!

-Andrew



From:   Jesse Karr <[email protected]>
To:     "[email protected]" <[email protected]>
Date:   02/15/2016 04:25 PM
Subject:        Re: [ajug-members] MVC framework for Excel?
Sent by:        "ajug-members" <[email protected]>



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

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