OfficeWriter Documentation
.
ExcelWriter v8 Docs
Space Shortcuts
Page tree
ConfigureSpace tools

Versions Compared

Old Version 1

changes.mady.by.user Wiki Administrator

Saved on

compared with

New Version 2

changes.mady.by.user Wiki Administrator

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Migrated to Confluence 4.0
Description

...

Wiki Markup
{description}
{excerpt}The [Palette|Palette] class represents Excel's color palette.

...

Signature
C#C#
 {excerpt}
{signature:C#}
 public sealed class Palette
Signature
{signature}{signature:vb.net
vb.net
}
Public NotInheritable Class Palette
Remarks

Each Excel document has a single color palette that manages the colors for formatting and some drawing layer colors. A color palette contains 56 colors that may be referenced. Each of these 56 colors may be customized, but changing a color in the palette will affect all formatting that uses the referenced color. A workbook's color palette is accessible through Workbook.Palette.

{signature}
{remarks}Each Excel document has a single color palette that manages the colors for formatting and some drawing layer colors. A color palette contains 56 colors that may be referenced. Each of these 56 colors may be customized, but changing a color in the palette will affect all formatting that uses the referenced color. A workbook's color palette is accessible through [Workbook.Palette|Workbook.Palette].

{remarks}
{example}{code:csharp|title=C#}

          ExcelApplication xla = new ExcelApplication();
          Workbook wb = xla.Create();
          Palette pal = wb.Palette;
        
{code}
{code:vbnet|title=vb.net
}

          Dim xla As New ExcelApplication()
          Dim wb As Workbook = xla.Create()
          Dim pal As Palette = wb.Palette
Example
Code Block
csharpcsharp
titleC#
Code Block
vbnetvbnettitle
Fields

...

Name

...

Description

...

MinColorIndex

...

{code}

{example}
{fields}
||Name||Description||
|[MinColorIndex|Palette.MinColorIndex]|{excerpt-include:Palette.MinColorIndex

...

MinRGBValue

|nopanel=true}|
|[MinRGBValue|Palette.MinRGBValue]|{excerpt-include

...

:Palette.MinRGBValue

...

MaxColorIndex

|nopanel=true}|
|[MaxColorIndex|Palette.MaxColorIndex]|{excerpt-include

...

:Palette.MaxColorIndex

...

MaxRGBValue

|nopanel=true}|
|[MaxRGBValue|Palette.MaxRGBValue]|{excerpt-include

...

:Palette.MaxRGBValue

...

Methods

...

Name

...

Description

|nopanel=true}|
{methods}
||Name||Description||
|[GetClosestColor(Int32, Int32, Int32)

...

|Palette.GetClosestColor(Int32, Int32, Int32)

...

]|{excerpt-include:Palette.GetClosestColor(Int32, Int32, Int32)

...

|nopanel

...

=true}|
|[GetClosestColor(System.Drawing.Color)

...

|Palette.GetClosestColor(System.Drawing.Color)

...

]|{excerpt-include:Palette.GetClosestColor(System.Drawing.Color)

...

|nopanel

...

=true}|
|[GetColor(Int32, Int32, Int32)

...

|Palette.GetColor(Int32, Int32, Int32)

...

]|{excerpt-include:Palette.GetColor(Int32, Int32, Int32)

...

|nopanel

...

=true}|
|[GetColor(System.Drawing.Color)

...

|Palette.GetColor(System.Drawing.Color)

...

]|{excerpt-include:Palette.GetColor(System.Drawing.Color)

...

|nopanel

...

=true}|
|[GetColorAt(Int32)

...

|Palette.GetColorAt(Int32)

...

]|{excerpt-include:Palette.GetColorAt(Int32)

...

|nopanel

...

=true}|
|[SetColor(Color, Int32, Int32, Int32)

...

|Palette.SetColor(Color, Int32, Int32, Int32)

...

]|{excerpt-include:Palette.SetColor(Color, Int32, Int32, Int32)

...

|nopanel

...

=true}|
|[SetColorAt(Int32, Int32, Int32, Int32)

...

|Palette.SetColorAt(Int32, Int32, Int32, Int32)

...

]|{excerpt-include:Palette.SetColorAt(Int32, Int32, Int32, Int32)

...

|nopanel

...

Classes

...

Name

...

Description

...

SystemColor

...

=true}|
{classes}
||Name||Description||
|[SystemColor|Palette.SystemColor]|{excerpt-include:Palette.SystemColor

...

|nopanel=true}|