Yes, please, John, I need all the examples I can get at this point because coding for Excel and Java both on the "i" is all new to me, and I've done pitiful little of it on the PC as well.
Alan
Alan Cassidy
Senior Developer
Hospital Physician Partners
954-693-0000 ext. 3433 - Direct phone
786-380-9236 - Mobile phone
acassidy@xxxxxxxxxxxxxx
www.hppartners.com
-----Original Message-----
From: RPG400-L [mailto:rpg400-l-bounces@xxxxxxxxxxxx] On Behalf Of John Rusling
Sent: Friday, May 02, 2014 9:36 AM
To: rpg400-l@xxxxxxxxxxxx
Subject: RE: POI-HSSF classes
Hi Alan,
I got formulaEvaluator to work on a project awhile back.
Went something like -
open spreadsheet to read
set sheet to read
do this stuff -
// Do this after workbook is opened to be able to evaluate formulas
helper = SSWorkbook_getCreationHelper(book);
formulaEvaluator = creationHelper_createFormulaEvaluator(helper);
set row to read
set column to read (that has formula in it)
this bit extracts the actual value -
myNbr = extractNumericValue(cell);
I can post relevant code, prototypes if you need.
hth,
John
--
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
