Search found 30 matches
- Tue May 03, 2022 12:51 pm
- Forum: HSSFR4
- Topic: Style Format
- Replies: 12
- Views: 20034
Re: Style Format
Excel Service Program H NoMain H OPTION(*SRCSTMT: *NODEBUGIO: *NOSHOWCPY) H THREAD(*SERIALIZE) H BNDDIR('HSSF') ****************************************************************** ** ** Excel - Generate an excel file based on user parameters. ** Description: This program will allow a user to generate...
- Mon May 02, 2022 12:15 pm
- Forum: HSSFR4
- Topic: Style Format
- Replies: 12
- Views: 20034
Re: Style Format
I've attached my Excel service program and TestExcel program that creates the Excel file. Let me know your thoughts when you have a few moments to review. I don't see any "free" until after I save the Excel file.
- Fri Apr 29, 2022 11:52 am
- Forum: HSSFR4
- Topic: Error on XLCRTDEMO
- Replies: 10
- Views: 27394
Re: Error on XLCRTDEMO
I didn't have my java path setup correctly. I had a friend help me out and now it works just fine... my mistake from learning as I go.
- Fri Apr 29, 2022 11:23 am
- Forum: HSSFR4
- Topic: Style Format
- Replies: 12
- Views: 20034
Re: Style Format
They are global variables from this code... // ---------------------------------------------------- // Create a cell style for numbers so that they are // right-aligned and the number is formatted nicely. // ---------------------------------------------------- Numeric = SSWorkbook_createCellStyle(bo...
- Thu Apr 28, 2022 10:55 pm
- Forum: HSSFR4
- Topic: Style Format
- Replies: 12
- Views: 20034
Style Format
Hello, I created a service program to allow my programs to directly call the different routines for creating an excel document using your examples in POI36. When I try to apply the style to the cell for the row/column it doesn't seem to take. For example I an pushing a numeric value and applying the...
- Wed Feb 23, 2022 3:43 pm
- Forum: HSSFR4
- Topic: Error on XLCRTDEMO
- Replies: 10
- Views: 27394
Re: Error on XLCRTDEMO
I entered the following command after putting the poi36 files in the IFS... I'm now getting an error that it cannot find the jar files. ADDENVVAR ENVVAR(CLASSPATH) + VALUE('/Java/HSSF/poi-3.6-20091214.jar+ :/Java/HSSF/poi-ooxml-3.6-20091214.jar+ :/Java/HSSF/poi-ooxml-schemas-3.6-20091214.jar+ :/Java...
- Tue Feb 15, 2022 8:37 pm
- Forum: HSSFR4
- Topic: Error on XLCRTDEMO
- Replies: 10
- Views: 27394
Re: Error on XLCRTDEMO
Thanks Dr. Klement... I really appreciate the input. I did download the POI 3.6 and the programs did run successfully so a step in the right direction. I'm assuming, after doing all this, that the POI36 library meant that you had this working with the POI version downloaded. A little slow on the upt...
- Tue Feb 15, 2022 7:04 pm
- Forum: HSSFR4
- Topic: Error on XLCRTDEMO
- Replies: 10
- Views: 27394
Re: Error on XLCRTDEMO
Also, do I need all the folders from the 3.6 version or just the main folder to be there (e.g. lib, docs, ooxml-lib)? I've attached an image of the folder I downloaded.
Thanks again.
Thanks again.
- Tue Feb 15, 2022 7:00 pm
- Forum: HSSFR4
- Topic: Error on XLCRTDEMO
- Replies: 10
- Views: 27394
Re: Error on XLCRTDEMO
Thanks for the reply. I was going off of the instructions I had that said to put the jar files in the ext folder. I'm very new to the Java realm so I'm not even sure how the ClassPath works. Is it just a folder where your jar files exist? I will download the 3.6 version of POI but I'm not sure what ...
- Tue Feb 15, 2022 5:15 pm
- Forum: HSSFR4
- Topic: Error on XLCRTDEMO
- Replies: 10
- Views: 27394
Error on XLCRTDEMO
Hello all... I am new to the board and I just downloaded and compiled the HSSF from SK website. I am trying to run XLCRTDEMO and I am getting the following error message (RNX0301): Cause . . . . . : RPG procedure XLCRTDEMO in program POI36/XLCRTDEMO received Java exception "java.lang.NoClassDef...