Re: Scott's POI/HSSF from RPG articles; importing Excel .xlsx into native i table

You would use SS routines instead.

So:

D book            s                   like(SSWorkbook)
D sheet           s                   like(SSSheet)
D row             s                   like(SSRow)
D cell            s                   like(SSCell)

ss_begin_object_group(100);
filename = 'a.xlsx';
book = ss_open(filename);
if (book = *null);
  dsply 'Unable to open workbook!';
endif;



On 4/3/2018 8:23 PM, B. Dietz wrote:

While not for reading XLSX files, I ran across this recently. Easy enough to compile.


https://www.linkedin.com/pulse/libxlsxwriter-creating-spreadsheets-natively-mihael-schmidt/ <https://www.linkedin.com/pulse/libxlsxwriter-creating-spreadsheets-natively-mihael-schmidt/>

https://bitbucket.org/m1hael/libxlsxwriter <https://bitbucket.org/m1hael/libxlsxwriter>

Bryan

On Apr 3, 2018, at 1:39 PM, Jon Paris <jon.paris@xxxxxxxxxxxxxx> wrote:

Latest version handles both Rob I believe.


Jon Paris

www.partner400.com
www.SystemiDeveloper.com

On Apr 3, 2018, at 3:54 PM, Rob Berendt <rob@xxxxxxxxx> wrote:

Then the question is: does hssf work with xlsx?
Isn't hssf (which literally stands for Horrible Spread Sheet Format) for
xls and not xlsx?


Rob Berendt
--
IBM Certified System Administrator - IBM i 6.1
Group Dekko
Dept 1600
Mail to: 2505 Dekko Drive
Garrett, IN 46738
Ship to: Dock 108
6928N 400E
Kendallville, IN 46755
http://www.dekko.com





From: Buck Calabro <kc2hiz@xxxxxxxxx>
To: midrange-l@xxxxxxxxxxxx
Date: 04/03/2018 03:26 PM
Subject: Re: Scott's POI/HSSF from RPG articles; importing Excel
.xlsx into native i table
Sent by: "MIDRANGE-L" <midrange-l-bounces@xxxxxxxxxxxx>



On 4/3/2018 2:14 PM, Dan wrote:

Went searching for utilities to download to import Excel .xlsx files to

a

table on our i, found Scott Klement's website
https://www.scottklement.com/poi/, clicked on several of the article

links,

and am getting nothing but:

Our sites are currently under maintenance.
Please try back later.
We apologize for any inconvenience.
Penton

Seeing as iSeriesNetwork's website has been behaving for the past

several

years like the Chinese space station recently, I wonder if this is the
death knell. Articles have been, for the most part, available, but

source

code downloads have been AWOL for quite some time.

Giovanni Perotti is maintaining a utility called XLSTABLE (as in 'XLS to
DB2 table') on http://www.easy400.net/ Look for XLPARSE2
http://www.easy400.net/xlparse2/html/page1.htm

FWIW, I'm starting from ground zero on POI, so I need the "beginnner's
guide to POI", so to speak.

If you're comfortable with Java, the foundational POI classes are a
great place to start looking. If you're not comfortable prowling the
Javadoc, then... hm. You will need to become familiar when it's time to
extend / debug the utility. And when that day comes, you'll be best
served by taking online examples /in Java/, putting them on your PC,
understanding how they work, and only then trying to write wrappers for
RPG / debug the RPG.

--
--buck

http://wiki.midrange.com
Your updates make it better!

--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at https://archive.midrange.com/midrange-l.

Please contact support@xxxxxxxxxxxx for any subscription related
questions.

Help support midrange.com by shopping at amazon.com with our affiliate
link: http://amzn.to/2dEadiD


--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at https://archive.midrange.com/midrange-l.

Please contact support@xxxxxxxxxxxx for any subscription related questions.

Help support midrange.com by shopping at amazon.com with our affiliate link: http://amzn.to/2dEadiD

--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at https://archive.midrange.com/midrange-l.

Please contact support@xxxxxxxxxxxx for any subscription related questions.

Help support midrange.com by shopping at amazon.com with our affiliate link: http://amzn.to/2dEadiD