Skip to content

XlsxExportOptions class

Provides options that define how a data control's data is exported to XLSX format.

Namespace: Eremex.AvaloniaUI.Controls.DataControl
Assembly: Eremex.Avalonia.Controls.dll
NuGet Package: Eremex.Avalonia.Controls

Declaration

public class XlsxExportOptions : ExportOptions

Constructors

name description
XlsxExportOptions() The default constructor.

Properties

name description
AllowFixedColumnHeaderPanel { get; set; } Gets or sets whether the fixed column header panel is allowed in the exported document.
AllowGrouping { get; set; } Gets or sets whether grouping is preserved in the exported document.
ApplyFormattingToEntireColumn { get; set; } Gets or sets whether the cell formatting is applied to the entire column in the exported document.
DocumentCulture { get; set; } Gets or sets the culture used to format values in the exported document.
ShowBands { get; set; } Gets or sets whether band headers are exported.
ShowGroupSummary { get; set; } Gets or sets whether group summaries are exported.
ShowHorizontalLines { get; set; } Gets or sets whether horizontal lines are exported.
ShowSummaryLabels { get; set; } Gets or sets whether summary labels are included in exported summary cells; without labels, a cell holds the live value formatted per the source column.
ShowTotalSummary { get; set; } Gets or sets whether total summaries are exported.
ShowVerticalLines { get; set; } Gets or sets whether vertical lines are exported.
SummaryCountBlankCells { get; set; } Gets or sets whether Count summary formulas account for blank cells so the exported count matches the grid.
TextExportMode { get; set; } Gets or sets whether cell values are exported as text or as values.

See Also

Used in articles