Re: Excel Spreadsheets

[Scott Klement <klemscot@xxxxxxxxxxxx>]

Hi Karl,

POI does not currently include support for Excel's graphing 
capabilities.  However, the POI people say that they'll preserve a chart 
that's already in the spreadsheet, you just can't manipulate it through 
the POI API.

With that in mind it should be possible to create a "template" 
spreadsheet in Excel, put bogus values in the cells and create the 
chart(s), etc, all in Excel.  Then read it into POI with your RPG 
program and replace the bogus data with the new data from your program, 
and finally save it back to disk.

I haven't tried that, though... I'm guessing it'll work based on the POI 
docs.

If not, I have two other alternatives for you:

a) You could generate your graphs as images using JFreeChart or a 
similar tool.  Then insert them as images into the sheet.

b) You could forget about POI and write your spreadsheet as XML using 
the new Microsoft Office XML formats.  That should give you full control 
without POI.

Hope my ramblings are useful :)



Karl Woods wrote:
> I've been using Scott's examples for creating excel spreadsheets for a
> few months now. My users love getting spreadsheets generated instead of
> having to download .csv files and then bringing them into excel.
> 
> They want me to add a few things to "beautify" the spreadsheets. I will
> be adding the company logo, shouldn't be a problem since I have Scott's
> article on how to do this. However, I've been asked to add pie or bar
> charts to the spreadsheets. Is there a way to do this?
> 
> Thanks,
> Karl B. Woods  
> Sr. Programmer/Analyst
> Professional Services
> DriverTech, LLC
> 
> 
> -----------------------------------------------------------------------
> This is the FTPAPI mailing list.  To unsubscribe, please go to:
> http://www.scottklement.com/mailman/listinfo/ftpapi
> -----------------------------------------------------------------------
> 
-----------------------------------------------------------------------
This is the FTPAPI mailing list.  To unsubscribe, please go to:
http://www.scottklement.com/mailman/listinfo/ftpapi
-----------------------------------------------------------------------