C# 클래스 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.

파일 보기 프로젝트 열기: 2014-sed-team3/term-project 1 사용 예제들

공개 메소드들

메소드	설명
GetParallelSubrange ( Range column1Subrange, Int32 column2NumberOneBased ) : Range
SplitRange ( Range rangeToSplit ) : IEnumerable
SplitRange ( Range rangeToSplit, Int32 maximumRowsPerSubrange ) : IEnumerable
SplitSingleAreaRange ( Range singleAreaRangeToSplit, Int32 maximumRowsPerSubrange ) : IEnumerable

메소드 상세

GetParallelSubrange() 공개 정적인 메소드

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

SplitRange() 공개 정적인 메소드

public static SplitRange ( Range rangeToSplit ) : IEnumerable
rangeToSplit	Range
리턴	IEnumerable

SplitRange() 공개 정적인 메소드

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

SplitSingleAreaRange() 공개 정적인 메소드

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