Interface IPivotCellFormat

Represents Pivot Cell Format

Namespace: Syncfusion.XlsIO

Assembly: Syncfusion.XlsIO.Portable.dll

Syntax

public interface IPivotCellFormat

Properties

BackColor

Gets or sets the background color from predefined colors (ExcelKnownColors).

Declaration

ExcelKnownColors BackColor { get; set; }

Property Value

Type
ExcelKnownColors

Examples

    using(ExcelEngine excelEngine = new ExcelEngine())
    {
      IApplication application = excelEngine.Excel;
      IWorkbook workbook = application.Workbooks.Open("Sample.xlsx");
      IWorksheet worksheet = workbook.Worksheets[0];

      IPivotTable pivotTable = worksheet.PivotTables[0];      
      //Get the cell format for "A1" pivot range.
      IPivotCellFormat cellFormat = pivotTable.GetCellFormat("A1");
      cellFormat.BackColor = ExcelKnownColors.Red;

      workbook.SaveAs("PivotFormat.xlsx");
      workbook.Close();
      excelEngine.Dispose();

  }

BackColorRGB

Gets and sets the back ground RGB color.

Declaration

Color BackColorRGB { get; set; }

Property Value

Type
Color

Examples

    using(ExcelEngine excelEngine = new ExcelEngine())
    {
      IApplication application = excelEngine.Excel;
      IWorkbook workbook = application.Workbooks.Open("Sample.xlsx");
      IWorksheet worksheet = workbook.Worksheets[0];

      IPivotTable pivotTable = worksheet.PivotTables[0];
      //Get the cell format for "A1" pivot range.
      IPivotCellFormat cellFormat = pivotTable.GetCellFormat("A1");
      cellFormat.BackColorRGB = System.Drawing.Color.FromArgb(255, 255, 0, 0);

      workbook.SaveAs("PivotFormat.xlsx");
      workbook.Close();
      excelEngine.Dispose();

  }

Bold

Gets or sets a boolean value indicating whether the font is bold.

Declaration

bool Bold { get; set; }

Property Value

Type
System.Boolean

Examples

    using(ExcelEngine excelEngine = new ExcelEngine())
    {
      IApplication application = excelEngine.Excel;
      IWorkbook workbook = application.Workbooks.Open("Sample.xlsx");
      IWorksheet worksheet = workbook.Worksheets[0];

      IPivotTable pivotTable = worksheet.PivotTables[0];
      //Get the cell format for "A1" pivot range.
      IPivotCellFormat cellFormat = pivotTable.GetCellFormat("A1");
      cellFormat.Bold = true;

      workbook.SaveAs("PivotFormat.xlsx");
      workbook.Close();
      excelEngine.Dispose();
  }

BottomBorderColor

Gets or sets the bottom border color from predefined colors (ExcelKnownColors).

Declaration

ExcelKnownColors BottomBorderColor { get; set; }

Property Value

Type
ExcelKnownColors

Examples

    using(ExcelEngine excelEngine = new ExcelEngine())
    {
      IApplication application = excelEngine.Excel;
      IWorkbook workbook = application.Workbooks.Open("Sample.xlsx");
      IWorksheet worksheet = workbook.Worksheets[0];

      IPivotTable pivotTable = worksheet.PivotTables[0];
      //Get the cell format for "A1" pivot range.
      IPivotCellFormat cellFormat = pivotTable.GetCellFormat("A1");
      cellFormat.BottomBorderStyle=ExcelLineStyle.Thick;
      cellFormat.BottomBorderColor=ExcelKnownColors.Green;

      workbook.SaveAs("PivotFormat.xlsx");
      workbook.Close();
      excelEngine.Dispose();

  }

BottomBorderColorRGB

Gets or sets RGB color to bottom border.

Declaration

Color BottomBorderColorRGB { get; set; }

Property Value

Type
Color

Examples

    using(ExcelEngine excelEngine = new ExcelEngine())
    {
      IApplication application = excelEngine.Excel;
      IWorkbook workbook = application.Workbooks.Open("Sample.xlsx");
      IWorksheet worksheet = workbook.Worksheets[0];

      IPivotTable pivotTable = worksheet.PivotTables[0];
      //Get the cell format for "A1" pivot range.
      IPivotCellFormat cellFormat = pivotTable.GetCellFormat("A1");
      cellFormat.BottomBorderStyle=ExcelLineStyle.Thick;
      cellFormat.BottomBorderColorRGB=System.Drawing.Color.FromArgb(255, 0, 255, 0);

      workbook.SaveAs("PivotFormat.xlsx");
      workbook.Close();
      excelEngine.Dispose();

  }

BottomBorderStyle

Gets or sets the bottom border line style.

Declaration

ExcelLineStyle BottomBorderStyle { get; set; }

Property Value

Type
ExcelLineStyle

