C# Class Smrf.AppLib.ExcelRangeSplitter

Supports splitting an Excel range into subranges via enumeration.

Use SplitRange(Range, Int32) to split an Excel range into subranges that are no larger than a specified number of rows. It can be used to read cell values from a large worksheet without running into out-of-memory exceptions.

Show file Open project: 2014-sed-team3/term-project Class Usage Examples

Public Methods

Method	Description
GetParallelSubrange ( Range column1Subrange, Int32 column2NumberOneBased ) : Range
SplitRange ( Range rangeToSplit ) : IEnumerable
SplitRange ( Range rangeToSplit, Int32 maximumRowsPerSubrange ) : IEnumerable
SplitSingleAreaRange ( Range singleAreaRangeToSplit, Int32 maximumRowsPerSubrange ) : IEnumerable

Method Details

GetParallelSubrange() public static method

public static GetParallelSubrange ( Range column1Subrange, Int32 column2NumberOneBased ) : Range
column1Subrange	Range
column2NumberOneBased	System.Int32
return	Range

SplitRange() public static method

public static SplitRange ( Range rangeToSplit ) : IEnumerable
rangeToSplit	Range
return	IEnumerable

SplitRange() public static method

public static SplitRange ( Range rangeToSplit, Int32 maximumRowsPerSubrange ) : IEnumerable
rangeToSplit	Range
maximumRowsPerSubrange	System.Int32
return	IEnumerable

SplitSingleAreaRange() public static method

public static SplitSingleAreaRange ( Range singleAreaRangeToSplit, Int32 maximumRowsPerSubrange ) : IEnumerable
singleAreaRangeToSplit	Range
maximumRowsPerSubrange	System.Int32
return	IEnumerable