PFExternalConnection_Location_Excel Class

Contains the information required to access the Excel data source of a PFExternalConnection. The target will always be a MS Office Excel file.

Inheritance Hierarchy

SystemObject
Packflow.CorePFExternalConnection_Location
Packflow.CorePFExternalConnection_Location_Excel

Namespace: Packflow.Core
Assembly: MicaSystems.Packflow.Core (in MicaSystems.Packflow.Core.dll) Version: 1.0.0.0 (3.2.0.306)

Syntax

[DataContractAttribute]
public class PFExternalConnection_Location_Excel : PFExternalConnection_Location

The PFExternalConnection_Location_Excel type exposes the following members.

Constructors

	Name	Description
	PFExternalConnection_Location_Excel

Properties

	Name	Description
	FilePath	Gets or sets the Excel file path.
	FilesDirectoryPath	Gets or sets the path of the folder containing the files for the FileHolder fields.
	TableName	Gets or sets the name of the table where the data can be found.
	Type	Gets the type of location in an enum form. (Overrides PFExternalConnection_LocationType.)
	WorksheetName	Gets or sets the name of the worksheet where the data can be found. This is optional. If empty, the first worksheet will be used.

Methods

	Name	Description
	ToString	Returns a string that represents the current object. (Inherited from Object.)

Extension Methods

	Name	Description
	AsT	Casts an object to another type. Returns default(T) if the object is null. (Defined by Utils_Other.)
	EqualsAll	Checks that this object is equal to every object in parameters. (Defined by Utils_Other.)
	EqualsAny	Checks that this object is equal to at least one of the parameters. (Defined by Utils_Other.)
	GetString	Converts an object to String using ToString() method, else returns String.Empty. (Defined by Utils_Other.)
	IsGenericList	Overloaded. Checks if this object is a System.Collections.Generic.List. (Defined by Utils_Linq.)
	IsGenericList(Type)	Overloaded. Checks if this object is a System.Collections.Generic.List using type as T. (Defined by Utils_Linq.)
	Serialize	Overloaded. Serializes an object into an XML document. (Defined by Utils_Xml.)
	Serialize(String)	Overloaded. Serializes an object into an XML document. (Defined by Utils_Xml.)
	SerializeJson	Overloaded. Serializes an object using a DataContractJsonSerializer. (Defined by Utils_String.)
	SerializeJson(ListType)	Overloaded. Serializes an object using a DataContractJsonSerializer. (Defined by Utils_String.)
	SerializeJson(DataContractJsonSerializerSettings)	Overloaded. Serializes an object using a DataContractJsonSerializer. (Defined by Utils_String.)