Examples

    using(ExcelEngine excelEngine = new ExcelEngine())
    {
      IApplication application = excelEngine.Excel;
      IWorkbook workbook = application.Workbooks.Open("Sample.xlsx");
      IWorksheet worksheet = workbook.Worksheets[0];

      IPivotTable pivotTable = worksheet.PivotTables[0];
      //Get the cell format for "A1" pivot range.
      IPivotCellFormat cellFormat = pivotTable.GetCellFormat("A1");
      cellFormat.BottomBorderStyle=ExcelLineStyle.Thick;

      workbook.SaveAs("PivotFormat.xlsx");
      workbook.Close();
      excelEngine.Dispose();

  }

DiagonalBorderColor

Gets or sets the diagonal border color from predefined colors (ExcelKnownColors).

Declaration

ExcelKnownColors DiagonalBorderColor { get; set; }

Property Value

Type
ExcelKnownColors

Examples

    using(ExcelEngine excelEngine = new ExcelEngine())
    {
      IApplication application = excelEngine.Excel;
      IWorkbook workbook = application.Workbooks.Open("Sample.xlsx");
      IWorksheet worksheet = workbook.Worksheets[0];

      IPivotTable pivotTable = worksheet.PivotTables[0];
      //Get the cell format for "A1" pivot range.
      IPivotCellFormat cellFormat = pivotTable.GetCellFormat("A1");
      cellFormat.DiagonalBorderStyle=ExcelLineStyle.Thick;
      cellFormat.DiagonalBorderColor=ExcelKnownColors.Green;

      workbook.SaveAs("PivotFormat.xlsx");
      workbook.Close();
      excelEngine.Dispose();

  }

DiagonalBorderColorRGB

Gets or sets the diagonal border color (Color).

Declaration

Color DiagonalBorderColorRGB { get; set; }

Property Value

Type
Color

Examples

    using(ExcelEngine excelEngine = new ExcelEngine())
    {
      IApplication application = excelEngine.Excel;
      IWorkbook workbook = application.Workbooks.Open("Sample.xlsx");
      IWorksheet worksheet = workbook.Worksheets[0];

      IPivotTable pivotTable = worksheet.PivotTables[0];
      //Get the cell format for "A1" pivot range.
      IPivotCellFormat cellFormat = pivotTable.GetCellFormat("A1");
      cellFormat.DiagonalBorderStyle = ExcelLineStyle.Thick;
      cellFormat.DiagonalBorderColorRGB=System.Drawing.Color.FromArgb(255, 0, 255, 0);

      workbook.SaveAs("PivotFormat.xlsx");
      workbook.Close();
      excelEngine.Dispose();

  }

DiagonalBorderStyle

Gets / sets line style of the diagonal border.

Declaration

ExcelLineStyle DiagonalBorderStyle { get; set; }

Property Value

Type
ExcelLineStyle

Examples

    using(ExcelEngine excelEngine = new ExcelEngine())
    {
      IApplication application = excelEngine.Excel;
      IWorkbook workbook = application.Workbooks.Open("Sample.xlsx");
      IWorksheet worksheet = workbook.Worksheets[0];

      IPivotTable pivotTable = worksheet.PivotTables[0];
      //Get the cell format for "A1" pivot range.
      IPivotCellFormat cellFormat = pivotTable.GetCellFormat("A1");
      cellFormat.DiagonalBorderStyle=ExcelLineStyle.Thick;

      workbook.SaveAs("PivotFormat.xlsx");
      workbook.Close();
      excelEngine.Dispose();

  }

FontColor

Gets or sets the Font color from predefined colors (ExcelKnownColors).

Declaration

ExcelKnownColors FontColor { get; set; }

Property Value

Type
ExcelKnownColors

Examples

    using(ExcelEngine excelEngine = new ExcelEngine())
    {
      IApplication application = excelEngine.Excel;
      IWorkbook workbook = application.Workbooks.Open("Sample.xlsx");
      IWorksheet worksheet = workbook.Worksheets[0];

      IPivotTable pivotTable = worksheet.PivotTables[0];
      //Get the cell format for "A1" pivot range.
      IPivotCellFormat cellFormat = pivotTable.GetCellFormat("A1");
      cellFormat.FontColor=ExcelKnownColors.Red;

      workbook.SaveAs("PivotFormat.xlsx");
      workbook.Close();
      excelEngine.Dispose();

  }

FontColorRGB

Gets or sets RGB color to font.

Declaration

Color FontColorRGB { get; set; }

Property Value

Type
Color

Examples

    using(ExcelEngine excelEngine = new ExcelEngine())
    {
      IApplication application = excelEngine.Excel;
      IWorkbook workbook = application.Workbooks.Open("Sample.xlsx");
      IWorksheet worksheet = workbook.Worksheets[0];

      IPivotTable pivotTable = worksheet.PivotTables[0];
      //Get the cell format for "A1" pivot range.
      IPivotCellFormat cellFormat = pivotTable.GetCellFormat("A1");
      cellFormat.FontColorRGB=System.Drawing.Color.FromArgb(255, 0, 0, 255);

      workbook.SaveAs("PivotFormat.xlsx");
      workbook.Close();
      excelEngine.Dispose();

  }

FontName

Gets or sets RGB color to font.

