×
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.
No more obfuscated than using a CL to call RPG to update DB2.
Sent from Lotus Traveler
Mark Murphy/STAR BASE Consulting Inc. --- RE: Update Excel with RPG ---
From:"Mark Murphy/STAR BASE Consulting Inc." <mmurphy@xxxxxxxxxxxxxxx>To:"Midrange Systems Technical Discussion" <midrange-l@xxxxxxxxxxxx>Date:Mon, Feb 29, 2016 4:29 PMSubject:RE: Update Excel with RPG
But it works, and there is no comparable RPG library. It would take quite a bit of work to make one that has the capabilities of POI. As Vern mentioned, you can make something that will work for your purposes, but then you need to understand the xlsx file structure, and adding new features is more work. If someone knows of something that is comparable, let me know. Maybe if there are enough interested parties, we could port something. Maybe there is something written in C or C++ out there that is compiled for PASE, or that can be ported to qshell? Mark Murphy STAR BASE Consulting, Inc. mmurphy@xxxxxxxxxxxxxxx -----Matt Olson wrote: ----- To: Midrange Systems Technical Discussion From: Matt Olson Date: 02/29/2016 03:06PM Subject: RE: Update Excel with RPG RPG to JAVA to Excel? Sounds like a Rube Goldberg machine ;-) -----Original Message----- From: Mark Murphy/STAR BASE Consulting Inc. [mailto:mmurphy@xxxxxxxxxxxxxxx] Sent: Monday, February 29, 2016 1:55 PM To: Midrange Systems Technical Discussion Subject: Re: Update Excel with RPG Thanks, I missed that it passes back an unused object, but now that you say that, I see it in the Java docs. Mark Murphy STAR BASE Consulting, Inc. mmurphy@xxxxxxxxxxxxxxx -----broehmer@xxxxxxxxxxxxxxx wrote: ----- To: Midrange Systems Technical Discussion From: broehmer@xxxxxxxxxxxxxxx Date: 02/25/2016 04:48PM Subject: Re: Update Excel with RPG For anyone who was following this thread, the following will correctly provide all the required entries in hssf_h: D AUTOFILTER_CLASS... D c 'org.apache.poi.ss.usermodel- D .AutoFilter' D SSAutoFilter... D S O CLASS(*JAVA D : AUTOFILTER_CLASS) D ssSheet_setAutoFilter... -Your data has been truncated.
As an Amazon Associate we earn from qualifying purchases.
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.
midrange.com
