Fastest way to get an Excel Range of Rows

Posted by gayan on Stack Overflow See other posts from Stack Overflow or by gayan
Published on 2012-09-11T05:17:26Z Indexed on 2012/09/11 21:38 UTC
Read the original article Hit count: 229

Filed under:
|
|
|

In a VSTO C# project I want to get a range of rows from a set of row indexes.

The row indexes can be for example like "7,8,9,12,14".

Then I want the range "7:9,12,14" rows.

I now do this:

Range rng1 = sheet.get_Range("A7:A9,A12,A14", Type.Missing);
rng1  = rng1.EntireRow;

But it's a bit inefficient due to string handling in range specification.

sheet.Rows["7:9"]

works but I can't give this

sheet.Rows["7:9,12,14"] // Fails

© Stack Overflow or respective owner

Related posts about excel

Related posts about c#-4.0