Declaration

string FontName { get; set; }

Property Value

Type
System.String

Examples

    using(ExcelEngine excelEngine = new ExcelEngine())
    {
      IApplication application = excelEngine.Excel;
      IWorkbook workbook = application.Workbooks.Open("Sample.xlsx");
      IWorksheet worksheet = workbook.Worksheets[0];

      IPivotTable pivotTable = worksheet.PivotTables[0];
      //Get the cell format for "A1" pivot range.
      IPivotCellFormat cellFormat = pivotTable.GetCellFormat("A1");
      cellFormat.FontName = "Arial";

      workbook.SaveAs("PivotFormat.xlsx");
      workbook.Close();
      excelEngine.Dispose();

  }

FontSize

Gets or sets RGB color to font.

Declaration

double FontSize { get; set; }

Property Value

Type
System.Double

Examples

    using(ExcelEngine excelEngine = new ExcelEngine())
    {
      IApplication application = excelEngine.Excel;
      IWorkbook workbook = application.Workbooks.Open("Sample.xlsx");
      IWorksheet worksheet = workbook.Worksheets[0];

      IPivotTable pivotTable = worksheet.PivotTables[0];
      //Get the cell format for "A1" pivot range.
      IPivotCellFormat cellFormat = pivotTable.GetCellFormat("A1");
      cellFormat.FontSize = 14;

      workbook.SaveAs("PivotFormat.xlsx");
      workbook.Close();
      excelEngine.Dispose();

  }

FormulaHidden

Indicates whether formula is hidden.

Declaration

bool FormulaHidden { get; set; }

Property Value

Type
System.Boolean

Examples

    using(ExcelEngine excelEngine = new ExcelEngine())
    {
      IApplication application = excelEngine.Excel;
      IWorkbook workbook = application.Workbooks.Open("Sample.xlsx");
      IWorksheet worksheet = workbook.Worksheets[0];

      IPivotTable pivotTable = worksheet.PivotTables[0];
      //Get the cell format for "A1" pivot range.
      IPivotCellFormat cellFormat = pivotTable.GetCellFormat("A1");

      //Set FormulaHidden
      cellFormat.FormulaHidden = true;

      //Set locked
      cellFormat.Locked = true;

      //Enable sheet protection
      worksheet.Protect("", ExcelSheetProtection.All);

      workbook.SaveAs("PivotFormat.xlsx");
      workbook.Close();
      excelEngine.Dispose();

  }

HorizontalAlignment

Horizontal alignment.

Declaration

ExcelHAlign HorizontalAlignment { get; set; }

Property Value

Type
ExcelHAlign

Examples

    using(ExcelEngine excelEngine = new ExcelEngine())
    {
      IApplication application = excelEngine.Excel;
      IWorkbook workbook = application.Workbooks.Open("Sample.xlsx");
      IWorksheet worksheet = workbook.Worksheets[0];

      IPivotTable pivotTable = worksheet.PivotTables[0];
      //Get the cell format for "A1" pivot range.
      IPivotCellFormat cellFormat = pivotTable.GetCellFormat("A1");
      //Set alignment
      cellFormat.HorizontalAlignment = ExcelHAlign.HAlignRight;

      workbook.SaveAs("PivotFormat.xlsx");
      workbook.Close();
      excelEngine.Dispose();

  }

HorizontalBorderColor

Gets or sets the Horizontal Border color from predefined colors (ExcelKnownColors).

Declaration

ExcelKnownColors HorizontalBorderColor { get; set; }

Property Value

Type
ExcelKnownColors

Examples

    using(ExcelEngine excelEngine = new ExcelEngine())
    {
      IApplication application = excelEngine.Excel;
      IWorkbook workbook = application.Workbooks.Open("Sample.xlsx");
      IWorksheet worksheet = workbook.Worksheets[0];

      IPivotTable pivotTable = worksheet.PivotTables[0];
      //Get the cell format for "A1" pivot range.
      IPivotCellFormat cellFormat = pivotTable.GetCellFormat("A1");
      cellFormat.HorizontalBorderStyle=ExcelLineStyle.Thick;
      cellFormat.HorizontalBorderColor=ExcelKnownColors.Green;

      workbook.SaveAs("PivotFormat.xlsx");
      workbook.Close();
      excelEngine.Dispose();

  }

HorizontalBorderColorRGB

Gets or sets RGB color to horizontal border.

Declaration

Color HorizontalBorderColorRGB { get; set; }

Property Value

Type
Color

Examples

    using(ExcelEngine excelEngine = new ExcelEngine())
    {
      IApplication application = excelEngine.Excel;
      IWorkbook workbook = application.Workbooks.Open("Sample.xlsx");
      IWorksheet worksheet = workbook.Worksheets[0];

      IPivotTable pivotTable = worksheet.PivotTables[0];
      //Get the cell format for "A1" pivot range.
      IPivotCellFormat cellFormat = pivotTable.GetCellFormat("A1");
      cellFormat.HorizontalBorderStyle=ExcelLineStyle.Thick;
      cellFormat.HorizontalBorderColorRGB=System.Drawing.Color.FromArgb(255, 0, 255, 0);

      workbook.SaveAs("PivotFormat.xlsx");
      workbook.Close();
      excelEngine.Dispose();

  }

