SELECT ACCNO,DESP,DESP2,DEBIT,CREDIT,MDEBIT,MCREDIT FROM INITFILE INTO CURSOR EXCEL_INITFILE
EXCEL_TITLE_NAME_1=TBH
EXCEL_TITLE_NAME_2=LGS(CMONTH(RPTDATE)) + ' ' + STR(YEAR(RPTDATE),4)
EXCEL_SUB_TITLE_1=LGS("A/C No.")
EXCEL_SUB_TITLE_2=LGS("Description")
EXCEL_SUB_TITLE_3=LGS("Description (2)")
EXCEL_SUB_TITLE_4=LGS("YTD-Debit")
EXCEL_SUB_TITLE_5=LGS("YTD-Credit")
EXCEL_SUB_TITLE_6=LGS("MTD-Debit")
EXCEL_SUB_TITLE_7=LGS("MTD-Credit")
EXCEL_COMMAND_AMOUNT(4,7)
EXCEL_COMMAND_TOTAL("G")
EXCEL_COMMAND_71=[OEX.CELLS(EXCEL_TNROW+2,4).VALUE=EXCEL_DEBITT]
EXCEL_COMMAND_72=[OEX.CELLS(EXCEL_TNROW+2,5).VALUE=EXCEL_CREDITT]
EXCEL_COMMAND_73=[OEX.CELLS(EXCEL_TNROW+2,6).VALUE=EXCEL_MDEBITT]
EXCEL_COMMAND_74=[OEX.CELLS(EXCEL_TNROW+2,7).VALUE=EXCEL_MCREDITT]
EXCEL_COMMAND_91=[OEX.COLUMNS("D:G").SELECT]
EXCEL_COMMAND_92=[OEX.SELECTION.NUMBERFORMAT = '_(* #,##0.00_);_(* -#,##0.00;_(* """"??_);_(@_)']