Class XlsxExporter2

Inheritance
System.Object
XlsxExporter2
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: TimeCockpit.Data.Export.Excel
Assembly: TimeCockpit.Data.Export.dll
Syntax
public class XlsxExporter2

Constructors

XlsxExporter2()

Declaration
public XlsxExporter2()

Methods

BuildDefaultTemplate(XLWorkbook, IEnumerable<BoundCell>)

Declaration
public static void BuildDefaultTemplate(XLWorkbook wb, IEnumerable<BoundCell> columns)
Parameters
Type Name Description
ClosedXML.Excel.XLWorkbook wb
System.Collections.Generic.IEnumerable<BoundCell> columns

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

Declaration
public static void BuildDefaultTemplate(XLWorkbook wb, IEnumerable<BoundCell> columns, bool showFilterParams, Form filterForm, EntityObject filterObject, IEnumerable<ExportParameter> advancedFilters, string listName)
Parameters
Type Name Description
ClosedXML.Excel.XLWorkbook wb
System.Collections.Generic.IEnumerable<BoundCell> columns
System.Boolean showFilterParams
Form filterForm
EntityObject filterObject
System.Collections.Generic.IEnumerable<ExportParameter> advancedFilters
System.String listName

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

Declaration
public static int BuildFilterForm(IXLWorksheet ws, Form filterForm, EntityObject filterObject, IEnumerable<ExportParameter> advancedFilters)
Parameters
Type Name Description
ClosedXML.Excel.IXLWorksheet ws
Form filterForm
EntityObject filterObject
System.Collections.Generic.IEnumerable<ExportParameter> advancedFilters
Returns
Type Description
System.Int32

CheckTemplate(String, ModelEntityBase)

Declaration
public static bool CheckTemplate(string templatePath, ModelEntityBase modelEntity)
Parameters
Type Name Description
System.String templatePath
ModelEntityBase modelEntity
Returns
Type Description
System.Boolean

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

Declaration
public static byte[] Export(byte[] templateData, IEnumerable<EntityObject> entityObjects, IEnumerable<BoundCell> columns, Action<int> progressCallback, CancellationToken cancelToken)
Parameters
Type Name Description
System.Byte[] templateData
System.Collections.Generic.IEnumerable<EntityObject> entityObjects
System.Collections.Generic.IEnumerable<BoundCell> columns
System.Action<System.Int32> progressCallback
System.Threading.CancellationToken cancelToken
Returns
Type Description
System.Byte[]

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

Declaration
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
Type Name Description
System.Byte[] templateData
System.Collections.Generic.IEnumerable<EntityObject> entityObjects
System.Collections.Generic.IEnumerable<BoundCell> columns
System.Boolean showFilterParams
Form filterForm
EntityObject filterObject
System.Collections.Generic.IEnumerable<ExportParameter> advancedFilters
System.String listName
System.Action<System.Int32> progressCallback
System.Threading.CancellationToken cancelToken
Returns
Type Description
System.Byte[]

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

Declaration
public static void ExportToFile(string templatePath, string filePath, IEnumerable<EntityObject> entityObjects, IEnumerable<BoundCell> columns, Action<int> progressCallback, CancellationToken cancelToken)
Parameters
Type Name Description
System.String templatePath
System.String filePath
System.Collections.Generic.IEnumerable<EntityObject> entityObjects
System.Collections.Generic.IEnumerable<BoundCell> columns
System.Action<System.Int32> progressCallback
System.Threading.CancellationToken cancelToken

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

Declaration
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
Type Name Description
System.String templatePath
System.String filePath
System.Collections.Generic.IEnumerable<EntityObject> entityObjects
System.Collections.Generic.IEnumerable<BoundCell> columns
System.Boolean exportFilterParams
Form filterForm
EntityObject filterObject
System.Collections.Generic.IEnumerable<ExportParameter> advancedFilters
System.String listName
System.Action<System.Int32> progressCallback
System.Threading.CancellationToken cancelToken

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

Declaration
public static void FillWorkBook(XLWorkbook wb, IEnumerable<EntityObject> entityObjects, IEnumerable<BoundCell> columns, Action<int> progressCallback, CancellationToken cancelToken)
Parameters
Type Name Description
ClosedXML.Excel.XLWorkbook wb
System.Collections.Generic.IEnumerable<EntityObject> entityObjects
System.Collections.Generic.IEnumerable<BoundCell> columns
System.Action<System.Int32> progressCallback
System.Threading.CancellationToken cancelToken

SanitizeWorksheetName(String)

Declaration
public static string SanitizeWorksheetName(string sourceName)
Parameters
Type Name Description
System.String sourceName
Returns
Type Description
System.String

SetCellStyle(BoundCell, IXLCell)

Declaration
public static void SetCellStyle(BoundCell boundCell, IXLCell cell)
Parameters
Type Name Description
BoundCell boundCell
ClosedXML.Excel.IXLCell cell