private void CreateLRClaimSheet(IExcel excelApp)
{
excelApp.SetCellValue(1, "A", "BusiNo");
excelApp.SetCellValue(1, "B", "CompanyCode");
excelApp.SetCellValue(1, "C", "GrpPolicyNo");
excelApp.SetCellValue(1, "D", "GrpProductNo");
excelApp.SetCellValue(1, "E", "PolicyNo");
excelApp.SetCellValue(1, "F", "ProductNo");
excelApp.SetCellValue(1, "G", "GPFlag");
excelApp.SetCellValue(1, "H", "MainProductNo");
excelApp.SetCellValue(1, "I", "MainProductFlag");
excelApp.SetCellValue(1, "J", "ProductCode");
excelApp.SetCellValue(1, "K", "LiabilityCode");
excelApp.SetCellValue(1, "L", "LiabilityName");
excelApp.SetCellValue(1, "M", "GetLiabilityCode");
excelApp.SetCellValue(1, "N", "GetLiabilityName");
excelApp.SetCellValue(1, "O", "BenefitType");
excelApp.SetCellValue(1, "P", "TermType");
excelApp.SetCellValue(1, "Q", "ManageCom");
excelApp.SetCellValue(1, "R", "SignDate");
excelApp.SetCellValue(1, "S", "EffDate");
excelApp.SetCellValue(1, "T", "PolYear");
excelApp.SetCellValue(1, "U", "InvalidDate");
excelApp.SetCellValue(1, "V", "UWConclusion");
excelApp.SetCellValue(1, "W", "PolStatus");
excelApp.SetCellValue(1, "X", "Status");
excelApp.SetCellValue(1, "Y", "BasicSumInsured");
excelApp.SetCellValue(1, "Z", "RiskAmnt");
excelApp.SetCellValue(1, "AA", "Premium");
excelApp.SetCellValue(1, "AB", "DeductibleType");
excelApp.SetCellValue(1, "AC", "Deductible");
excelApp.SetCellValue(1, "AD", "ClaimRatio");
excelApp.SetCellValue(1, "AE", "AccountValue");
excelApp.SetCellValue(1, "AF", "FacultativeFlag");
excelApp.SetCellValue(1, "AG", "AnonymousFlag");
excelApp.SetCellValue(1, "AH", "WaiverFlag");
excelApp.SetCellValue(1, "AI", "WaiverPrem");
excelApp.SetCellValue(1, "AJ", "FinalCashValue");
excelApp.SetCellValue(1, "AK", "InsuredNo");
excelApp.SetCellValue(1, "AL", "InsuredName");
excelApp.SetCellValue(1, "AM", "InsuredSex");
excelApp.SetCellValue(1, "AN", "InsuredCertType");
excelApp.SetCellValue(1, "AO", "InsuredCertNo");
excelApp.SetCellValue(1, "AP", "OccupationType");
excelApp.SetCellValue(1, "AQ", "AppntAge");
excelApp.SetCellValue(1, "AR", "PreAge");
excelApp.SetCellValue(1, "AS", "FinalLiabilityReserve");
excelApp.SetCellValue(1, "AT", "ProfessionalFee");
excelApp.SetCellValue(1, "AU", "SubStandardFee");
excelApp.SetCellValue(1, "AV", "EMRate");
excelApp.SetCellValue(1, "AW", "ProjectFlag");
excelApp.SetCellValue(1, "AX", "InsurePeoples");
excelApp.SetCellValue(1, "AY", "SaparateFlag");
excelApp.SetCellValue(1, "AZ", "ReInsuranceContNo");
excelApp.SetCellValue(1, "BA", "ReinsurerCode");
excelApp.SetCellValue(1, "BB", "ReinsurerName");
excelApp.SetCellValue(1, "BC", "ReinsurMode");
excelApp.SetCellValue(1, "BD", "ReinsuranceAmnt");
excelApp.SetCellValue(1, "BE", "RetentionAmount");
excelApp.SetCellValue(1, "BF", "QuotaSharePercentage");
excelApp.SetCellValue(1, "BG", "ClaimNo");
excelApp.SetCellValue(1, "BH", "AccidentDate");
excelApp.SetCellValue(1, "BI", "ClmSettDate");
excelApp.SetCellValue(1, "BJ", "PayStatusCode");
excelApp.SetCellValue(1, "BK", "ClaimMoney");
excelApp.SetCellValue(1, "BL", "BackClaimMoney");
excelApp.SetCellValue(1, "BM", "BackDate");
excelApp.SetCellValue(1, "BN", "Currency");
excelApp.SetCellValue(1, "BO", "ReComputationsDate");
excelApp.SetCellValue(1, "BP", "AccountGetDate");
excelApp.SetColumnTextType("Sheet1", 1);
excelApp.SetColumnTextType("Sheet1", 2);
excelApp.SetColumnTextType("Sheet1", 3);
excelApp.SetColumnTextType("Sheet1", 4);
excelApp.SetColumnTextType("Sheet1", 5);
excelApp.SetColumnTextType("Sheet1", 6);
excelApp.SetColumnTextType("Sheet1", 7);
excelApp.SetColumnTextType("Sheet1", 8);
excelApp.SetColumnTextType("Sheet1", 9);
excelApp.SetColumnTextType("Sheet1", 17);
excelApp.SetColumnTextType("Sheet1", 23);
excelApp.SetColumnTextType("Sheet1", 24);
excelApp.SetColumnTextType("Sheet1", 52);
excelApp.SetColumnTextType("Sheet1", 53);
excelApp.SetColumnTextType("Sheet1", 37);
excelApp.SetColumnTextType("Sheet1", 59);
excelApp.SetColumnTextType("Sheet1", 62);
excelApp.SetColumnDateType("Sheet1", 18);
excelApp.SetColumnDateType("Sheet1", 19);
excelApp.SetColumnDateType("Sheet1", 21);
excelApp.SetColumnDateType("Sheet1", 60);
excelApp.SetColumnDateType("Sheet1", 65);
excelApp.SetColumnDateType("Sheet1", 67);
excelApp.SetColumnDateType("Sheet1", 68);
excelApp.SetColumnDateType("Sheet1", 61);
excelApp.SetColumnDecimalsType("Sheet1", 63);
excelApp.SetColumnDecimalsType("Sheet1", 64);
excelApp.Save();
}
