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
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