I don't believe POI does this for you.
You can write VB coding to do this yourself after the spreadsheet is
converted, but it requires a PC.
If you really need to do something like this directly from RPG, the
RPG2Excel functionality in our RPG2SQL Integrator product can probably
help with this.
In your scenario you could have a template pre-built with all the
VBScript needed or you could tweak it at runtime.
Please feel free to contact me directly or check out our web site if you
can't find a way to do what you need for FREE. You can download a FREE
demo of RPG2SQL Integrator and our tech team will help you get things
running.
Regards,
Richard Schoen
RJS Software Systems Inc.
Where Information Meets Innovation
Document Management, Workflow, Report Delivery, Forms and Business
Intelligence
Email: richard@xxxxxxxxxxxxxxx
Web Site:
http://www.rjssoftware.com
Tel: (952) 736-5800
Fax: (952) 736-5801
Toll Free: (888) RJSSOFT
----------------------------------------------------------------------
message: 1
date: Fri, 9 Jul 2010 13:43:53 -0400
from: "Helena Galkin" <hgalkin@xxxxxxxxxxxxxxx>
subject: Excel Spreadsheets from RPG - if it's possible to add VB to
an Excel document from RPG?
Hi,
I have some questions regarding Creating VB to an Excel with POI from
RPG.
1. Can I use POI to write (export) VBScripts macros to an Excel
spreadsheet (.xls) file?
2. If yes, then what version of POI (HSSF) do I need? Could you
give
me an example?
As an Amazon Associate we earn from qualifying purchases.