scottklement.com

Hello all.. I have an interesting issue, I think. I am receiving the following message "RPG procedure SS_OPEN in program POI36/HSSFR4 received Java exception "java.lang.RuntimeException: Failed to find a matching shared formula record" when calling method "create" with signa...

Okay.... some progress, I think.

I am able to call the XLCRTDEMO with an option of '0' and it runs to completion but I cannot run it with an option of '1' as it fails with those messages state prior.

Thanks

oh... and the reason for the xmlbeans files is because when I try to go to the link to pull the one everyone has I receive the following message. I think that this may be my issue on why things are not working, but it could be I have my path or environment variables setup wrong, but I think this doe...

Okay... I'm not sure if this should be part of the same thread or not but here goes. I am running the XLCRTDEMO after compiling all the objects. I am receiving the following error message: RPG procedure XLCRTDEMO in program POI36/XLCRTDEMO received Java exception "java.lang.NoClassDefFoundError...

I was just going off the documentation that I had from Dr. Klement's sites and using the exact ones that were listed on there. See link below for my thought path on this... If I can use an more recent version of things by all means I will give that a shot. https://www.easy400.net/hssfcgi/documentati...

Hello, I'm trying to download all the java code to run the HSSF code. I've gotten the POI3.6 and the DOM4j but I cannot find the XmlBeans 2.5.0 anywhere that I've looked, as it seems to be archived off the Apache site now. I can download the xmlbeans-5.1.1... is this version compatible that anyone k...

Scott, Thanks for looking into this. I would think the "style" that I assigned from the global variables would have overwritten the type of data coming in but I guess that is not the case. Interesting. I also noticed that I had a typo on the setHeadings procedure within the service program...

Excel Service Program copy book D***************************************************************** D crtExcelObj PR D Inxssf N Const Options(*NoPass) D***************************************************************** D saveExcelObj PR D filePath 100A Const Varying D fileName 100A Const Varying D****...

Excel Service Program Binding Source STRPGMEXP PGMLVL(*CURRENT) EXPORT SYMBOL(crtExcelObj) EXPORT SYMBOL(saveExcelObj) EXPORT SYMBOL(addSheet) EXPORT SYMBOL(createRow) EXPORT SYMBOL(setColumn) EXPORT SYMBOL(setColumnWidth) EXPORT SYMBOL(setColumnMerge) EXPORT SYMBOL(setHeadings) ENDPGMEXP

TestExcel program FDIVSALES IF E K DISK /Copy QSrc,ExcelC D rowcount S 10I 0 inz(*Zeros) D month S 2P 0 inz(*Zeros) C *Entry Plist C Parm InXssf 1 /Free crtExcelObj(InXssf); For month = 1 to 2; If Month = 1; addSheet('January'); EndIf; If Month = 2; addSheet('February'); EndIf; setColumnWidth( 0: 04...