View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Rp007 Rp007 is offline
external usenet poster
 
Posts: 7
Default Reading & manipulating the Excel data programatically in C# progra

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.