How to get cell value with row and column?

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

1 Reply

EM Elakkiya Muthukumarasamy Syncfusion Team March 2, 2016 09:50 AM UTC

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.





Loader.
Up arrow icon