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. (Last updated on : November 16, 2018).
Unfortunately, activation email could not send to your email. Please try again.
Syncfusion Feedback

How to get cell value with row and column?

Thread ID:

Created:

Updated:

Platform:

Replies:

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

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 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.





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.

Warning Icon 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.Close Icon

;