Version

ExportFormattingOptions Property

Determines whether the exporter will try to translate the grid formatting (colors, alignment, etc.) into the exporter excel spreadsheet.
Syntax
'Declaration
 
Public Property ExportFormattingOptions As ExportFormattingOptions
public ExportFormattingOptions ExportFormattingOptions {get; set;}
Remarks

By default, the exporter will attempt to export all formatting. This can be expensive for performance, so this property exists to allow you to turn off certain formatting in order to export faster.

Formatting includes anything on the IWorksheetCellFormat interface. That means it includes foreground and background colors, text alignment, font data, word wrapping, etc. If you turn off the formatting for a particular part of the grid and you find that it turns off more than you wanted, you can handle the appropriate event (such as CellExported, for example) and apply the needed formatting to the worksheet cell explicitly.

Requirements

Target Platforms: Windows 10, Windows 8.1, Windows 8, Windows 7, Windows Server 2012, Windows 7, Windows Vista SP1 or later, Windows XP SP3, Windows Server 2008 (Server Core not supported), Windows Server 2008 R2 (Server Core supported with SP1 or later), Windows Server 2003 SP2

See Also