Class GridExcelExport

Inheritance

System.Object

GridExcelExport

Implements

IEJExport

Inherited Members

System.Object.ToString()

System.Object.Equals(System.Object)

System.Object.Equals(System.Object, System.Object)

System.Object.ReferenceEquals(System.Object, System.Object)

System.Object.GetHashCode()

System.Object.GetType()

System.Object.MemberwiseClone()

Namespace: Syncfusion.EJ.Export

Assembly: Syncfusion.EJ.Export.dll

Syntax

public class GridExcelExport : IEJExport

Constructors

GridExcelExport()

Declaration

public GridExcelExport()

Fields

_emptyText

Declaration

public string _emptyText

Field Value

Type	Description
System.String

Properties

AutoFormat

Gets or sets the AutoFormat of the file.

Declaration

public AutoFormat AutoFormat { get; set; }

Property Value

Type	Description
AutoFormat	The AutoFormat of the file.

DataSource

Gets or sets the datasource of the grid.

Declaration

public IEnumerable DataSource { get; set; }

Property Value

Type	Description
System.Collections.IEnumerable	The Datasource of the grid.

Document

Gets or sets the Document.

Declaration

public object Document { get; set; }

Property Value

Type	Description
System.Object	The Document for exporting.

DocumentOption

Gets or sets the documentoption of the file.

Declaration

public DocumentOption DocumentOption { get; set; }

Property Value

Type	Description
DocumentOption	The documentoption of the file.

DownloadType

Gets or sets the Excel download type of the file.

Declaration

public ExcelDownloadType DownloadType { get; set; }

Property Value

Type	Description
ExcelDownloadType	The name of the file.

EmptyText

Gets or sets the Empty record text of the file.

Declaration

public string EmptyText { get; set; }

Property Value

Type	Description
System.String	The name of the file.

Excelversion

Gets or sets the excel version.

Declaration

public ExcelVersion Excelversion { get; set; }

Property Value

Type	Description
ExcelVersion	The excel version.

ExportType

Gets or sets the MultipleExportType for the file.

Declaration

public MultipleExportType ExportType { get; set; }

Property Value

Type	Description
MultipleExportType	The MultipleExportType for file.

FileName

Gets or sets the name of the file.

Declaration

public string FileName { get; set; }

Property Value

Type	Description
System.String	The name of the file.

FilePath

Gets or sets the File Path for saving file.

Declaration

public string FilePath { get; set; }

Property Value

Type	Description
System.String	The File Path for saving file in local.

FontWeight

Gets or sets the FontWeight.

Declaration

public FontWeight FontWeight { get; set; }

Property Value

Type	Description
FontWeight	FontWeight.

HeaderText

Gets or sets the Header Text for multiple export.

Declaration

public string HeaderText { get; set; }

Property Value

Type	Description
System.String	HeaderText for multiple export.

IncludeChildGrid

Gets or sets the IncludeChildGrid to either included/exclude the child Grid.

Declaration

public bool IncludeChildGrid { get; set; }

Property Value

Type	Description
System.Boolean	true/false

IncludeDetailRow

Declaration

public bool IncludeDetailRow { get; set; }

Property Value

Type	Description
System.Boolean

IsAutoFit

Gets or sets the IsAutoFit for grid.

Declaration

public bool IsAutoFit { get; set; }

Property Value

Type	Description
System.Boolean	IsAutoFit in file.

IsAutoFitRows

Gets or sets the IsAutoFitRows for grid.

Declaration

public bool IsAutoFitRows { get; set; }

Property Value

Type	Description
System.Boolean	IsAutoFitRows in file.

IsCustomCommandColumnIncude

Gets or sets the IsCustomCommandColumnIncude for grid.

Declaration

public bool IsCustomCommandColumnIncude { get; set; }

Property Value

Type	Description
System.Boolean	IsCustomCommandColumnIncude in file.

IsHideColumnIncude

Gets or sets the IsHideColumnInclude for grid.

Declaration

public bool IsHideColumnIncude { get; set; }

Property Value

Type	Description
System.Boolean	IsHideColumnInclude in file.

IsSummaryRow

Gets or sets the IsSummaryRow included in the file.

Declaration

public bool IsSummaryRow { get; set; }

Property Value

Type	Description
System.Boolean	IsSummaryRow in file.

IsTemplateColumnIncluded

Gets or sets the IsTemplateColumnIncluded included in the file.

Declaration

public bool IsTemplateColumnIncluded { get; set; }

Property Value

Type	Description
System.Boolean	IsTemplateColumnIncluded included in file.

LocalSave

Gets or sets the is file locally saved.

Declaration

public bool LocalSave { get; set; }

Property Value

Type	Description
System.Boolean	The LocalSave option for file.

QueryCustomSummaryInfo

Declaration

public Func<IQueryable, SummaryColumn, object> QueryCustomSummaryInfo { get; set; }

Property Value

Type	Description
System.Func<System.Linq.IQueryable, SummaryColumn, System.Object>

SourceType

Declaration

public Type SourceType { get; set; }

Property Value

Type	Description
System.Type

Theme

Gets or sets the Theme of the file.

Declaration

public string Theme { get; set; }

Property Value

Type	Description
System.String	The Theme of the file.

WorkBook

Gets or sets the excel workbook.

Declaration

public IWorkbook WorkBook { get; set; }

Property Value

Type	Description
IWorkbook	The excel workbook.

Methods

CopyBorders(GridTableCellType, IRange)

Copies the borders.

Declaration

protected void CopyBorders(GridTableCellType style, IRange range)

Parameters

Type	Name	Description
GridTableCellType	style	The style.
IRange	range	The range.

CopyStyles(GridTableCellType, IRange)

Declaration

protected void CopyStyles(GridTableCellType style, IRange range)

Parameters

Type	Name	Description
GridTableCellType	style
IRange	range

ExecuteResult(GridProperties, Object)

Declaration

public void ExecuteResult(GridProperties GridModel, object dataSource)

Parameters

Type	Name	Description
GridProperties	GridModel
System.Object	dataSource

Export(GridProperties, Object, Boolean)

Declaration

public IWorkbook Export(GridProperties gridModel, object dataSource, bool multipleExport)

Parameters

Type	Name	Description
GridProperties	gridModel
System.Object	dataSource
System.Boolean	multipleExport

Returns

Type	Description
IWorkbook

ExportRecordRow(String)

Exports the record row.

Declaration

protected void ExportRecordRow(string value)

Parameters

Type	Name	Description
System.String	value	The value.

InitializeExcel(GridProperties, IWorkbook)

Initializes the excel.

Declaration

public void InitializeExcel(GridProperties model, IWorkbook book)

Parameters

Type	Name	Description
GridProperties	model	The model.
IWorkbook	book	The book.

SaveLocal(String)

Declaration

public void SaveLocal(string filepath)

Parameters

Type	Name	Description
System.String	filepath

SetFontStyles(IRange, Boolean)

Declaration

protected void SetFontStyles(IRange range, bool summary)

Parameters

Type	Name	Description
IRange	range
System.Boolean	summary

SetTableOptions(TableOptions, Int32, Int32)

Sets the table options.

Declaration

protected void SetTableOptions(TableOptions tableOptions, int Idx, int value)

Parameters

Type	Name	Description
TableOptions	tableOptions	The table options.
System.Int32	Idx	The idx.
System.Int32	value	The value.

Implements

IEJExport