Click or drag to resize

imbEPPlusExtensionsSetValues Method

imbSCI | imbACE | imbNLP | imbWEM | imbWBI
Set values into cells, respecting direction. Returns ExcelRange pointing to cells affected.

Namespace:  imbSCI.DataComplex.extensions.data
Assembly:  imbSCI.DataComplex (in imbSCI.DataComplex.dll) Version: 0.3.70.
Syntax
C#
Copy
public static ExcelRange SetValues(
	this ExcelWorksheet sheet,
	cursor cur,
	IEnumerable value,
	bool doEnter = false,
	textCursorZoneCorner direction = textCursorZoneCorner.Bottom
)
Request Example View Source

Parameters

sheet
Type: ExcelWorksheet
The sheet.
cur
Type: imbSCI.Core.reporting.zonecursor
The current.
value
Type: System.CollectionsIEnumerable
The value.
doEnter (Optional)
Type: SystemBoolean
if set to true [do enter].
direction (Optional)
Type: imbSCI.Core.reporting.zonetextCursorZoneCorner
The direction.

Return Value

Type: ExcelRange
Returns ExcelRange pointing to cells affected

Usage Note

In Visual Basic and C#, you can call this method as an instance method on any object of type ExcelWorksheet. When you use instance method syntax to call this method, omit the first parameter. For more information, see Extension Methods (Visual Basic) or Extension Methods (C# Programming Guide).
See Also