Inserting into a specific cell in Open XML

[amnesium]

Hi i am inserting into a specific cell of an excel sheet using open XML but as soon as i use this functionality to insert into a cell that has borders or any other formatting/styling the output excel sheet says it has unreadable content & has to be repaired to open the data. Can anyone help me out? I have shown the function i have used below. Thanks in advance\[code\]public static void InsertInSheetSpecificCell(SpreadsheetDocument myWorkbook, string sheetName, uint rowIndex, string columnName, string text) { WorkbookPart workbook = myWorkbook.WorkbookPart; IEnumerable<Sheet> sheets = myWorkbook.WorkbookPart.Workbook.GetFirstChild<Sheets>().Elements<Sheet>().Where(s => s.Name == sheetName); string relId = sheets.First().Id.Value; WorksheetPart worksheet = (WorksheetPart)workbook.GetPartById(relId); var Worksheet = worksheet.Worksheet; var sheetData = http://stackoverflow.com/questions/13797636/Worksheet.GetFirstChild<SheetData>(); var row = new Row { RowIndex = rowIndex }; sheetData.Append(row); var Cell = new Cell { CellValue = new CellValue(text), DataType = new EnumValue<CellValues>(CellValues.String), CellReference = columnName + rowIndex.ToString() }; row.InsertAfter(Cell, null); }\[/code\]