HorizontalBorderStyle

Gets or sets the Horizontal border line style.

Declaration

ExcelLineStyle HorizontalBorderStyle { get; set; }

Property Value

Type
ExcelLineStyle

Examples

    using(ExcelEngine excelEngine = new ExcelEngine())
    {
      IApplication application = excelEngine.Excel;
      IWorkbook workbook = application.Workbooks.Open("Sample.xlsx");
      IWorksheet worksheet = workbook.Worksheets[0];

      IPivotTable pivotTable = worksheet.PivotTables[0];
      //Get the cell format for "A1" pivot range.
      IPivotCellFormat cellFormat = pivotTable.GetCellFormat("A1");
      cellFormat.HorizontalBorderStyle = ExcelLineStyle.Thick;

      workbook.SaveAs("PivotFormat.xlsx");
      workbook.Close();
      excelEngine.Dispose();

  }

IndentLevel

Indent level.

Declaration

int IndentLevel { get; set; }

Property Value

Type
System.Int32

Examples

    using(ExcelEngine excelEngine = new ExcelEngine())
    {
      IApplication application = excelEngine.Excel;
      IWorkbook workbook = application.Workbooks.Open("Sample.xlsx");
      IWorksheet worksheet = workbook.Worksheets[0];

      IPivotTable pivotTable = worksheet.PivotTables[0];
      //Get the cell format for "A1" pivot range.
      IPivotCellFormat cellFormat = pivotTable.GetCellFormat("A1");
      //Set indent level
      cellFormat.IndentLevel = 2;

      workbook.SaveAs("PivotFormat.xlsx");
      workbook.Close();
      excelEngine.Dispose();

  }

Italic

Gets or sets a boolean value indicating whether the font is italic.

Declaration

bool Italic { get; set; }

Property Value

Type
System.Boolean

Examples

    using(ExcelEngine excelEngine = new ExcelEngine())
    {
      IApplication application = excelEngine.Excel;
      IWorkbook workbook = application.Workbooks.Open("Sample.xlsx");
      IWorksheet worksheet = workbook.Worksheets[0];

      IPivotTable pivotTable = worksheet.PivotTables[0];
      //Get the cell format for "A1" pivot range.
      IPivotCellFormat cellFormat = pivotTable.GetCellFormat("A1");
      cellFormat.Italic = true;

      workbook.SaveAs("PivotFormat.xlsx");

      workbook.Close();
      excelEngine.Dispose();

  }

LeftBorderColor

Gets or sets the left border color from predefined colors (ExcelKnownColors).

Declaration

ExcelKnownColors LeftBorderColor { get; set; }

Property Value

Type
ExcelKnownColors

Examples

    using(ExcelEngine excelEngine = new ExcelEngine())
    {
      IApplication application = excelEngine.Excel;
      IWorkbook workbook = application.Workbooks.Open("Sample.xlsx");
      IWorksheet worksheet = workbook.Worksheets[0];

      IPivotTable pivotTable = worksheet.PivotTables[0];
      //Get the cell format for "A1" pivot range.
      IPivotCellFormat cellFormat = pivotTable.GetCellFormat("A1");
      cellFormat.LeftBorderStyle=ExcelLineStyle.Thick;
      cellFormat.LeftBorderColor=ExcelKnownColors.Green;

      workbook.SaveAs("PivotFormat.xlsx");
      workbook.Close();
      excelEngine.Dispose();

  }

LeftBorderColorRGB

Gets or sets RGB color to left border.

Declaration

Color LeftBorderColorRGB { get; set; }

Property Value

Type
Color

Examples

    using(ExcelEngine excelEngine = new ExcelEngine())
    {
      IApplication application = excelEngine.Excel;
      IWorkbook workbook = application.Workbooks.Open("Sample.xlsx");
      IWorksheet worksheet = workbook.Worksheets[0];

      IPivotTable pivotTable = worksheet.PivotTables[0];
      //Get the cell format for "A1" pivot range.
      IPivotCellFormat cellFormat = pivotTable.GetCellFormat("A1");
      cellFormat.LeftBorderStyle=ExcelLineStyle.Thick;
      cellFormat.LeftBorderColorRGB=System.Drawing.Color.FromArgb(255, 0, 255, 0);

      workbook.SaveAs("PivotFormat.xlsx");
      workbook.Close();
      excelEngine.Dispose();

  }

LeftBorderStyle

Gets or sets the left border line style.

Declaration

ExcelLineStyle LeftBorderStyle { get; set; }

Property Value

Type
ExcelLineStyle

