Fastest way to get an Excel Range of Rows

c# excel vsto office-interop
Gayan Dasanayake picture Gayan Dasanayake · Sep 11, 2012 · Viewed 72.8k times · Source

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

Answer

Reafidy picture Reafidy · Sep 11, 2012

Try this:

Sheet.Range("7:9,12:12,14:14")

EDIT: Sorry if using VSTO in C# it should have been:

sheet.get_Range("7:9,12:12,14:14", Type.Missing)

Related questions

How to open an Excel file in C#?

I am trying to convert some VBA code to C#. I am new to C#. Currently I am trying to open an Excel file from a folder and if it does not exist then create it. I am trying something …

Read More
How to reference Microsoft.Office.Interop.Excel dll?

I had developed a system that deals with excel sheets in 2006 using MS VS 2005. Now, I can not use the same reference with MS VS 2012. var app = new Microsoft.Office.Interop.Excel.Application(); Workbooks wbs = app.Workbooks;

Read More
How do I get an Excel range using row and column numbers in VSTO / C#?

I think the question sums it up. Given two integers for row and column or four integers for row and column for the two corners of a range, how do I get a range object for that range.

Read More