XlPrintOptions.HorizontalCentered Property

Gets or sets a value indicating whether worksheet data is centered horizontally on a printed page.

Namespace: DevExpress.Export.Xl

Assembly: DevExpress.Printing.v24.2.Core.dll

Declaration

C#

public bool HorizontalCentered { get; set; }

VB.NET

Public Property HorizontalCentered As Boolean

Property Value

Type	Description
Boolean	true, to center worksheet data; otherwise, false.

Property Paths

You can access this nested property as listed below:

Object Type	Path to HorizontalCentered
IXlSheet	.PrintOptions .HorizontalCentered

Remarks

Use the HorizontalCentered and XlPrintOptions.VerticalCentered properties to center worksheet data on a printed page.

To learn more about how to specify various print-related options, refer to the How to: Specify Print Settings example.

Example

The example below demonstrates how to specify print settings for a worksheet.

Note

A complete sample project is available at https://github.com/DevExpress-Examples/excel-export-api-examples

PageViewAndLayoutActions.cs

// Specify print options for the worksheet.
sheet.PrintOptions = new XlPrintOptions();
// Print row and column headings.
sheet.PrintOptions.Headings = true;
// Print gridlines.
sheet.PrintOptions.GridLines = true;
// Center worksheet data on a printed page.
sheet.PrintOptions.HorizontalCentered = true;
sheet.PrintOptions.VerticalCentered = true;

PageViewAndLayoutActions.vb

' Specify print options for the worksheet.
sheet.PrintOptions = New XlPrintOptions()
' Print row and column headings.
sheet.PrintOptions.Headings = True
' Print gridlines.
sheet.PrintOptions.GridLines = True
' Center worksheet data on a printed page.
sheet.PrintOptions.HorizontalCentered = True
sheet.PrintOptions.VerticalCentered = True