Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Help with manipulating data in excel? | Excel Discussion (Misc queries) | |||
manipulating SQL data through Excel | Excel Programming | |||
Need help using VBA to compare data in Excel columns, then manipulating data | Excel Programming | |||
C:\Progra~/MI1933~1\Office\SETUP\Off97std.stf is missing or corru. | Setting up and Configuration of Excel | |||
Training on Manipulating Data in Excel | Excel Discussion (Misc queries) |