GrapeCity.Documents.Excel.FormulaJsonError.WorksheetName

WorksheetName Property

WorksheetName

Gets the name of the worksheet where the formula error occurred.

This value identifies the worksheet associated with the invalid or unprocessed formula in the imported JSON content.

Declaration

public string WorksheetName { get; }

Public ReadOnly Property WorksheetName As String

Examples

Workbook sourceWorkbook = new Workbook();
sourceWorkbook.Worksheets[0].Range["C2"].Formula = "=SUM(A1:A2)";
string json = sourceWorkbook.ToJson().Replace("SUM(A1:A2)", "SUM(A1:)");
Workbook importedWorkbook = new Workbook();
IList<JsonError> errors = importedWorkbook.FromJson(json);
FormulaJsonError error = (FormulaJsonError)errors[0];
string worksheetName = error.WorksheetName;