Ich habe es unter 7.2 hinbekommen und musste dazu die makefile.ibm etwas modifizieren

Anbei ein Programm, dass folgende Excel-Tabelle erstellt

Click image for larger version. 

Name:	capture20181213093005989.png 
Views:	17 
Size:	26,6 KB 
ID:	497

Code:
         ctl-opt main(main) dftactgrp(*no) alloc(*teraspace)                                                            
                 actgrp('CRTEXCEL') bnddir('LIBXLSX');                                                                  
      //------------------------------------------------------------------//                                            
      //                                                                  //                                            
      // Create Excel-Sheet                                               //                                            
      //                                                                  //                                            
      //-----------------                                                 //                                            
      // R.Ross 03.2018 *                                                 //                                            
      //------------------------------------------------------------------//                                            
      // Prototypes                                                       //                                            
      //------------------------------------------------------------------//                                            
                                                                                                                        
      /include libxlsx/qcpysrc,xlsxwriter                                                                               
                                                                                                                        
      //------------------------------------------------------------------//                                            
      // Main                                                             //                                            
      //------------------------------------------------------------------//                                            
         dcl-proc main;                                                                                                 
                                                                                                                        
         dcl-s   workbook    pointer;                                                                                   
         dcl-s   worksheet   pointer;                                                                                   
         dcl-s   format01    pointer;                                                                                   
         dcl-s   format02    pointer;                                                                                   
         dcl-s   bold        pointer;                                                                                   
                                                                                                                        
           workbook  = workbook_new('/tmp/xlsx/formula.xlsx');                                                          
           worksheet = workbook_add_worksheet(workbook:'Testsheet 1');                                                  
                                                                                                                        
           format01  = workbook_add_format(workbook);                                                                   
           format_set_num_format(format01:'#,##0.00');                                                                  
           format02  = workbook_add_format(workbook);                                                                   
           format_set_num_format(format02:'#,##0.00');                                                                  
           format_set_bold(format02);                                                                                   
                                                                                                                        
           bold      = workbook_add_format(workbook);                                                                   
           format_set_bold(bold);                                                                                       
                                                                                                                        
           worksheet_write_string(worksheet:0:0:'Monat':*null);                                                         
           worksheet_write_string(worksheet:0:1:'Umsatz':*null);                                                        
                                                                                                                        
           worksheet_write_string(worksheet:1:0:'Januar':*null);                                                        
           worksheet_write_string(worksheet:2:0:'Februar':*null);                                                       
           worksheet_write_string(worksheet:3:0:'März':*null);                                                          
           worksheet_write_string(worksheet:4:0:'April':*null);                                                         
           worksheet_write_string(worksheet:5:0:'Mai':*null);                                                           
                                                                                                                        
           worksheet_write_number(worksheet:1:1:6250:format01);                                                         
           worksheet_write_number(worksheet:2:1:3580:format01);                                                         
           worksheet_write_number(worksheet:3:1:780:format01);                                                          
           worksheet_write_number(worksheet:4:1:43580:format01);                                                        
           worksheet_write_number(worksheet:5:1:22890:format01);                                                        
                                                                                                                        
           worksheet_write_string(worksheet:6:0:'Summe':bold);                                                          
                                                                                                                        
           worksheet_write_formula(worksheet:6:1:'=SUM(B2:B6)':format02);                                               
                                                                                                                        
           workbook_close(workbook);                                                                                    
                                                                                                                        
         end-proc;                                                                                                      
      //------------------------------------------------------------------//