Reading & manipulating Excel data programmatically using C# progra

[Rp007]

Hi

I am trying to open an existing excel file through my C# application and
reading the data in the excel file then I need to format the data
programatically then put the data back in to excel file on some other cell.

I am able to assign the cell values but can not access and format it. i.e
WorkSheet.Cells[1,2] = WorkSheet.Cells[4,4]; // working fine.
MessageBox.Show(WorkSheet.Cells[4,4].ToString()); // Shows as
'System.__ComObject' as message.

Couldn't get how to handle the cells data. I am using C# and referenciing
Excel 11.0 object library.

Any help would be appreciated.

thanks,
-Ram.

[Balaji]

Post by Rp007
Hi
I am trying to open an existing excel file through my C# application and
reading the data in the excel file then I need to format the data
programatically then put the data back in to excel file on some other cell.
I am able to assign the cell values but can not access and format it. i.e
WorkSheet.Cells[1,2] = WorkSheet.Cells[4,4]; // working fine.
MessageBox.Show(WorkSheet.Cells[4,4].ToString()); // Shows as
'System.__ComObject' as message.
Couldn't get how to handle the cells data. I am using C# and referenciing
Excel 11.0 object library.
Any help would be appreciated.
thanks,
-Ram.

MessageBox.Show(WorkSheet.Cells[4,4].Value.ToString());

BizTalk Utilities - Frustration free BizTalk Adapters
http://www.topxml.com/biztalkutilities