Hi Suresh,
There is no built-in support for this. If you want to export the grid dynamically when the current cell is changed, you can derive the GridExcelConverterControl class and implement the CurrentCellExport method. Please refer to the attached sample for implementation and let me know if this helps.
[c#]
public void CurrentCellExport(GridModel model,string FileName,GridCurrentCell CurrentCell, bool IsCreateNew )
{
ExcelEngine engine = CreateEngine();
IWorkbook book = (!IsCreateNew)? engine.Excel.Workbooks.Open(FileName):engine.Excel.Workbooks.Create();
IWorksheet sheet = book.Worksheets[ 0 ];
GridRangeInfoList list = model.SelectedRanges;
ExportCurrentCell(CurrentCell,model,sheet);
book.SaveAs(FileName);
book.Close();
}
public void ExportCurrentCell(GridCurrentCell CurrentCell, GridModel model, IWorksheet sheet)
{
this.CopyStyle( model[CurrentCell.RowIndex, CurrentCell.ColIndex],sheet[CurrentCell.RowIndex + 1, CurrentCell.ColIndex]);
sheet[CurrentCell.RowIndex + 1 , CurrentCell.ColIndex].Text = model[CurrentCell.RowIndex, CurrentCell.ColIndex].FormattedText;
}
Sample :
DynamicGDBGExport.zipBest regards,
Haneef