scottklement.com

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...

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.

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.

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...

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...

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...

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...

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 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 ...

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...