[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
RE: Excel Spreadsheets
Scott,
I'm going to try your suggestion to create a template.
One question. I'm currently using the following .jar files:
poi-3.0-rc4-200070503
poi-contrib-3.0-rc4-200070503
poi-scratchpad-3.0-rc4-200070503
Should I replace them with the latest versions?
Thanks,
Karl B. Woods
Sr. Programmer/Analyst
Professional Services
1960 S. Milestone Dr., Ste B
Salt Lake City, UT 84104
S Tel: (801) 433-9426 (office)
( E-mail: karl.woods@xxxxxxxxxxxxxx
LiveSTRONG
....... __o Same Road
....... \<, Same Rules
.... ( )/ ( ) Same Rights
This e-mail contains proprietary information and may be confidential. If you are not the intended recipient of this e-mail, you are hereby notified that any dissemination, distribution or copying of this message is strictly prohibited. If you received this message in error, please delete it immediately.
-----Original Message-----
From: Scott Klement [mailto:klemscot@xxxxxxxxxxxx]
Sent: Friday, April 17, 2009 12:38 AM
To: HTTPAPI and FTPAPI Projects
Subject: Re: Excel Spreadsheets
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
-----------------------------------------------------------------------
-----------------------------------------------------------------------
This is the FTPAPI mailing list. To unsubscribe, please go to:
http://www.scottklement.com/mailman/listinfo/ftpapi
-----------------------------------------------------------------------