How to get cell value with row and column?

[Jeffrey Kesselman]

I found instructions for using .Item(...) with Spreadsheet, but sfSpreadsheet doesn't seem to have this method.

[Elakkiya Muthukumarasamy]

Hi Jeffrey,

Thank you for using Syncfusion product.

You can get the cell value of particular cell from the XlsIO’s range as given below. You can access the ActiveSheet or any other worksheet (spreadsheet.Workbook.Worksheets[0]) of SfSpreadsheet in the WorkbookLoaded event.

Code Example:

var val1 = this.spreadsheet.ActiveSheet.Range["A1"].Value;
                         (or)
var val2 = this.spreadsheet.ActiveSheet.Range[2,1].Value;

 
You can refer the following UG documentation link for more information about SfSpreadsheet:

http://help.syncfusion.com/wpf/sfspreadsheet/working-with-sfspreadsheet   

http://help.syncfusion.com/file-formats/xlsio/worksheet-cells-manipulation#accessing-a-cell-or-a-range 

Regards,
Elakkiya M.