|
As a web
application:
We have developed a J2EE intranet web application based
on Struts to access data from multiple iSeries servers and
display the results in Excel. The web application runs on a
Unix-based web server and requires no Microsoft components
other than Excel on the client. User access is controlled by
iSeries security and passwords are protected by SSL. The data
is gathered on request by SQLRPGLE programs on the iSeries and
returned to the web server where the Excel workbook is
constructed. The finished workbook is streamed to the browser
where the user can choose to view or save the workbook to
their local drive.
As a
standalone application running on the iSeries:
We have also developed a system to construct an Excel
workbook containing check reconciliation information in batch
on the iSeries, create an email message with names, addresses
and greeting, attach the finished workbook, and transmit the
completed message via the client’s SMTP server to their bank. Every day - automatically - all with Java. |
Integrate iSeries data into
Microsoft Excel using Java technology. Ask
CCB to help in your MS Office automation projects.