Hello,

I would think this would be a rather easy task but it has thoroughly confused me.

I am trying to take the value in cell[1,10], which is the result of a formula, and assign it to a variable in my code. So far, I have been unable to do this. I am using Excel 2003, C#.

This is my code:

If (dbConnection.Open != null)

{

Cells[1,10] = "Success";

}

//Below is what does not work.

string aString = (string)cells[1,10];

I have also tried,

string aString = Cells.get_Value(Cells[1,10]);

Any help would be very much appreciated.

Thanks,

ds

Hi

Quite easy when you know how.

Excel.Range objRange = (Excel.Range)objYourSheet.Cells[1,10];
strData = objRange.get_Value(Missing.Value).ToString();

Regards

I have a similar issue, but I can't get the code above to work, what is Missing.value? Could you include a larger code snippet which includes object definitions? That would be very helpful to me.

"missing" is what you need to pass to [Optional] COM parameters if you don't want to specify a value. If you're working in VSTO, then missing (as an object) is predefined for you and you can use that. If you're working outside of VSTO, then you have to declare it

object missing = System.Type.Missing;

or you can use System.Type.Missing directly in your code (just more finger-work ).