Examples

    using(ExcelEngine excelEngine = new ExcelEngine())
    {
      IApplication application = excelEngine.Excel;
      IWorkbook workbook = application.Workbooks.Open("Sample.xlsx");
      IWorksheet worksheet = workbook.Worksheets[0];

      IPivotTable pivotTable = worksheet.PivotTables[0];
      //Get the cell format for "A1" pivot range.
      IPivotCellFormat cellFormat = pivotTable.GetCellFormat("A1");
      cellFormat.LeftBorderStyle=ExcelLineStyle.Thick;

      workbook.SaveAs("PivotFormat.xlsx");
      workbook.Close();
      excelEngine.Dispose();

  }

Locked

Indicates whether cell with this XF is locked.

Declaration

bool Locked { get; set; }

Property Value

Type
System.Boolean

Examples

    using(ExcelEngine excelEngine = new ExcelEngine())
    {
      IApplication application = excelEngine.Excel;
      IWorkbook workbook = application.Workbooks.Open("Sample.xlsx");
      IWorksheet worksheet = workbook.Worksheets[0];

      IPivotTable pivotTable = worksheet.PivotTables[0];
      //Get the cell format for "A1" pivot range.
      IPivotCellFormat cellFormat = pivotTable.GetCellFormat("A1");

      //Set FormulaHidden
      cellFormat.FormulaHidden = true;

      //Set locked
      cellFormat.Locked = true;

      //Enable sheet protection
      worksheet.Protect("", ExcelSheetProtection.All);

      workbook.SaveAs("PivotFormat.xlsx");
      workbook.Close();
      excelEngine.Dispose();

  }

NumberFormat

Gets or sets number format of the conditional format rule.

Declaration

string NumberFormat { get; set; }

Property Value

Type
System.String

Examples

    using(ExcelEngine excelEngine = new ExcelEngine())
    {
      IApplication application = excelEngine.Excel;
      IWorkbook workbook = application.Workbooks.Open("Sample.xlsx");
      IWorksheet worksheet = workbook.Worksheets[0];

      IPivotTable pivotTable = worksheet.PivotTables[0];
      //Get the cell format for "A1" pivot range.
      IPivotCellFormat cellFormat = pivotTable.GetCellFormat("A1");
      //Set number format
      cellFormat.NumberFormat = "#,##0.00_);[Red](#,##0.00)";

      workbook.SaveAs("PivotFormat.xlsx");
      workbook.Close();
      excelEngine.Dispose();

  }

NumberFormatIndex

Gets or sets number format index of the conditional format rule.

Declaration

ushort NumberFormatIndex { get; set; }

Property Value

Type
System.UInt16

Examples

    using(ExcelEngine excelEngine = new ExcelEngine())
    {
      IApplication application = excelEngine.Excel;
      IWorkbook workbook = application.Workbooks.Open("Sample.xlsx");
      IWorksheet worksheet = workbook.Worksheets[0];

      IPivotTable pivotTable = worksheet.PivotTables[0];
      //Get the cell format for "A1" pivot range.
      IPivotCellFormat cellFormat = pivotTable.GetCellFormat("A1");      
      //Set number format index
      cellFormat.NumberFormatIndex = 5;

      workbook.SaveAs("PivotFormat.xlsx");
      workbook.Close();
      excelEngine.Dispose();

  }

PatternColor

Gets or sets the pattern color from predefined colors (ExcelKnownColors).

Declaration

ExcelKnownColors PatternColor { get; set; }

Property Value

Type
ExcelKnownColors

Examples

    using(ExcelEngine excelEngine = new ExcelEngine())
    {
      IApplication application = excelEngine.Excel;
      IWorkbook workbook = application.Workbooks.Open("Sample.xlsx");
      IWorksheet worksheet = workbook.Worksheets[0];

      IPivotTable pivotTable = worksheet.PivotTables[0];
      //Get the cell format for "A1" pivot range.
      IPivotCellFormat cellFormat = pivotTable.GetCellFormat("A1");
      cellFormat.PatternStyle = ExcelPattern.DarkVertical;
      cellFormat.PatternColor = ExcelKnownColors.Green;

      workbook.SaveAs("PivotFormat.xlsx");
      workbook.Close();
      excelEngine.Dispose();

  }

PatternColorRGB

Gets or sets RGB color to pattern.

Declaration

Color PatternColorRGB { get; set; }

Property Value

Type
Color

Examples

    using(ExcelEngine excelEngine = new ExcelEngine())
    {
      IApplication application = excelEngine.Excel;
      IWorkbook workbook = application.Workbooks.Open("Sample.xlsx");
      IWorksheet worksheet = workbook.Worksheets[0];

      IPivotTable pivotTable = worksheet.PivotTables[0];
      //Get the cell format for "A1" pivot range.
      IPivotCellFormat cellFormat = pivotTable.GetCellFormat("A1");
      cellFormat.PatternStyle = ExcelPattern.DarkVertical;
      cellFormat.PatternColorRGB = System.Drawing.Color.FromArgb(255, 255, 0, 0);

      workbook.SaveAs("PivotFormat.xlsx");
      workbook.Close();
      excelEngine.Dispose();
  }

PatternStyle

Gets and sets the pattern style from pivot cell format.

Declaration

ExcelPattern PatternStyle { get; set; }

