cant read a string value from an excel cell?

[aotemp]

Hi,

Im having a reaaally hard time with something... Im trying to read a
cell of data into a String variable. It seems like such a simple task
too... Get the excel spreadsheet, get the workbook, get the sheet, get
the cell, get the cells data and store it into a string.

But it wont work! Im really frustrated. the best I got was
"System.___ComO bject" coming out of the string.

Any ideas C# gurus?

Only I cannot seem to get it right! Please help!
this.openFileDi alog1.FileName = "*.xls";
if (this.openFileD ialog1.ShowDial og() == DialogResult.OK )
{
InitializeCompo nent();
ExcelObj = new Excel.Applicati on();

Excel.Workbook xwSpreadsheet = ExcelObj.Workbo oks.Open("C:\\D ocuments
and Settings\\MTSUs er\\My Documents\\Visu al Studio Projects\
\WindowsApplica tion1\\bin\\Deb ug\\Countries.x ls",0,false,
5,"","",true,Ex cel.XlPlatform. xlWindows,"",tr ue,false,
0,false,true,fa lse);

Excel.Sheets sheets = xwSpreadsheet.W orksheets;
Excel.Worksheet worksheet = (Excel.Workshee t)sheets.get_It em(1);
for (int i = 1; i <= 10; i++)
{
////////NONE OF THESE ARE WORKING :(
//String y = (worksheet.Cell s[1,1]);
//Excel.Range range = worksheet.get_R ange("A"+i.ToSt ring(), "I" +
i.ToString());
//System.Array myvalues =
(System.Array)r ange.Cells.get_ Value(range);
//string[] strArray = //ConvertToString Array(myvalues) ;

//MessageBox.Show (strArray[1]);

}
}

[Nicholas Paldino [.NET/C# MVP]]

Well, you have to get the actual Range object that corresponds to the
cell (you should be able to call the Range property on the Worksheet to give
you the appropriate object, which you might have to cast to a Range object).
Once you have that, you can get the value using the Value property.
--
- Nicholas Paldino [.NET/C# MVP]
- mv*@spam.guard. caspershouse.co m

<ao****@hotmail .comwrote in message
news:11******** **************@ x18g2000prd.goo glegroups.com.. .

Hi,

Im having a reaaally hard time with something... Im trying to read a
cell of data into a String variable. It seems like such a simple task
too... Get the excel spreadsheet, get the workbook, get the sheet, get
the cell, get the cells data and store it into a string.

But it wont work! Im really frustrated. the best I got was
"System.___ComO bject" coming out of the string.

Any ideas C# gurus?

Only I cannot seem to get it right! Please help!
this.openFileDi alog1.FileName = "*.xls";
if (this.openFileD ialog1.ShowDial og() == DialogResult.OK )
{
InitializeCompo nent();
ExcelObj = new Excel.Applicati on();

Excel.Workbook xwSpreadsheet = ExcelObj.Workbo oks.Open("C:\\D ocuments
and Settings\\MTSUs er\\My Documents\\Visu al Studio Projects\
\WindowsApplica tion1\\bin\\Deb ug\\Countries.x ls",0,false,
5,"","",true,Ex cel.XlPlatform. xlWindows,"",tr ue,false,
0,false,true,fa lse);

Excel.Sheets sheets = xwSpreadsheet.W orksheets;
Excel.Worksheet worksheet = (Excel.Workshee t)sheets.get_It em(1);
for (int i = 1; i <= 10; i++)
{
////////NONE OF THESE ARE WORKING :(
//String y = (worksheet.Cell s[1,1]);
//Excel.Range range = worksheet.get_R ange("A"+i.ToSt ring(), "I" +
i.ToString());
//System.Array myvalues =
(System.Array)r ange.Cells.get_ Value(range);
//string[] strArray = //ConvertToString Array(myvalues) ;

//MessageBox.Show (strArray[1]);

}
}