Search found 10 matches
- Wed Apr 06, 2022 1:25 pm
- Forum: General
- Topic: Young and Dumb, but at least I know it.
- Replies: 3
- Views: 10125
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...
- Thu Aug 12, 2021 1:51 pm
- Forum: HSSFR4
- Topic: Apache POI 3.6 - Help with RowShift
- Replies: 10
- Views: 115276
Re: Apache POI 3.6 - Help with RowShift
Update*
Rowshift works as expected, when you are using the correct file type.
I switched to using a .xls file and everything clicked.
Jason
Rowshift works as expected, when you are using the correct file type.

I switched to using a .xls file and everything clicked.
Jason
- Wed Aug 11, 2021 1:38 am
- Forum: HSSFR4
- Topic: Apache POI 3.6 - Help with RowShift
- Replies: 10
- Views: 115276
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.
- Wed Aug 11, 2021 12:17 am
- Forum: HSSFR4
- Topic: Apache POI 3.6 - Help with RowShift
- Replies: 10
- Views: 115276
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...
- Tue Aug 10, 2021 9:01 pm
- Forum: HSSFR4
- Topic: Apache POI 3.6 - Help with RowShift
- Replies: 10
- Views: 115276
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 ...
- Tue Aug 10, 2021 5:24 pm
- Forum: HSSFR4
- Topic: Apache POI 3.6 - Help with RowShift
- Replies: 10
- Views: 115276
Re: Apache POI 3.6 - Help with RowShift
My wife may have a differing opinion. 

- Tue Aug 10, 2021 4:51 pm
- Forum: HSSFR4
- Topic: Apache POI 3.6 - Help with RowShift
- Replies: 10
- Views: 115276
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

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


- Tue Aug 10, 2021 3:53 pm
- Forum: HSSFR4
- Topic: Apache POI 3.6 - Help with RowShift
- Replies: 10
- Views: 115276
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...
- Tue Aug 10, 2021 3:37 pm
- Forum: HSSFR4
- Topic: Apache POI 3.6 - ClassPath error in XSSF mode
- Replies: 3
- Views: 80042
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.
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.
- Thu Jul 29, 2021 12:41 pm
- Forum: HSSFR4
- Topic: Apache POI 3.6 - ClassPath error in XSSF mode
- Replies: 3
- Views: 80042
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 ...