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; //------------------------------------------------------------------//
![[NEWSboard IBMi Forum]](images/duke/nblogo.gif)



Mit Zitat antworten
Bookmarks