Search found 14 matches

by wdwisser
Tue May 03, 2022 8:42 pm
Forum: HSSFR4
Topic: Style Format
Replies: 12
Views: 1702

Re: Style Format

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...
by wdwisser
Tue May 03, 2022 12:55 pm
Forum: HSSFR4
Topic: Style Format
Replies: 12
Views: 1702

Re: Style Format

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****...
by wdwisser
Tue May 03, 2022 12:54 pm
Forum: HSSFR4
Topic: Style Format
Replies: 12
Views: 1702

Re: Style Format

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
by wdwisser
Tue May 03, 2022 12:53 pm
Forum: HSSFR4
Topic: Style Format
Replies: 12
Views: 1702

Re: Style Format

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...
by wdwisser
Tue May 03, 2022 12:51 pm
Forum: HSSFR4
Topic: Style Format
Replies: 12
Views: 1702

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...
by wdwisser
Mon May 02, 2022 12:15 pm
Forum: HSSFR4
Topic: Style Format
Replies: 12
Views: 1702

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.
by wdwisser
Fri Apr 29, 2022 11:52 am
Forum: HSSFR4
Topic: Error on XLCRTDEMO
Replies: 8
Views: 1475

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.
by wdwisser
Fri Apr 29, 2022 11:23 am
Forum: HSSFR4
Topic: Style Format
Replies: 12
Views: 1702

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...
by wdwisser
Thu Apr 28, 2022 10:55 pm
Forum: HSSFR4
Topic: Style Format
Replies: 12
Views: 1702

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...
by wdwisser
Wed Feb 23, 2022 3:43 pm
Forum: HSSFR4
Topic: Error on XLCRTDEMO
Replies: 8
Views: 1475

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