private void setInvoiceHeader(SysExcelWorkSheet xlsWorkSheet,CustInvoiceJour custInvoiceJour) { xlsWorkSheet.cells().item(row,1).value("FK"); xlsWorkSheet.cells().item(row,2).value(str2num(CustTable::find(custInvoiceJour.InvoiceAccount).TECFakturPajakTypeId)); xlsWorkSheet.cells().range(strFmt("B%1:B%1",row)).numberFormat("00"); xlsWorkSheet.cells().item(row,3).value(enum2int(custInvoiceJour.TECIsSubtitute)); xlsWorkSheet.cells().item(row,4).value(str2num(strFmt("%1", strRem(custInvoiceJour.TECFakturPajakListId, ".-")))); xlsWorkSheet.cells().range(strFmt("D%1:D%1",row)).numberFormat("0000000000000"); xlsWorkSheet.cells().item(row,5).value(mthOfYr(custInvoiceJour.InvoiceDate)); xlsWorkSheet.cells().item(row,6).value(year(custInvoiceJour.InvoiceDate)); xlsWorkSheet.cells().item(row,7).value(date2str(custInvoiceJour.InvoiceDate, 213, 1, 4, 1, 4, 4)); xlsWorkSheet.cells().item(row,8).value(str2num(strFmt("%1", strRem(custInvoiceJour.custTable_InvoiceAccount().TECNPWP, ".-")))); xlsWorkSheet.cells().range(strFmt("H%1:H%1",row)).numberFormat("00000000000000"); xlsWorkSheet.cells().item(row,9).value(CustTable::find(custInvoiceJour.InvoiceAccount).name()); xlsWorkSheet.cells().item(row,10).value(strRTrim(CustTable::find(custInvoiceJour.InvoiceAccount).postalAddress().Street)); xlsWorkSheet.cells().item(row,11).value(round(custInvoiceJour.SalesBalance,0)); xlsWorkSheet.cells().range(strFmt("K%1:K%1",row)).numberFormat("0"); xlsWorkSheet.cells().item(row,12).value(round(custInvoiceJour.SumTax,0)); xlsWorkSheet.cells().range(strFmt("L%1:L%1",row)).numberFormat("0"); xlsWorkSheet.cells().item(row,13).value(0); xlsWorkSheet.cells().item(row,14).value(""); xlsWorkSheet.cells().item(row,15).value(0); xlsWorkSheet.cells().item(row,16).value(0); xlsWorkSheet.cells().item(row,17).value(0); xlsWorkSheet.cells().item(row,18).value(0); xlsWorkSheet.cells().item(row,19).value(custInvoiceJour.InvoiceId); row++; totalCount++; }
more example and source :
http://patrikluca.blogspot.cz/2010/04/export-to-excel-with-x-code-sequel.html