Retrieving data from Excel cells

[Chris Bellini]

Greetings! I'm developing a C# application that needs to read some data
from a selected XLS file. I've used VB in the past to automate Excel
but this is the first time I've used C#. Back in VB, I was able to
retrieve a cell's contents via something like this:

Set objExcellApp = CreateObject("E xcel.Applicatio n")
Set objWorkbook = objExcel.Workbo oks.Open(strPat hToXLS)

' retrive the contents of A1
strData = objExcel.Cells( 1, 1).Value

However, I quickly found out that this was not the case with C#. Thus
far, I have:

objExcel = new Excel.Applicati on();
objWorkbook = (Excel._Workboo k)(objExcel.Wor kbooks._Open(st rPath, true,
true, Missing.Value, Missing.Value, Missing.Value,
Missing.Value, Missing.Value, Missing.Value,
Missing.Value, Missing.Value, Missing.Value,
Missing.Value)) ;

objSheet = (Excel._Workshe et)objWorkbook. ActiveSheet;

objSheet.Cells[1,1] = "Testing";

// I thought this would store "Testing" in strData
// but it sure doesn't ;)
strData = objSheet.Cells[1,1];

How can I retreive a cell's contents? It could probably be done via
Range() but I'd hate to resort to that, as I like the flexibility that
the ROW,COLUMN format offers. Thanks in advance.
Chris

[KalleD]

This is how I do it (with Range)
Excel.Range oRng=(Excel.Ran ge)oSheet.Cells[1,1];
string strData=oRng.Va lue.ToString();
Hope it helps
Karl Daggfeldt

"Chris Bellini" wrote:

Greetings! I'm developing a C# application that needs to read some data
from a selected XLS file. I've used VB in the past to automate Excel
but this is the first time I've used C#. Back in VB, I was able to
retrieve a cell's contents via something like this:

Set objExcellApp = CreateObject("E xcel.Applicatio n")
Set objWorkbook = objExcel.Workbo oks.Open(strPat hToXLS)

' retrive the contents of A1
strData = objExcel.Cells( 1, 1).Value

However, I quickly found out that this was not the case with C#. Thus
far, I have:

objExcel = new Excel.Applicati on();
objWorkbook = (Excel._Workboo k)(objExcel.Wor kbooks._Open(st rPath, true,
true, Missing.Value, Missing.Value, Missing.Value,
Missing.Value, Missing.Value, Missing.Value,
Missing.Value, Missing.Value, Missing.Value,
Missing.Value)) ;

objSheet = (Excel._Workshe et)objWorkbook. ActiveSheet;

objSheet.Cells[1,1] = "Testing";

// I thought this would store "Testing" in strData
// but it sure doesn't ;)
strData = objSheet.Cells[1,1];

How can I retreive a cell's contents? It could probably be done via
Range() but I'd hate to resort to that, as I like the flexibility that
the ROW,COLUMN format offers. Thanks in advance.
Chris

[Chris Bellini]

Thanks, Karl. You pointed me in the right direction. For whatever
reason, the compiler hated the Value method. But I tried this:

Excel.Range objRange = (Excel.Range)ob jSheet.Cells[1,1];
strData = objRange.get_Va lue(Missing.Val ue).ToString();

and it worked like a charm :) Thanks.
Chris

KalleD wrote:

This is how I do it (with Range)
Excel.Range oRng=(Excel.Ran ge)oSheet.Cells[1,1];
string strData=oRng.Va lue.ToString();
Hope it helps
Karl Daggfeldt

"Chris Bellini" wrote:

Greetings! I'm developing a C# application that needs to read some data
from a selected XLS file. I've used VB in the past to automate Excel
but this is the first time I've used C#. Back in VB, I was able to
retrieve a cell's contents via something like this:

Set objExcellApp = CreateObject("E xcel.Applicatio n")
Set objWorkbook = objExcel.Workbo oks.Open(strPat hToXLS)

' retrive the contents of A1
strData = objExcel.Cells( 1, 1).Value

However, I quickly found out that this was not the case with C#. Thus
far, I have:

objExcel = new Excel.Applicati on();
objWorkbook = (Excel._Workboo k)(objExcel.Wor kbooks._Open(st rPath, true,
true, Missing.Value, Missing.Value, Missing.Value,
Missing.Value, Missing.Value, Missing.Value,
Missing.Value, Missing.Value, Missing.Value,
Missing.Value)) ;

objSheet = (Excel._Workshe et)objWorkbook. ActiveSheet;

objSheet.Cell s[1,1] = "Testing";

// I thought this would store "Testing" in strData
// but it sure doesn't ;)
strData = objSheet.Cells[1,1];

How can I retreive a cell's contents? It could probably be done via
Range() but I'd hate to resort to that, as I like the flexibility that
the ROW,COLUMN format offers. Thanks in advance.
Chris