如何在Gembox.spreadsheet中应用Excel公式

Question

我想将此公式应用于所有C3单元，不包括标题'=（isblank（b3），“”，10）'在我的电子表格中。

我该如何实现？

Answer 1

尝试以下操作：

var workbook = new ExcelFile();
var worksheet = workbook.Worksheets.Add("Sheet1");
var cell = worksheet.Cells["C3"];
cell.Formula = "'=IF(ISBLANK(B3), \"\", 10)";
workbook.Save("output.xlsx");

Answer 2

这就是我终于来的：

     worksheet.Cells.GetSubrange("C2", "C5000").Formula = $@"=IF(ISBLANK(B2:B5000 ), """", {10})";
     
        worksheet.DataValidations.Add(new DataValidation(worksheet.Columns[5].Cells.GetSubrange("C2", "C5000"))
        {
            Type = DataValidationType.WholeNumber,

            Operator = DataValidationOperator.Equal,              
            InputMessageTitle = "Edits Not Allowed",
            InputMessage = "Value in the cell cannot be changed",
            ErrorTitle = "Edits Not Allowed",
            ErrorMessage = "Value in the cell cannot be changed"
        }); ;