ClosedXML removes the current formatting in Excel Sheets

See more:

C#

C#4.0

Hi All,

I am using ClosedXML for my application.I used the following codes to write some values into the existing worksheet.

XLWorkbook tasklog = new XLWorkbook("TaskLogTemplate.xlsx");

IXLWorksheet Ws = tasklog.Worksheet(sheetName);
                Ws.Cell(1,3).Value = "ProjectName";
                Ws.Cell(2,3).Value = "LogTitle";
                Ws.Cell(3,3).Value = "ModelHead";
                Ws.Cell(2,5).Value = "PHead";
                tasklog.Save();

But it removes the formatting of adjacent cells such as border style, color etc.
Can anyone help me. I tried search in ClosedXML forums but no solutions found....
Thanks in Advance.