Esempio n. 1
0
        public void EditCellValue(string fileLocation, string sheetName, string newCellValue, int row, int column)
        {
            XLWorkbook   Workbook       = new XLWorkbook(fileLocation);
            IXLWorksheet Worksheet      = Workbook.Worksheet(sheetName);
            IXLCell      CellForNewData = Worksheet.Cell(row, column);

            CellForNewData.Clear();
            CellForNewData.SetValue(newCellValue);
            Workbook.SaveAs(fileLocation);
        }