I would like to see the examples. Examples usually nail the concept.
You can send to our emails, or post the code area on midrange?
-----Original Message-----
From: RPG400-L [mailto:rpg400-l-bounces@xxxxxxxxxxxx] On Behalf Of Terry Bullard
Sent: Friday, May 02, 2014 7:49 AM
To: RPG programming on the IBM i (AS/400 and iSeries)
Subject: RE: POI-HSSF classes
Hi Jerry - I for one would be interested in seeing your examples if you don't mind sharing...
Thanks
Terry
-----Original Message-----
From: RPG400-L [mailto:rpg400-l-bounces@xxxxxxxxxxxx] On Behalf Of (WalzCraft) Jerry Forss
Sent: Thursday, May 01, 2014 4:32 PM
To: 'RPG programming on the IBM i (AS/400 and iSeries)'
Subject: RE: POI-HSSF classes
Hi Alan,
We use Scotts code (Modified) every day to read/update/create excels.
The thing with reading cells is that it is the actual contents of the cell.
When you use Excel it interprets the cells and displays the results.
So, if the cells contain the results of a macro that works ok, as long as the cell itself does not contain the formula.
I have several code examples I could send you if you like.
Jerry
-----Original Message-----
From: RPG400-L [mailto:rpg400-l-bounces@xxxxxxxxxxxx] On Behalf Of Alan Cassidy
Sent: Thursday, May 1, 2014 3:14 PM
To: RPG programming on the IBM i (AS/400 and iSeries) (rpg400-l@xxxxxxxxxxxx)
Subject: POI-HSSF classes
I've been tasked with a project that starts with reading data from an Excel file. The file is very complex, includes a Pivot table, and quite a number of multiple sheets. The accountant creates it with a lot of macros. I've not programmed with Excel files yet, or even Java, except to create comma-delimited files.
Do the POI-HSSF classes in our Java handle things like the Pivot table, or will I need to implement them separately? I've downloaded Scott Klement's RPG source and I'm reading up on his excellent articles on the subject, but it will take a bit to get that far.
Alan Cassidy
Senior Developer
Hospital Physician Partners
954-693-0000 ext. 3433 - Direct phone
786-380-9236 - Mobile phone
acassidy@xxxxxxxxxxxxxx<mailto:acassidy@xxxxxxxxxxxxxx>
www.hppartners.com<
http://www.hppartners.com>
[HPP Logo FINAL with name-tag-logo-TM]
Subject to Change Notice:
WalzCraft reserves the right to improve designs, and to change specifications without notice.
Confidentiality Notice:
This message and any attachments may contain confidential and privileged information that is protected by law. The information contained herein is transmitted for the sole use of the intended recipient(s) and should "only" pertain to "WalzCraft" company matters. If you are not the intended recipient or designated agent of the recipient of such information, you are hereby notified that any use, dissemination, copying or retention of this email or the information contained herein is strictly prohibited and may subject you to penalties under federal and/or state law. If you received this email in error, please notify the sender immediately and permanently delete this email. Thank You;
WalzCraft PO Box 1748 La Crosse, WI. 54602-1748
www.walzcraft.com Phone... 608-781-6355
--
This is the RPG programming on the IBM i (AS/400 and iSeries) (RPG400-L) mailing list To post a message email: RPG400-L@xxxxxxxxxxxx To subscribe, unsubscribe, or change list options,
visit:
http://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives at
http://archive.midrange.com/rpg400-l.
--
This is the RPG programming on the IBM i (AS/400 and iSeries) (RPG400-L) mailing list To post a message email: RPG400-L@xxxxxxxxxxxx To subscribe, unsubscribe, or change list options,
visit:
http://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives at
http://archive.midrange.com/rpg400-l.
--------------------------------------------------------------------------------
Confidentiality Notice: This email may contain confidential information or information covered under the Privacy Act, 5 USC 552(a), and/or the Health Insurance Portability and Accountability Act (PL 104-191) and its various implementing regulations and must be protected in accordance with those provisions. It contains information that is legally privileged, confidential or otherwise protected from use or disclosure. This e-mail message, including any attachments, is for the sole use of the intended recipient(s). Any unauthorized review, use, disclosure or distribution is prohibited. You, the recipient, are obligated to maintain it in a safe, secure and confidential manner. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message. Thank you.
--------------------------------------------------------------------------------
midrange.com
