Your Privacy Matters: We use our own and third-party cookies to improve your experience on our website. By continuing to use the website we understand that you accept their use. Cookie Policy
155
Used Range Equivalent in Infragistics Excel
posted

Hi,

I'm using InfragisticsWPF.Documents.Excel v15.1 to import the data from excel and create a dataTable by looping through the cells where I do some formatting action. Is there a method or property which is equivalent to UsedRange in Microsoft.Interop.Excel where it would give total Columns count.

  • 26465
    Offline posted

    Hello Manojkumar, 

    Thank you for contacting Infragistics. If you are simply looking to retrieve and evaluate all cells that only contain values and format them then you may do so by iterating all the rows and then all the cells in each row. The cells without values will be skipped so you will no that the loop will entered when rows or cells have a value in them and you may build a range from that. 

    You may submit a new product idea to have this built in. You can suggest new product ideas for future versions (or vote for existing ones) at <https://www.infragistics.com/community/ideas>.
    Submitting your idea will allow you to communicate directly with our product management team, track the progress of your idea at any time, see how many votes it got, read comments from other developers in the community, and see if someone from the product team has additional questions for you.
    Remember when submitting your idea to explain the context in which a feature would be used and why it is needed as well as anything that would prevent you from accomplishing this today. You can even add screenshots to build a stronger case. Remember that for your suggestion to be successful, you need other members of the community to vote for it. You can also link back to this thread for additional details.