Property Value

Type
ExcelPattern

Examples

    using(ExcelEngine excelEngine = new ExcelEngine())
    {
      IApplication application = excelEngine.Excel;
      IWorkbook workbook = application.Workbooks.Open("Sample.xlsx");
      IWorksheet worksheet = workbook.Worksheets[0];

      IPivotTable pivotTable = worksheet.PivotTables[0];
      //Get the cell format for "A1" pivot range.
      IPivotCellFormat cellFormat = pivotTable.GetCellFormat("A1");
      cellFormat.PatternStyle=ExcelPattern.DarkVertical;

      workbook.SaveAs("PivotFormat.xlsx");
      workbook.Close();
      excelEngine.Dispose();

  }

ReadingOrder

Text direction, the reading order for far east versions.

Declaration

ExcelReadingOrderType ReadingOrder { get; set; }

Property Value

Type
ExcelReadingOrderType

Examples

    using(ExcelEngine excelEngine = new ExcelEngine())
    {
      IApplication application = excelEngine.Excel;
      IWorkbook workbook = application.Workbooks.Open("Sample.xlsx");
      IWorksheet worksheet = workbook.Worksheets[0];

      IPivotTable pivotTable = worksheet.PivotTables[0];
      //Get the cell format for "A1" pivot range.
      IPivotCellFormat cellFormat = pivotTable.GetCellFormat("A1");
      //Set reading order
      cellFormat.ReadingOrder = ExcelReadingOrderType.RightToLeft;

      workbook.SaveAs("PivotFormat.xlsx");
      workbook.Close();
      excelEngine.Dispose();

  }

RightBorderColor

Gets or sets the right border color from predefined colors (ExcelKnownColors).

Declaration

ExcelKnownColors RightBorderColor { get; set; }

Property Value

Type
ExcelKnownColors

Examples

    using(ExcelEngine excelEngine = new ExcelEngine())
    {
      IApplication application = excelEngine.Excel;
      IWorkbook workbook = application.Workbooks.Open("Sample.xlsx");
      IWorksheet worksheet = workbook.Worksheets[0];

      IPivotTable pivotTable = worksheet.PivotTables[0];
      //Get the cell format for "A1" pivot range.
      IPivotCellFormat cellFormat = pivotTable.GetCellFormat("A1");
      cellFormat.RightBorderStyle=ExcelLineStyle.Thick;
      cellFormat.RightBorderColor=ExcelKnownColors.Green;

      workbook.SaveAs("PivotFormat.xlsx");
      workbook.Close();
      excelEngine.Dispose();

  }

RightBorderColorRGB

Gets or sets RGB color to right border.

Declaration

Color RightBorderColorRGB { get; set; }

Property Value

Type
Color

Examples

    using(ExcelEngine excelEngine = new ExcelEngine())
    {
      IApplication application = excelEngine.Excel;
      IWorkbook workbook = application.Workbooks.Open("Sample.xlsx");
      IWorksheet worksheet = workbook.Worksheets[0];

      IPivotTable pivotTable = worksheet.PivotTables[0];
      //Get the cell format for "A1" pivot range.
      IPivotCellFormat cellFormat = pivotTable.GetCellFormat("A1");
      cellFormat.RightBorderStyle=ExcelLineStyle.Thick;
      cellFormat.RightBorderColorRGB=System.Drawing.Color.FromArgb(255, 0, 255, 0);

      workbook.SaveAs("PivotFormat.xlsx");
      workbook.Close();
      excelEngine.Dispose();

  }

RightBorderStyle

Gets or sets the right border line style.

Declaration

ExcelLineStyle RightBorderStyle { get; set; }

Property Value

Type
ExcelLineStyle

Examples

    using(ExcelEngine excelEngine = new ExcelEngine())
    {
      IApplication application = excelEngine.Excel;
      IWorkbook workbook = application.Workbooks.Open("Sample.xlsx");
      IWorksheet worksheet = workbook.Worksheets[0];

      IPivotTable pivotTable = worksheet.PivotTables[0];
      //Get the cell format for "A1" pivot range.
      IPivotCellFormat cellFormat = pivotTable.GetCellFormat("A1");
      cellFormat.RightBorderStyle=ExcelLineStyle.Thick;

      workbook.SaveAs("PivotFormat.xlsx");
      workbook.Close();
      excelEngine.Dispose();

  }

Rotation

Text rotation angle: 0 Not rotated 1-90 1 to 90 degrees counterclockwise 91-180 1 to 90 degrees clockwise 255 Letters are stacked top-to-bottom, but not rotated.

Declaration

int Rotation { get; set; }

Property Value

Type
System.Int32

Examples

    using(ExcelEngine excelEngine = new ExcelEngine())
    {
      IApplication application = excelEngine.Excel;
      IWorkbook workbook = application.Workbooks.Open("Sample.xlsx");
      IWorksheet worksheet = workbook.Worksheets[0];

      IPivotTable pivotTable = worksheet.PivotTables[0];
      //Get the cell format for "A1" pivot range.
      IPivotCellFormat cellFormat = pivotTable.GetCellFormat("A1");
      //Set rotation
      cellFormat.Rotation = 40;

      workbook.SaveAs("PivotFormat.xlsx");
      workbook.Close();
      excelEngine.Dispose();

  }

