SpreadsheetFieldValue Class

Helps to look up the value associated with a field within a spreadsheet.

Inheritance Hierarchy

SystemObject
Test.FrameworkSpreadsheetFieldValue

Namespace: Test.Framework
Assembly: Test.Framework (in Test.Framework.dll) Version: 1.0.0.0 (1.0.0.0)

Syntax

C++

Copy

public class SpreadsheetFieldValue

Public Class SpreadsheetFieldValue

public ref class SpreadsheetFieldValue

type SpreadsheetFieldValue =  class end

The SpreadsheetFieldValue type exposes the following members.

Constructors

	Name	Description
	SpreadsheetFieldValue	Creates a new object.

Top

Properties

	Name	Description
	FieldPrefix	Gets or sets the prefix for field name columns - defaults to 'Field'.
	MaxFields	Gets or sets the number of columns to search across for field names and associated values.
	ValuePrefix	Gets or sets the prefix for value columns - defaults to 'Value'.
	Worksheet	Gets or sets the worksheet that field names and values will be extracted from.

Top

Methods

	Name	Description
	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.)
	GetByte	Returns the value for the field passed across or null if the field could not be found.
	GetBytes	Returns the value for the field passed across or null if the field could not be found.
	GetEnumT	Returns the value for the field passed across or null if the field could not be found.
	GetEString	Returns the value for the field passed across or null if the field could not be found.
	GetHashCode	Serves as a hash function for a particular type. (Inherited from Object.)
	GetNBool	Returns the value for the field passed across or null if the field could not be found.
	GetNByte	Returns the value for the field passed across or null if the field could not be found.
	GetNDouble	Returns the value for the field passed across or null if the field could not be found.
	GetNFloat	Returns the value for the field passed across or null if the field could not be found.
	GetNInt	Returns the value for the field passed across or null if the field could not be found.
	GetNLong	Returns the value for the field passed across or null if the field could not be found.
	GetNShort	Returns the value for the field passed across or null if the field could not be found.
	GetString	Returns the value for the field passed across or null if the field could not be found.
	GetType	Gets the Type of the current instance. (Inherited from Object.)
	MemberwiseClone	Creates a shallow copy of the current Object. (Inherited from Object.)
	ToString	Returns a string that represents the current object. (Inherited from Object.)

Top

Remarks

For some data-driven tests it can be useful to have a number of columns in the spreadsheet named 'Field1', 'Field2' ... 'Fieldn' which contain the name of a field and an associated set of columns 'Value1', 'Value2' ... 'Valuen' which contain the expected value associated with the field. This class wraps up the code necessary to find an associated value for a given field name.

Reference

Test.Framework Namespace