We're sorry Aspose doesn't work properply without JavaScript enabled.

Free Support Forum - aspose.com

Colors available in the current palette

Aspose.Cells Product Family
#1

Hi

In reference to the color table from `http://www.aspose.com/Products/Aspose.Cells/Api/index.html?url=http://www.aspose.com/Products/Aspose.Cells/Api/Aspose.Cells.Workbook.ChangePalette.html`

I am trying to loop through the colors available in the current palette to display them in cells with this code and it is not working:

Public Shared Sub TestColors(ByVal mWorkBook As Aspose.Cells.Workbook, ByVal pSheet As Worksheet, ByRef pRow As Integer)<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" />

For intI As Integer = 0 To 55

With pSheet.Cells(pRow, 0)

.PutValue("Test")

.Style.ForegroundColor = mWorkBook.Colors(intI)

End With

pRow += 1

Next

End Sub

Can I display a sample of all the colors of the current palette?

#2

Hi,

Please add a line to your code to make it work i.e.,

Public Shared Sub TestColors(ByVal mWorkBook As Aspose.Cells.Workbook, ByVal pSheet As Worksheet, ByRef pRow As Integer)<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" />

For intI As Integer = 0 To 55

With pSheet.Cells(pRow, 0)

.PutValue("Test")

.Style.ForegroundColor = mWorkBook.Colors(intI)

.Style.Pattern = BackgroundType.Solid;

End With

pRow += 1

Next

End Sub

For further reference, please check the following thread:

<A href="</A></P> <P> </P> <P>Thank you. </P>

#3

Oups. That's really great thanks.

Just to finish on that, do you know a method to get the color name (ie: Alice Blue) from the color?

#4

Hi,

Well, AliceBlue color is not present on the standard color palette, so you have to add it on the palette changing the palette.

e.g..,

workbook.ChangePalette(System.Drawing.Color.AliceBlue,55)

Thank you.