Class GridExcelConverterBase

Base class for Excel Export

Inheritance

System.Object

GridExcelConverterBase

GridExcelConverterControl

Namespace: Syncfusion.Windows.Controls.Grid.Converter

Assembly: Syncfusion.GridConverter.Wpf.dll

Syntax

public class GridExcelConverterBase : Object

Constructors

GridExcelConverterBase()

Declaration

public GridExcelConverterBase()

Fields

DEFCHARCURRENCY

Currency format in the .Net.

Declaration

protected const char DEFCHARCURRENCY = 'C'

Field Value

Type
System.Char

DEFCHARDATE

Date format in the .Net.

Declaration

protected const char DEFCHARDATE = 'D'

Field Value

Type
System.Char

DEFCHARFIXEDPOINT

Fixed point format in the .Net.

Declaration

protected const char DEFCHARFIXEDPOINT = 'F'

Field Value

Type
System.Char

DEFCHARGENERAL

General format in the .Net.

Declaration

protected const char DEFCHARGENERAL = 'G'

Field Value

Type
System.Char

DEFCHARHEX

Hexadecimal format in the .Net.

Declaration

protected const char DEFCHARHEX = 'X'

Field Value

Type
System.Char

DEFCHARNUMBER

Number format in the .Net.

Declaration

protected const char DEFCHARNUMBER = 'N'

Field Value

Type
System.Char

DEFCHARPERCENT

Percent format in the .Net.

Declaration

protected const char DEFCHARPERCENT = 'P'

Field Value

Type
System.Char

DEFCHARSCIENTIFIC

Sceintific format in the .Net.

Declaration

protected const char DEFCHARSCIENTIFIC = 'E'

Field Value

Type
System.Char

DEFDEFAULTHALIGNMENT

Default horizontal alignment.

Declaration

protected const ExcelHAlign DEFDEFAULTHALIGNMENT

Field Value

Type
ExcelHAlign

DEFDEFAULTVALIGNMENT

Default vertical alignment.

Declaration

protected const ExcelVAlign DEFDEFAULTVALIGNMENT

Field Value

Type
ExcelVAlign

DEFEXCELCURRENCYFORMAT

Currency format index in the MS Excel.

Declaration

protected const int DEFEXCELCURRENCYFORMAT = 7

Field Value

Type
System.Int32

DEFEXCELDATEFORMAT

Date format index in the MS Excel.

Declaration

protected const int DEFEXCELDATEFORMAT = 14

Field Value

Type
System.Int32

DEFEXCELDECIMALFORMAT

Decimal format index in the MS Excel.

Declaration

protected const int DEFEXCELDECIMALFORMAT = 4

Field Value

Type
System.Int32

DEFEXCELFIXEDPOINTFORMAT

Fixed-point format index in the MS Excel.

Declaration

protected const int DEFEXCELFIXEDPOINTFORMAT = 4

Field Value

Type
System.Int32

DEFEXCELGENERALFORMAT

Excel Generatl Format

Declaration

protected const int DEFEXCELGENERALFORMAT = 0

Field Value

Type
System.Int32

DEFEXCELHEXFORMAT

Hex format index in the MS Excel.

Declaration

protected const int DEFEXCELHEXFORMAT = 0

Field Value

Type
System.Int32

DEFEXCELNUMBERFORMAT

Number format index in the MS Excel.

Declaration

protected const int DEFEXCELNUMBERFORMAT = 4

Field Value

Type
System.Int32

DEFEXCELPERCENTFORMAT

Percent format index in the MS Excel.

Declaration

protected const int DEFEXCELPERCENTFORMAT = 9

Field Value

Type
System.Int32

DEFEXCELSCIENTIFICFORMAT

Scientific format index in the MS Excel.

Declaration

protected const int DEFEXCELSCIENTIFICFORMAT = 11

Field Value

Type
System.Int32

DEFGENERALFORMAT

General Format

Declaration

protected const string DEFGENERALFORMAT = "GENERAL"

Field Value

Type
System.String

DEFMAXCOLUMNONEINDEX

Maximum one-based index of the column in MS Excel.

Declaration

public const int DEFMAXCOLUMNONEINDEX = 256

Field Value

Type
System.Int32

DEFMAXCOLUMNZEROINDEX

Maximum zero-based index of the column in MS Exce.

Declaration

protected const int DEFMAXCOLUMNZEROINDEX = 255

Field Value

Type
System.Int32

DEFMAXIMUMANGLE

Maximum possible angle value.

Declaration

protected const int DEFMAXIMUMANGLE = 360

Field Value

Type
System.Int32

DEFMAXROWONEINDEX

Maximum one-based index of the row in MS Excel.

Declaration

public const int DEFMAXROWONEINDEX = 65536

Field Value

Type
System.Int32

DEFMAXROWZEROINDEX

Maximum zero-based index of the row in MS Excel.

Declaration

public const int DEFMAXROWZEROINDEX = 65535

Field Value

Type
System.Int32

DEFMINIMUMSUPPORTEDANGLE

Angle that corresponds to 90 rotation value in the XlsIO.

Declaration

protected const int DEFMINIMUMSUPPORTEDANGLE = 270

Field Value

Type
System.Int32

DEFRIGHTANGLE

Right angle value.

Declaration

protected const int DEFRIGHTANGLE = 90

Field Value

Type
System.Int32

Methods

CopyColumnWidthFromGrid(GridStyleInfo, IRange)

Copies column width settings from grid model into excel worksheet

Declaration

protected void CopyColumnWidthFromGrid(GridStyleInfo style, IRange range)

Parameters

Type	Name	Description
GridStyleInfo	style	Source grid cell
IRange	range	Destination excel cell

CopyRowHeightFromGrid(GridStyleInfo, IRange)

Copies row height settings from grid model into excel worksheet

Declaration

protected void CopyRowHeightFromGrid(GridStyleInfo style, IRange range)

Parameters

Type	Name	Description
GridStyleInfo	style	Source grid cell
IRange	range	Destination excel cell

CopyStyle(GridStyleInfo, IRange, Boolean)

Copies style from grid style into range style

Declaration

protected void CopyStyle(GridStyleInfo gridStyle, IRange destRange, bool IsAsyncExport)

Parameters

Type	Name	Description
GridStyleInfo	gridStyle	Grid style to copy
IRange	destRange	Destination range
System.Boolean	IsAsyncExport