Re: RPG and Excel -- RPG400-L

× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.

I have not worked with Excel files in RPG so it would be a first time thing, but we do have programs that use the CPYTOIMPF and create csv files.
But I was looking to skip a few steps as we need data in a table in a spreadsheet.
If we just create a csv then a PC user has to import the csv file into Excel, select the data imported and create a table over it.

We have a Windows application that reads the data from an Excel table and takes over a client access session and types the data into the screen.
Saves a lot of typing.
This application requires the Table setup so I have no other options.

Best Regards,

Thomas Garvey

On 5/1/2015 11:40 AM, John Yeung wrote:

I'm pretty sure the underlying POI library (from Apache, written in
Java) can do it. Whether that functionality is exposed by Scott's RPG
interface, I don't know.

Have you already worked with Excel files in RPG, and are just trying
to add new features? Or is this a first-time thing? Because if
you're doing this from scratch, it's a good opportunity to at least
consider other options.

John Y.

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.