Exceptions

Type	Condition
System.ArgumentOutOfRangeException	Thrown when value is more than 0xFF.

ShrinkToFit

True- Indicates that the contents are shrunk to fit into cell.

Declaration

bool ShrinkToFit { get; set; }

Property Value

Type
System.Boolean

Examples

    using(ExcelEngine excelEngine = new ExcelEngine())
    {
      IApplication application = excelEngine.Excel;
      IWorkbook workbook = application.Workbooks.Open("Sample.xlsx");
      IWorksheet worksheet = workbook.Worksheets[0];

      IPivotTable pivotTable = worksheet.PivotTables[0];
      //Get the cell format for "A1" pivot range.
      IPivotCellFormat cellFormat = pivotTable.GetCellFormat("A1");
      //Set shrink to fit
      cellFormat.ShrinkToFit = true;

      workbook.SaveAs("PivotFormat.xlsx");
      workbook.Close();
      excelEngine.Dispose();

  }

StrikeThrough

Gets or sets a boolean value indicating whether the font is Strike.

Declaration

bool StrikeThrough { get; set; }

Property Value

Type
System.Boolean

Examples

    using(ExcelEngine excelEngine = new ExcelEngine())
    {
      IApplication application = excelEngine.Excel;
      IWorkbook workbook = application.Workbooks.Open("Sample.xlsx");
      IWorksheet worksheet = workbook.Worksheets[0];

      IPivotTable pivotTable = worksheet.PivotTables[0];
      //Get the cell format for "A1" pivot range.
      IPivotCellFormat cellFormat = pivotTable.GetCellFormat("A1");
      cellFormat.StrikeThrough=true;

      workbook.SaveAs("PivotFormat.xlsx");
      workbook.Close();
      excelEngine.Dispose();

  }

TopBorderColor

Gets or sets the Top Border color from predefined colors (ExcelKnownColors).

Declaration

ExcelKnownColors TopBorderColor { get; set; }

Property Value

Type
ExcelKnownColors

Examples

    using(ExcelEngine excelEngine = new ExcelEngine())
    {
      IApplication application = excelEngine.Excel;
      IWorkbook workbook = application.Workbooks.Open("Sample.xlsx");
      IWorksheet worksheet = workbook.Worksheets[0];

      IPivotTable pivotTable = worksheet.PivotTables[0];
      //Get the cell format for "A1" pivot range.
      IPivotCellFormat cellFormat = pivotTable.GetCellFormat("A1");
      cellFormat.TopBorderStyle=ExcelLineStyle.Thick;
      cellFormat.TopBorderColor=ExcelKnownColors.Green;

      workbook.SaveAs("PivotFormat.xlsx");
      workbook.Close();
      excelEngine.Dispose();

  }

TopBorderColorRGB

Gets or sets RGB color to Top border.

Declaration

Color TopBorderColorRGB { get; set; }

Property Value

Type
Color

Examples

    using(ExcelEngine excelEngine = new ExcelEngine())
    {
      IApplication application = excelEngine.Excel;
      IWorkbook workbook = application.Workbooks.Open("Sample.xlsx");
      IWorksheet worksheet = workbook.Worksheets[0];

      IPivotTable pivotTable = worksheet.PivotTables[0];
      //Get the cell format for "A1" pivot range.
      IPivotCellFormat cellFormat = pivotTable.GetCellFormat("A1");
      cellFormat.TopBorderStyle=ExcelLineStyle.Thick;
      cellFormat.TopBorderColorRGB=System.Drawing.Color.FromArgb(255, 0, 255, 0);

      workbook.SaveAs("PivotFormat.xlsx");
      workbook.Close();
      excelEngine.Dispose();

  }

TopBorderStyle

Gets or sets the Top border line style.

Declaration

ExcelLineStyle TopBorderStyle { get; set; }

Property Value

Type
ExcelLineStyle

Examples

    using(ExcelEngine excelEngine = new ExcelEngine())
    {
      IApplication application = excelEngine.Excel;
      IWorkbook workbook = application.Workbooks.Open("Sample.xlsx");
      IWorksheet worksheet = workbook.Worksheets[0];

      IPivotTable pivotTable = worksheet.PivotTables[0];
      //Get the cell format for "A1" pivot range.
      IPivotCellFormat cellFormat = pivotTable.GetCellFormat("A1");
      cellFormat.TopBorderStyle=ExcelLineStyle.Thick;

      workbook.SaveAs("PivotFormat.xlsx");
      workbook.Close();
      excelEngine.Dispose();

  }

Underline

Gets or sets the underline type from the pivot cell format.

Declaration

ExcelUnderline Underline { get; set; }

Property Value

Type
ExcelUnderline

