ClosedXML worksheet styles and create excel - Asp.Net,C#,Sql server,jquery,Angularjs,Mvc,interview tips and coding tips

using (var workbook = new XLWorkbook())

{

var worksheet2 = workbook.Worksheets.Add("Sheet -2");

worksheet2.Row(1).Height = 50;

worksheet2.Range("A2:C2").Merge();

worksheet2.Column(2).Width = 60;

worksheet2.Range("A2").Value = "Payout Report";

worksheet2.Range("A2:C2").Style.Font.FontSize = 14;

worksheet2.Range("A2:C2").Style.Font.Bold = true;

worksheet2.Range("B3").Value = "Number of orders";

worksheet2.Range("C3").Value = ListItems.Count();

worksheet2.Range("B4").Value = "Item Total";

worksheet2.Range("C4").Value = ListItems.Sum(l => l.ItemTotal);

worksheet2.Range("B5").Value = "Packing Charges";

worksheet2.Range("C5").Value = ListItems.Sum(l => l.PackingCharge);

worksheet2.Range("B6").Value = "Discounts";

worksheet2.Range("C6").Value = ListItems.Sum(l => l.MerchantDiscount);

worksheet2.Range("B7").Value = "Net Bill Value";

worksheet2.Range("C7").Value = ListItems.Sum(l => l.NetBVWithoutTax);

worksheet2.Range("B8").Value = "GST on order (including Cess)";

worksheet2.Range("C8").Value = ListItems.Sum(l => l.GST);

worksheet2.Range("A9").Value = "A";

worksheet2.Range("B9").Value = "Total Customer Payable";

worksheet2.Range("C9").Value = ListItems.Sum(l => l.CustomerPayable);

worksheet2.Range("A9:C9").Style.Font.FontSize = 14;

worksheet2.Range("A9:C9").Style.Font.Bold = true;

worksheet2.Range("A10:C10").Merge();

pathh = AppDomain.CurrentDomain.BaseDirectory + "\\Files\\" + "Sheet" + DateTime.Now.ToShortDateString() + ".xlsx";

workbook.SaveAs(pathh);

}