openxml sdk spread sheet
Hi someone use this library?
i've some diffucult when i try to add a cellformula.
i've created a class to write spreadsheet as attached and this code to add formula
newRow = new Row(); cell = new Cell() { CellReference = "M548", //CellFormula = new CellFormula() {Text = "=SUM(M2:M" + ix--.ToString() + ") " },
CellFormula = new CellFormula() { Text = "=Sum(M2:M547)", CalculateCell = true }, }; newRow.AppendChild(cell); export2Excel.AddRow(newRow); when i open the file i received the error illegible content thenk you
newRow = new Row(); cell = new Cell() { CellReference = "M548", //CellFormula = new CellFormula() {Text = "=SUM(M2:M" + ix--.ToString() + ") " },
CellFormula = new CellFormula() { Text = "=Sum(M2:M547)", CalculateCell = true }, }; newRow.AppendChild(cell); export2Excel.AddRow(newRow); when i open the file i received the error illegible content thenk you
0 Replies