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

What is the way to locate cells that contain formula/links/strings/Number using XLSIO?

Platform: WinForms |
Control: XlsIO |
Published Date: April 30, 2011 |
Last Revised Date: July 10, 2014

What is the way to locate cells that contain formula/links/strings/Number using XLSIO?

XlsIO has the following API''s to locate the cells that contain the formula, links,strings and Number.

  • HasFormula: Returns the cell that contains formula.
  • HasStyle: Returns the cell that contains Hyperlink.
  • HasString: Returns the cell that has the string value.
  • HasNumber: Returns the cell that has the numeric value.

C#

 

VB

 

Here is the sample for your reference:

Access_Cell_Range.zip

 

2X faster development

The ultimate WinForms UI toolkit to boost your development speed.
ADD COMMENT
You must log in to leave a comment

Please sign in to access our KB

This page will automatically be redirected to the sign-in page in 10 seconds.

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