C# Excel range management

Question

I'm dealing with excel files in a C# application.

I'm wondering why this code doesn't work:

var value1 = ws.Range[ws.Cells[7,4]].Value;

For now I found that this works fine:

int i = 7;
var value1 = ws.Range["D" + i.ToString()].Value;

Answer 1

Because you cant pass to a Range() a single Cells() Property, you will need to set it with 2 parameters of Cells():

var value1 = ws.Range[ws.Cells[7,4],ws.Cells[7,4]].Value;

or (use strict the Cells Property):

var value1 =  ws.Cells[7,4].Value;

Answer 2

The first parameter of ws.Range[] should be in in A1-style notation

To access

ws.Cells[7,4]

you can try this code:

var value1 = ws.Range["D7"].Value;

And check out this.