C#/WPF: Defining an EXCEL range through row and column number

Question

I have tried this

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

but it throw an undefined com exception

what I would like is something like (pseudocode)

Range myRange = new Range(new cell(1,1), cell(3,3));

so that I can then use it with (pseudocode again)

ws.myRange.Interior.Color = XlRgbColor.rgbDarkGray;

thank you

Ugur · Accepted Answer · 2016-02-08 10:53:45Z

0

Please check that out:

Range range1 = ws.Range[ws.Cells[1, j], ws.Cells[1, j+1]];

Here, Range is :

Microsoft.Office.Interop.Excel.Range

answered Feb 8, 2016 at 10:53

Ugur

1,2662 gold badges22 silver badges32 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1