Skip to main content

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.1.Core.dll

NuGet Package: DevExpress.Printing.Core

Declaration

public bool HorizontalCentered { get; set; }

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

// 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;
See Also