SELECT * FROM INITFILE INTO CURSOR EXCEL_INITFILE
EXCEL_TITLE_NAME_1=LGS(IIF(FT="AR","Customer Yearly Sales Analysis","Customer Yearly Sales Analysis"))
EXCEL_SUB_TITLE_1=LGS(IIF(FT="AR","Cust.No","Supp.No."))
EXCEL_SUB_TITLE_2=LGS("Name")
EXCEL_SUB_TITLE_3=LGS("Name (2)")
EXCEL_SUB_TITLE_4=LGS(MONTH11) + "'" + STR(YEAR11,4)
EXCEL_SUB_TITLE_5=LGS(MONTH12) + "'" + STR(YEAR12,4)
EXCEL_SUB_TITLE_6=LGS(MONTH13) + "'" + STR(YEAR13,4)
EXCEL_SUB_TITLE_7=LGS(MONTH14) + "'" + STR(YEAR14,4)
EXCEL_SUB_TITLE_8=LGS(MONTH15) + "'" + STR(YEAR15,4)
EXCEL_SUB_TITLE_9=LGS(MONTH16) + "'" + STR(YEAR16,4)
EXCEL_SUB_TITLE_10=LGS(MONTH17) + "'" + STR(YEAR17,4)
EXCEL_SUB_TITLE_11=LGS(MONTH18) + "'" + STR(YEAR18,4)
EXCEL_SUB_TITLE_12=LGS(MONTH19) + "'" + STR(YEAR19,4)
EXCEL_SUB_TITLE_13=LGS(MONTH20) + "'" + STR(YEAR20,4)
EXCEL_SUB_TITLE_14=LGS(MONTH21) + "'" + STR(YEAR21,4)
EXCEL_SUB_TITLE_15=LGS(MONTH22) + "'" + STR(YEAR22,4)
EXCEL_SUB_TITLE_16=LGS(MONTH23) + "'" + STR(YEAR23,4)
EXCEL_SUB_TITLE_17=LGS(MONTH24) + "'" + STR(YEAR24,4)
EXCEL_SUB_TITLE_18=LGS(MONTH25) + "'" + STR(YEAR25,4)
EXCEL_SUB_TITLE_19=LGS(MONTH26) + "'" + STR(YEAR26,4)
EXCEL_SUB_TITLE_20=LGS(MONTH27) + "'" + STR(YEAR27,4)
EXCEL_SUB_TITLE_21=LGS(MONTH28) + "'" + STR(YEAR28,4)
EXCEL_SUB_TITLE_22=LGS("Total")
EXCEL_COMMAND_AMOUNT(4,22)

EXCEL_COMMAND_51=[OEX.CELLS(EXCEL_TNROW+2,4).VALUE=TSP11]
EXCEL_COMMAND_52=[OEX.CELLS(EXCEL_TNROW+2,5).VALUE=TSP12]
EXCEL_COMMAND_53=[OEX.CELLS(EXCEL_TNROW+2,6).VALUE=TSP13]
EXCEL_COMMAND_54=[OEX.CELLS(EXCEL_TNROW+2,7).VALUE=TSP14]
EXCEL_COMMAND_55=[OEX.CELLS(EXCEL_TNROW+2,8).VALUE=TSP15]
EXCEL_COMMAND_56=[OEX.CELLS(EXCEL_TNROW+2,9).VALUE=TSP16]
EXCEL_COMMAND_57=[OEX.CELLS(EXCEL_TNROW+2,10).VALUE=TSP17]
EXCEL_COMMAND_58=[OEX.CELLS(EXCEL_TNROW+2,11).VALUE=TSP18]
EXCEL_COMMAND_59=[OEX.CELLS(EXCEL_TNROW+2,12).VALUE=TSP19]
EXCEL_COMMAND_60=[OEX.CELLS(EXCEL_TNROW+2,13).VALUE=TSP20]
EXCEL_COMMAND_61=[OEX.CELLS(EXCEL_TNROW+2,14).VALUE=TSP21]
EXCEL_COMMAND_62=[OEX.CELLS(EXCEL_TNROW+2,15).VALUE=TSP22]
EXCEL_COMMAND_63=[OEX.CELLS(EXCEL_TNROW+2,16).VALUE=TSP23]
EXCEL_COMMAND_66=[OEX.CELLS(EXCEL_TNROW+2,17).VALUE=TSP24]
EXCEL_COMMAND_67=[OEX.CELLS(EXCEL_TNROW+2,18).VALUE=TSP25]
EXCEL_COMMAND_68=[OEX.CELLS(EXCEL_TNROW+2,19).VALUE=TSP26]
EXCEL_COMMAND_69=[OEX.CELLS(EXCEL_TNROW+2,20).VALUE=TSP27]
EXCEL_COMMAND_70=[OEX.CELLS(EXCEL_TNROW+2,21).VALUE=TSP28]
EXCEL_COMMAND_71=[OEX.CELLS(EXCEL_TNROW+2,22).VALUE=TSP00]

EXCEL_COMMAND_81=[OEX.RANGE('A'+ALLTRIM(STR(EXCEL_TNROW+2))+':V'+ALLTRIM(STR(EXCEL_TNROW+2))).BORDERS(8).LINESTYLE = 1]
EXCEL_COMMAND_82=[OEX.RANGE('A'+ALLTRIM(STR(EXCEL_TNROW+2))+':V'+ALLTRIM(STR(EXCEL_TNROW+2))).BORDERS(8).WEIGHT = 3]
EXCEL_COMMAND_83=[OEX.RANGE('A'+ALLTRIM(STR(EXCEL_TNROW+2))+':V'+ALLTRIM(STR(EXCEL_TNROW+2))).BORDERS(9).LINESTYLE = 1]
EXCEL_COMMAND_84=[OEX.RANGE('A'+ALLTRIM(STR(EXCEL_TNROW+2))+':V'+ALLTRIM(STR(EXCEL_TNROW+2))).BORDERS(9).WEIGHT = 3]