We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy.
Unfortunately, activation email could not send to your email. Please try again.

How to get cell value with row and column?

Thread ID:

Created:

Updated:

Platform:

Replies:

123255 Mar 1,2016 01:46 PM Mar 2,2016 04:50 AM WPF 1
loading
Tags: SfSpreadsheet
Jeffrey Kesselman
Asked On March 1, 2016 01:46 PM

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

Elakkiya Muthukumarasamy [Syncfusion]
Replied On March 2, 2016 04:50 AM

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.





CONFIRMATION

This post will be permanently deleted. Are you sure you want to continue?

Sorry, An error occured while processing your request. Please try again later.

You are using an outdated version of Internet Explorer that may not display all features of this and other websites. Upgrade to Internet Explorer 8 or newer for a better experience.

;