Hi Ray,
You can access each SpreadsheetGrid in SfSpreadsheet by invoking the WorkbookLoaded Event or by passing the worksheet name in GridCollection Property and call the InvalidateCells method to refresh the view.
Please find the code example for your reference,
|
spreadsheet.WorkbookLoaded += spreadsheet_WorkbookLoaded;
void spreadsheet_WorkbookLoaded(object sender, WorkbookLoadedEventArgs args)
{
foreach (var grid in args.GridCollection)
{
grid. InvalidateCells();
}
}
OR
var sheet1 = spreadsheet.Workbook.Worksheets[0];
var sheet2= spreadsheet.Workbook.Worksheets[1];
spreadsheet.GridCollection[sheet1.Name].InvalidateCells();
spreadsheet.GridCollection[sheet2.Name].InvalidateCells();
|
You can also refer the below UG links to access each grid and refreshing the view,
Regards
Kanimozhi B
