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 know range color

Thread ID:





100030 Jun 28,2011 08:16 AM UTC Jun 30,2011 02:17 PM UTC ASP.NET Web Forms (Classic) 1
Tags: XlsIO
Asked On June 28, 2011 08:16 AM UTC

Hi there,

if i use a format string to apply color onto cell, and somehow in run time i want to know its color (i want to convert the color to web color e.g #ff0000).

how can i get the color value from range?


IRange r = worksheet.Range[1,1];
r.Number = 98765.432;
r.NumberFormat = "[Color 23] #,##0.00"; // Color 23 will be assign randomly

is there a way after this code. i can get the color from the range?

i tried


it doesn`t return the right color value.

Jawahar Jeevanandan J [Syncfusion]
Replied On June 30, 2011 02:17 PM UTC

Hi shrimpy,

Thank you very much for using the syncfusion products.

Currently we are not providing support for accessing range colors which have been set using number format. We will get back to you once the feature has been implemented in any of our upcoming releases.

Please let us know if you have any clarifications.



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.

Please sign in to access our forum

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