X++ Export Excel

static void ExportExcel(Args _args){   int x;   SysExcelApplication          xlsApplication;   SysExcelWorkBooks            xlsWorkBookCollection;   SysExcelWorkBook             xlsWorkBook;   SysExcelWorkSheets           xlsWorkSheetCollection;   SysExcelWorkSheet            xlsWorkSheet;   SysExcelRange                xlsRange;   int                          row = 1;   str                          fileName;
   ;   fileName = "C:\\Users\UserName\Downloads\TemplateShip.xls";
   //Initialize Excel instance   xlsApplication           = SysExcelApplication::construct();
   //Open Excel document   //xlsApplication.visible(true);
   //Create Excel WorkBook and WorkSheet   xlsWorkBookCollection    = xlsApplication.workbooks();   xlsWorkBook              = xlsWorkBookCollection.add();   xlsWorkSheetCollection   = xlsWorkBook.worksheets();   xlsWorkSheet             = xlsWorkSheetCollection.itemFromNum(1);

   xlsWorkSheet.cells().item(row,1).value(strfmt("'%1",row-1));          //xlsWorkSheet.cells().item(row,2).value(_BillTable.PrintAccount);//          xlsWorkSheet.cells().item(row,3).value(DocType);//          xlsWorkSheet.cells().item(row,4).value(_BillLine.InvoiceId);//          xlsWorkSheet.cells().item(row,5).value(date2str(_BillLine.InvoiceDate, 2, 2, -1, 2, -1, 4));//          xlsWorkSheet.cells().item(row,6).value(date2str(_BillLine.DueDate, 2, 2, -1, 2, -1, 4));//          xlsWorkSheet.cells().item(row,7).value(_BillLine.BillAmount);//          xlsWorkSheet.cells().item(row,8).value(_BillLine.BillAmount);//          xlsWorkSheet.cells().item(row,10).value(BillDate);//          xlsWorkSheet.cells().item(row,11).value(_BillTable.BillId);//          xlsWorkSheet.cells().item(row,12).value(TaxInvoice);//          xlsWorkSheet.cells().item(row,13).value(_BillTable.CustAccount);//          xlsWorkSheet.cells().item(row,14).value( strupr(_BillTable.dataAreaId));          row++;



   //Save Excel document   xlsWorkbook.saveAs(fileName);
   //Open Excel document   xlsApplication.visible(true);
   //Close Excel    xlsApplication.quit();   //xlsApplication.finalize();}