Search found 10 matches

by jmaple79
Wed Apr 06, 2022 1:25 pm
Forum: General
Topic: Young and Dumb, but at least I know it.
Replies: 3
Views: 2865

Young and Dumb, but at least I know it.

Hey all you very experienced I-Series development professionals! :?: I am in need of guidance. I am a converted COBOL/Natural developer who worked in a very strictly controlled environment who is taking on a position in an I-Series/RPGLE shop. I am looking for a reasonably priced school/company that...
by jmaple79
Thu Aug 12, 2021 1:51 pm
Forum: HSSFR4
Topic: Apache POI 3.6 - Help with RowShift
Replies: 10
Views: 36020

Re: Apache POI 3.6 - Help with RowShift

Update*
Rowshift works as expected, when you are using the correct file type. :oops:

I switched to using a .xls file and everything clicked.

Jason
by jmaple79
Wed Aug 11, 2021 1:38 am
Forum: HSSFR4
Topic: Apache POI 3.6 - Help with RowShift
Replies: 10
Views: 36020

Re: Apache POI 3.6 - Help with RowShift

I'll try that. I am not real confident with this yet, so i hope you all don't mind me bugging you with it as i get stuck.
by jmaple79
Wed Aug 11, 2021 12:17 am
Forum: HSSFR4
Topic: Apache POI 3.6 - Help with RowShift
Replies: 10
Views: 36020

Re: Apache POI 3.6 - Help with RowShift

Fair question. Maybe I am not thinking correctly on this. My thought process revolved around all the existing formatting in the spreadsheet to match the original PDF version of the statement. I thought, if I could simply fill in some details, it would cut down on complexity since we are brand new to...
by jmaple79
Tue Aug 10, 2021 9:01 pm
Forum: HSSFR4
Topic: Apache POI 3.6 - Help with RowShift
Replies: 10
Views: 36020

Re: Apache POI 3.6 - Help with RowShift

New question....Old topic this time I am stumped I am trying to shift rows down in a spreadsheet to insert a new row. Overall goal - Using existing Template Spreadsheet. Recreate an account monthly customer statement in Excel from the iseries. Create an account statement by inserting detail records ...
by jmaple79
Tue Aug 10, 2021 5:24 pm
Forum: HSSFR4
Topic: Apache POI 3.6 - Help with RowShift
Replies: 10
Views: 36020

Re: Apache POI 3.6 - Help with RowShift

My wife may have a differing opinion. :lol:
by jmaple79
Tue Aug 10, 2021 4:51 pm
Forum: HSSFR4
Topic: Apache POI 3.6 - Help with RowShift
Replies: 10
Views: 36020

Re: Apache POI 3.6 - Help with RowShift

I have got to stop answering my own questions AFTER asking a group of peers.

The answer was, I needed to remove the 'Class' statement in the definition blow as well are the 'O'.

SMH. lol
:lol: :roll:
by jmaple79
Tue Aug 10, 2021 3:53 pm
Forum: HSSFR4
Topic: Apache POI 3.6 - Help with RowShift
Replies: 10
Views: 36020

Apache POI 3.6 - Help with RowShift

I am just coming back to RPGLE after a long stint away from development so I am rusty (like 10 years of rust). Apache POI and java are brand new concepts to my new company and I was selected to learn them for us. So far it has been fun but I am stuck at the moment and it is probably just lack of a b...
by jmaple79
Tue Aug 10, 2021 3:37 pm
Forum: HSSFR4
Topic: Apache POI 3.6 - ClassPath error in XSSF mode
Replies: 2
Views: 18768

Re: Apache POI 3.6 - ClassPath error in XSSF mode

Hi Scott,
I ran into a case of, I didn't know what I didn't know. I was able to get the Apache POI 3.6 and Your matching software talking to each other. I have another question though and I will post in a different forum.
by jmaple79
Thu Jul 29, 2021 12:41 pm
Forum: HSSFR4
Topic: Apache POI 3.6 - ClassPath error in XSSF mode
Replies: 2
Views: 18768

Apache POI 3.6 - ClassPath error in XSSF mode

New here, so forgive me if this has all been answered once or twice. I am trying to implement Apache POI and the HssfR4/xlparser software at the small business I work for and I am running into walls. I am using the Apache POI 3.6 version and trying to stay as close to the instruction that Scott has ...