Ich habe es unter 7.2 hinbekommen und musste dazu die makefile.ibm etwas modifizieren
Anbei ein Programm, dass folgende Excel-Tabelle erstellt

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;
//------------------------------------------------------------------//
Bookmarks