Class SheetExport

Represents a class for sheet export.

Inheritance

System.Object

SheetExport

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 SheetExport

Constructors

SheetExport()

Declaration

public SheetExport()

Properties

DownloadType

Gets or sets the download type.

Declaration

public ExcelDownloadType DownloadType { get; set; }

Property Value

Type	Description
ExcelDownloadType	The type of the download.

ExcelVersion

Gets or sets the excel version.

Declaration

public ExcelVersion ExcelVersion { get; set; }

Property Value

Type	Description
ExcelVersion	The excel version.

Methods

AddCellType(IRange, CellAttributes)

Declaration

protected void AddCellType(IRange range, CellAttributes cell)

Parameters

Type	Name	Description
IRange	range
CellAttributes	cell

AddHyperlink(IRange, CellAttributes)

Declaration

protected void AddHyperlink(IRange range, CellAttributes cell)

Parameters

Type	Name	Description
IRange	range
CellAttributes	cell

ApplyBorders(IRange, CellAttributes)

Declaration

protected void ApplyBorders(IRange range, CellAttributes cell)

Parameters

Type	Name	Description
IRange	range
CellAttributes	cell

ApplyCFormat(IRange, CellAttributes)

Declaration

protected void ApplyCFormat(IRange range, CellAttributes cell)

Parameters

Type	Name	Description
IRange	range
CellAttributes	cell

ApplyCfRule(String, String, String, String, String, ExcelCFType, IRange)

Declaration

protected void ApplyCfRule(string input1, string input2, string color, string bgColor, string range, ExcelCFType formula, IRange currentCell)

Parameters

Type	Name	Description
System.String	input1
System.String	input2
System.String	color
System.String	bgColor
System.String	range
ExcelCFType	formula
IRange	currentCell

ApplyCfRule(String, String, String, String, String, ExcelComparisonOperator, IRange)

Declaration

protected void ApplyCfRule(string input1, string input2, string color, string bgColor, string range, ExcelComparisonOperator op, IRange currentCell)

Parameters

Type	Name	Description
System.String	input1
System.String	input2
System.String	color
System.String	bgColor
System.String	range
ExcelComparisonOperator	op
IRange	currentCell

ApplyValidation(IRange, CellAttributes)

Declaration

protected void ApplyValidation(IRange range, CellAttributes cell)

Parameters

Type	Name	Description
IRange	range
CellAttributes	cell

CopyComments(IRange, CellAttributes)

Declaration

protected void CopyComments(IRange range, CellAttributes cell)

Parameters

Type	Name	Description
IRange	range
CellAttributes	cell

CopyFormats(IRange, CellAttributes)

Declaration

protected void CopyFormats(IRange range, CellAttributes cell)

Parameters

Type	Name	Description
IRange	range
CellAttributes	cell

CopyStyles(IRange, CellAttributes)

Declaration

protected void CopyStyles(IRange range, CellAttributes cell)

Parameters

Type	Name	Description
IRange	range
CellAttributes	cell

Export(WorkbookProperties, DataContainer, String, ExportFormat, ExcelVersion)

Declaration

public void Export(WorkbookProperties sheetModel, DataContainer sheetData, string fileName, ExportFormat type, ExcelVersion excelVersion)

Parameters

Type	Name	Description
WorkbookProperties	sheetModel
DataContainer	sheetData
System.String	fileName
ExportFormat	type
ExcelVersion	excelVersion

Export(WorkbookProperties, DataContainer, String, ExportFormat, ExcelVersion, String)

Save the Spreadsheet in excel file.

Declaration

public void Export(WorkbookProperties sheetModel, DataContainer sheetData, string fileName, ExportFormat type, ExcelVersion excelVersion, string password)

Parameters

Type	Name	Description
WorkbookProperties	sheetModel	The Spreadsheet model.
DataContainer	sheetData	The Spreadsheet data.
System.String	fileName	The file name to export.
ExportFormat	type	The type of excel file.
ExcelVersion	excelVersion	The version of excel file.
System.String	password	The password for excel file.

ExportAsBinary(WorkbookProperties, DataContainer, ExportFormat, ExcelVersion)

Save the Spreadsheet as binary file.

Declaration

public Stream ExportAsBinary(WorkbookProperties sheetModel, DataContainer sheetData, ExportFormat type, ExcelVersion excelVersion)

Parameters

Type	Name	Description
WorkbookProperties	sheetModel	The Spreadsheet model.
DataContainer	sheetData	The Spreadsheet data.
ExportFormat	type	The type of excel file.
ExcelVersion	excelVersion	The version of excel file.

Returns

Type	Description
System.IO.Stream

InitializeSheet()

Initializes the sheet.

Declaration

public void InitializeSheet()

ProcessNamedRange()

Declaration

protected void ProcessNamedRange()

ProcessSheet(WorkbookProperties, DataContainer)

Process the exporting sheet.

Declaration

public void ProcessSheet(WorkbookProperties sheetModel, DataContainer sheetData)

Parameters

Type	Name	Description
WorkbookProperties	sheetModel	The Spreadsheet model.
DataContainer	sheetData	The Spreadsheet data.

ProcessSheetModel()

Declaration

protected void ProcessSheetModel()