WorkbookColorPalette.CopyFrom(WorkbookColorPalette) Method

Copies colors from the specified palette to the current palette.

Assembly : DevExpress.Spreadsheet.v25.2.Core.dll

NuGet Package : DevExpress.Spreadsheet.Core

Declaration

C#
VB.NET

csharp

void CopyFrom(
    WorkbookColorPalette other
)

Sub CopyFrom(
    other As WorkbookColorPalette
)

Parameters

Name	Type	Description
other	WorkbookColorPalette

A workbook palette that contains colors to copy.

Exceptions

Type	Description
ArgumentException

Occurs if other parameter is null ( Nothing in Visual Basic).

Remarks

The following code example demonstrates how to copy a color palette from one workbook to another:

C#
VB.NET

csharp

using DevExpress.Spreadsheet;
// ...
using (Workbook sourceWorkbook = new Workbook())
using (Workbook targetWorkbook = new Workbook())
{
    targetWorkbook.LoadDocument("Book1.xlsx");
    sourceWorkbook.LoadDocument("Book2.xlsx");
    targetWorkbook.ColorPalette.CopyFrom(sourceWorkbook.ColorPalette);
}

Imports DevExpress.Spreadsheet
' ...
Using sourceWorkbook As New Workbook()
Using targetWorkbook As New Workbook()
    targetWorkbook.LoadDocument("Book1.xlsx")
    sourceWorkbook.LoadDocument("Book2.xlsx")
    targetWorkbook.ColorPalette.CopyFrom(sourceWorkbook.ColorPalette)
End Using
End Using