Examples

    using(ExcelEngine excelEngine = new ExcelEngine())
    {
      IApplication application = excelEngine.Excel;
      IWorkbook workbook = application.Workbooks.Open("Sample.xlsx");
      IWorksheet worksheet = workbook.Worksheets[0];

      IPivotTable pivotTable = worksheet.PivotTables[0];
      //Get the cell format for "A1" pivot range.
      IPivotCellFormat cellFormat = pivotTable.GetCellFormat("A1");
      cellFormat.Underline =ExcelUnderline.Single;

      workbook.SaveAs("PivotFormat.xlsx");
      workbook.Close();
      excelEngine.Dispose();

  }

VerticalAlignment

Vertical alignment.

Declaration

ExcelVAlign VerticalAlignment { get; set; }

Property Value

Type
ExcelVAlign

Examples

    using(ExcelEngine excelEngine = new ExcelEngine())
    {
      IApplication application = excelEngine.Excel;
      IWorkbook workbook = application.Workbooks.Open("Sample.xlsx");
      IWorksheet worksheet = workbook.Worksheets[0];

      IPivotTable pivotTable = worksheet.PivotTables[0];
      //Get the cell format for "A1" pivot range.
      IPivotCellFormat cellFormat = pivotTable.GetCellFormat("A1");
      //Set alignment
      cellFormat.VerticalAlignment = ExcelVAlign.VAlignCenter;

      workbook.SaveAs("PivotFormat.xlsx");
      workbook.Close();
      excelEngine.Dispose();

  }

VerticalBorderColor

Gets or sets the Vertical Border color from predefined colors (ExcelKnownColors).

Declaration

ExcelKnownColors VerticalBorderColor { get; set; }

Property Value

Type
ExcelKnownColors

Examples

    using(ExcelEngine excelEngine = new ExcelEngine())
    {
      IApplication application = excelEngine.Excel;
      IWorkbook workbook = application.Workbooks.Open("Sample.xlsx");
      IWorksheet worksheet = workbook.Worksheets[0];

      IPivotTable pivotTable = worksheet.PivotTables[0];
      //Get the cell format for "A1" pivot range.
      IPivotCellFormat cellFormat = pivotTable.GetCellFormat("A1");
      cellFormat.VerticalBorderStyle=ExcelLineStyle.Thick;
      cellFormat.VerticalBorderColor=ExcelKnownColors.Green;

      workbook.SaveAs("PivotFormat.xlsx");
      workbook.Close();
      excelEngine.Dispose();

  }

VerticalBorderColorRGB

Gets or sets RGB color to Vertical border.

Declaration

Color VerticalBorderColorRGB { get; set; }

Property Value

Type
Color

Examples

    using(ExcelEngine excelEngine = new ExcelEngine())
    {
      IApplication application = excelEngine.Excel;
      IWorkbook workbook = application.Workbooks.Open("Sample.xlsx");
      IWorksheet worksheet = workbook.Worksheets[0];

      IPivotTable pivotTable = worksheet.PivotTables[0];
      //Get the cell format for "A1" pivot range.
      IPivotCellFormat cellFormat = pivotTable.GetCellFormat("A1");
      cellFormat.VerticalBorderStyle=ExcelLineStyle.Thick;
      cellFormat.VerticalBorderColorRGB=System.Drawing.Color.FromArgb(255, 0, 255, 0);

      workbook.SaveAs("PivotFormat.xlsx");
      workbook.Close();
      excelEngine.Dispose();

  }

VerticalBorderStyle

Gets or sets the Vertical border line style.

Declaration

ExcelLineStyle VerticalBorderStyle { get; set; }

Property Value

Type
ExcelLineStyle

Examples

    using(ExcelEngine excelEngine = new ExcelEngine())
    {
      IApplication application = excelEngine.Excel;
      IWorkbook workbook = application.Workbooks.Open("Sample.xlsx");
      IWorksheet worksheet = workbook.Worksheets[0];

      IPivotTable pivotTable = worksheet.PivotTables[0];
      //Get the cell format for "A1" pivot range.
      IPivotCellFormat cellFormat = pivotTable.GetCellFormat("A1");
      cellFormat.VerticalBorderStyle = ExcelLineStyle.Thick;

      workbook.SaveAs("PivotFormat.xlsx");
      workbook.Close();
      excelEngine.Dispose();

  }

WrapText

True - Indicates that text is wrapped at right border.

Declaration

bool WrapText { get; set; }

Property Value

Type
System.Boolean

Examples

    using(ExcelEngine excelEngine = new ExcelEngine())
    {
      IApplication application = excelEngine.Excel;
      IWorkbook workbook = application.Workbooks.Open("Sample.xlsx");
      IWorksheet worksheet = workbook.Worksheets[0];

      IPivotTable pivotTable = worksheet.PivotTables[0];
      //Get the cell format for "A1" pivot range.
      IPivotCellFormat cellFormat = pivotTable.GetCellFormat("A1");
      //Set wrap text
      cellFormat.WrapText = true;

      workbook.SaveAs("PivotFormat.xlsx");
      workbook.Close();
      excelEngine.Dispose();

  }