ExcelDataSource Class

Provide data from EXCEL (Open XML Format) File.

Inheritance Hierarchy

SystemObject
Hummingbird.TestFramework.AutomationDataSource
Hummingbird.TestFramework.AutomationExcelDataSource

Namespace: Hummingbird.TestFramework.Automation
Assembly: Hummingbird.TestFramework.Automation (in Hummingbird.TestFramework.Automation.dll) Version: 1.2.0.0

Syntax

C++

Copy

[SerializableAttribute]
[DataContractAttribute(Namespace = "http://www.hummingbird-alm.com/testframework/201610")]
public class ExcelDataSource : DataSource

<SerializableAttribute>
<DataContractAttribute(Namespace := "http://www.hummingbird-alm.com/testframework/201610")>
Public Class ExcelDataSource
	Inherits DataSource

[SerializableAttribute]
[DataContractAttribute(Namespace = L"http://www.hummingbird-alm.com/testframework/201610")]
public ref class ExcelDataSource : public DataSource

[<SerializableAttribute>]
[<DataContractAttribute(Namespace = "http://www.hummingbird-alm.com/testframework/201610")>]
type ExcelDataSource =  
    class
        inherit DataSource
    end

The ExcelDataSource type exposes the following members.

Constructors

	Name	Description
	ExcelDataSource	Initializes a new instance of the ExcelDataSource class

Top

Properties

	Name	Description
	Data	Gets or sets the Data after the ImportData method (Inherited from DataSource.)
	DataTable	Gets a DataTable object which represents the current imported data (Inherited from DataSource.)
	FileName	Gets or sets the File name which to import the data. If HasHeader is set to , the first row of excel data is considered as headers
	HasHeader	Gets or sets a value indicating whether the data source has header. (Inherited from DataSource.)
	Headers	Gets or Sets the headers. if the file data source contains header (for example, The first row of a CSV the headers), headers will be refilled after the call of ImportData. The headers can be used as an variable. For example, the token ${name} will be replace by the value where the header name is "name" (Inherited from DataSource.)
	MaxRows	Gets or sets the maximum rows can be imported (Inherited from DataSource.)
	RangeName	Gets or sets RangeName according to the value of RangeType
	RangeType	Gets or sets RangeType. When using NamedRange or Table, SheetName will be ignored.
	SheetName	Gets or sets Name of the Sheet in a SpreadSheet document.

Top

Methods

	Name	Description
	Dispose	Performs application-defined tasks associated with freeing, releasing, or resetting unmanaged resources. (Inherited from DataSource.)
	Dispose(Boolean)	Releases unmanaged and - optionally - managed resources. (Inherited from DataSource.)
	Equals	Determines whether the specified object is equal to the current object. (Inherited from Object.)
	Finalize	Allows an object to try to free resources and perform other cleanup operations before it is reclaimed by garbage collection. (Inherited from Object.)
	GetHashCode	Serves as the default hash function. (Inherited from Object.)
	GetType	Gets the Type of the current instance. (Inherited from Object.)
	ImportData	Import Data from the given data source. After a successful import, the Data property will be filled. If HasHeader is set to True, the Headers property will be automatically assigned. (Overrides DataSourceImportData(TestCase).)
	MemberwiseClone	Creates a shallow copy of the current Object. (Inherited from Object.)
	OnPropertyChanged	Called when property value has changed. (Inherited from DataSource.)
	ReadData	Fetches the next row from the Data. This function can only be called when Headers and Data are imported. (Inherited from DataSource.)
	ResetCursor	Resets the current cursor to line 0, This function will be called systematically by the DataDrivenTestCase before the test. (Inherited from DataSource.)
	ToString	Returns a string that represents the current object. (Inherited from Object.)

Top

Events

	Name	Description
	PropertyChanged	Occurs when a property value changes. (Inherited from DataSource.)

Top

Extension Methods

	Name	Description
	ToStringOrXml	Converts any Object to string representation in String or XML format. (Defined by ExtensionMethods.)
	ToXmlString	Converts any Object to string representation in XML format. (Defined by ExtensionMethods.)

Top

Remarks

The property FileName support token replacement. ExcelDataSource support Open XML format Excel files.

Reference

Hummingbird.TestFramework.Automation Namespace

Hummingbird.TestFramework.AutomationDataSource