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
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
message.txt8.64KB
