Class XlsxExporter2

Namespace

TimeCockpit.Data.Export.Excel

Assembly

TimeCockpit.Data.Export.dll

public class XlsxExporter2

Inheritance

Object

XlsxExporter2

Inherited Members

Object.ToString()

Object.Equals(Object)

Object.Equals(Object, Object)

Object.ReferenceEquals(Object, Object)

Object.GetHashCode()

Object.GetType()

Object.MemberwiseClone()

Constructors

XlsxExporter2()

public XlsxExporter2()

Methods

BuildDefaultTemplate(XLWorkbook, IEnumerable<BoundCell>)

public static void BuildDefaultTemplate(XLWorkbook wb, IEnumerable<BoundCell> columns)

Parameters

wb XLWorkbook

columns IEnumerable<BoundCell>

BuildDefaultTemplate(XLWorkbook, IEnumerable<BoundCell>, Boolean, Form, EntityObject, IEnumerable<ExportParameter>, String)

public static void BuildDefaultTemplate(XLWorkbook wb, IEnumerable<BoundCell> columns, bool showFilterParams, Form filterForm, EntityObject filterObject, IEnumerable<ExportParameter> advancedFilters, string listName)

Parameters

wb XLWorkbook

columns IEnumerable<BoundCell>

showFilterParams Boolean

filterForm Form

filterObject EntityObject

advancedFilters IEnumerable<ExportParameter>

listName String

BuildFilterForm(IXLWorksheet, Form, EntityObject, IEnumerable<ExportParameter>)

public static int BuildFilterForm(IXLWorksheet ws, Form filterForm, EntityObject filterObject, IEnumerable<ExportParameter> advancedFilters)

Parameters

ws IXLWorksheet

filterForm Form

filterObject EntityObject

advancedFilters IEnumerable<ExportParameter>

Returns

Int32

CheckTemplate(String, ModelEntityBase)

public static bool CheckTemplate(string templatePath, ModelEntityBase modelEntity)

Parameters

templatePath String

modelEntity ModelEntityBase

Returns

Boolean

Export(Byte[], IEnumerable<EntityObject>, IEnumerable<BoundCell>, Action<Int32>, CancellationToken)

public static byte[] Export(byte[] templateData, IEnumerable<EntityObject> entityObjects, IEnumerable<BoundCell> columns, Action<int> progressCallback, CancellationToken cancelToken)

Parameters

templateData Byte[]

entityObjects IEnumerable<EntityObject>

columns IEnumerable<BoundCell>

progressCallback Action<Int32>

cancelToken CancellationToken

Returns

Byte[]

Export(Byte[], IEnumerable<EntityObject>, IEnumerable<BoundCell>, Boolean, Form, EntityObject, IEnumerable<ExportParameter>, String, Action<Int32>, CancellationToken)

public static byte[] Export(byte[] templateData, IEnumerable<EntityObject> entityObjects, IEnumerable<BoundCell> columns, bool showFilterParams, Form filterForm, EntityObject filterObject, IEnumerable<ExportParameter> advancedFilters, string listName, Action<int> progressCallback, CancellationToken cancelToken)

Parameters

templateData Byte[]

entityObjects IEnumerable<EntityObject>

columns IEnumerable<BoundCell>

showFilterParams Boolean

filterForm Form

filterObject EntityObject

advancedFilters IEnumerable<ExportParameter>

listName String

progressCallback Action<Int32>

cancelToken CancellationToken

Returns

Byte[]

ExportToFile(String, String, IEnumerable<EntityObject>, IEnumerable<BoundCell>, Action<Int32>, CancellationToken)

public static void ExportToFile(string templatePath, string filePath, IEnumerable<EntityObject> entityObjects, IEnumerable<BoundCell> columns, Action<int> progressCallback, CancellationToken cancelToken)

Parameters

templatePath String

filePath String

entityObjects IEnumerable<EntityObject>

columns IEnumerable<BoundCell>

progressCallback Action<Int32>

cancelToken CancellationToken

ExportToFile(String, String, IEnumerable<EntityObject>, IEnumerable<BoundCell>, Boolean, Form, EntityObject, IEnumerable<ExportParameter>, String, Action<Int32>, CancellationToken)

public static void ExportToFile(string templatePath, string filePath, IEnumerable<EntityObject> entityObjects, IEnumerable<BoundCell> columns, bool exportFilterParams, Form filterForm, EntityObject filterObject, IEnumerable<ExportParameter> advancedFilters, string listName, Action<int> progressCallback, CancellationToken cancelToken)

Parameters

templatePath String

filePath String

entityObjects IEnumerable<EntityObject>

columns IEnumerable<BoundCell>

exportFilterParams Boolean

filterForm Form

filterObject EntityObject

advancedFilters IEnumerable<ExportParameter>

listName String

progressCallback Action<Int32>

cancelToken CancellationToken

FillWorkBook(XLWorkbook, IEnumerable<EntityObject>, IEnumerable<BoundCell>, Action<Int32>, CancellationToken)

public static void FillWorkBook(XLWorkbook wb, IEnumerable<EntityObject> entityObjects, IEnumerable<BoundCell> columns, Action<int> progressCallback, CancellationToken cancelToken)

Parameters

wb XLWorkbook

entityObjects IEnumerable<EntityObject>

columns IEnumerable<BoundCell>

progressCallback Action<Int32>

cancelToken CancellationToken

SanitizeWorksheetName(String)

public static string SanitizeWorksheetName(string sourceName)

Parameters

sourceName String

Returns

String

SetCellStyle(BoundCell, IXLCell)

public static void SetCellStyle(BoundCell boundCell, IXLCell cell)

Parameters

boundCell BoundCell

cell IXLCell