Click or drag to resize

PFExcelDataExporter Class

An utility class to feed tables into Excel, based on Packflow data sources. Uses a mix of ClosedXml and OpenXml.
Inheritance Hierarchy
SystemObject
  Packflow.Interface.OfficePFExcelDataExporter

Namespace:  Packflow.Interface.Office
Assembly:  MicaSystems.Packflow.Interface (in MicaSystems.Packflow.Interface.dll) Version: 1.0.0.0 (2.0.0.223)
Syntax
C#
public sealed class PFExcelDataExporter

The PFExcelDataExporter type exposes the following members.

Constructors
  NameDescription
Public methodPFExcelDataExporter
Initializes a new instance of the PFExcelDataExporter class.
Top
Properties
  NameDescription
Public propertySettings
Gets the settings used for export. Contains a collection of PFExcelDataExporter_Source as data sources.
Top
Methods
  NameDescription
Public methodCreateWorkbook
Creates a workbook holding tables for selected PFExcelDataExporter_Source.
Public methodCreateWorkbook(Boolean)
Creates a workbook holding tables for selected PFExcelDataExporter_Source.
Public methodCreateWorkbookTemplate
Creates a workbook template, holding tables with headers but no values. Only uses Content-Type data sources set in Settings.
Public methodToString
Returns a string that represents the current object.
(Inherited from Object.)
Top
Extension Methods
  NameDescription
Public Extension MethodAsT
Casts an object to another type. Returns default(T) if the object is null.
(Defined by Utils_Other.)
Public Extension MethodEqualsAll
Checks that this object is equal to every object in parameters.
(Defined by Utils_Other.)
Public Extension MethodEqualsAny
Checks that this object is equal to at least one of the parameters.
(Defined by Utils_Other.)
Public Extension MethodGetString
Converts an object to String using ToString() method, else returns String.Empty.
(Defined by Utils_Other.)
Public Extension MethodIsGenericListOverloaded.
Checks if this object is a System.Collections.Generic.List.
(Defined by Utils_Linq.)
Public Extension MethodIsGenericList(Type)Overloaded.
Checks if this object is a System.Collections.Generic.List using type as T.
(Defined by Utils_Linq.)
Public Extension MethodSerializeOverloaded.
Serializes an object into an XML document.
(Defined by Utils_Xml.)
Public Extension MethodSerialize(String)Overloaded.
Serializes an object into an XML document.
(Defined by Utils_Xml.)
Public Extension MethodSerializeJsonOverloaded.
Serializes an object using a DataContractJsonSerializer.
(Defined by Utils_String.)
Public Extension MethodSerializeJson(ListType)Overloaded.
Serializes an object using a DataContractJsonSerializer.
(Defined by Utils_String.)
Public Extension MethodSerializeJson(DataContractJsonSerializerSettings)Overloaded.
Serializes an object using a DataContractJsonSerializer.
(Defined by Utils_String.)
Top
See Also