Hi ,
We are using
var xlEngine = new ExcelEngine();
IApplication xlApp = xlEngine.Excel;
IWorkbook xlWBk = xlApp.Workbooks.Open(path);
control.SPlusSpreadsheetControl.ExcelProperties.WorkBook.ActiveSheet.Clear();
control.SPlusSpreadsheetControl.InvalidateVisual();
control.SPlusSpreadsheetControl.ImportFromExcel(xlWBk);
To fill the data in spreadsheet from excel .
After filling the view got changed to new entry but in background the control holds the old data . Where SPlusSpreadsheetControl is derived from SpreadsheetControl.
Please clarify .