Working with Excel
-
I have a VB 6 code with me. The code is playing with excel. It generates worksheets and adds templates to them, sets cell values, etc. I want to rewrite the entire code into C#.Net. For that I have used Microsoft Excel 11.0 COM reference. (This is same in VB6). The problem is that I cannot find code in C#.Net equivalent to VB6 counterpart. Examples are given below: oBook.Worksheets("General") or this oSheet.Rows(2).Copy oSheet.Rows(i) There are many examples like this. Either I don't know how to write this in .Net or there is no equivalent. Does anybody know, where I can learn how to use Excel in .Net 2003 in good amount of depth so that I can convert any code in VB6 to .Net 2003? Regards Anil
-
I have a VB 6 code with me. The code is playing with excel. It generates worksheets and adds templates to them, sets cell values, etc. I want to rewrite the entire code into C#.Net. For that I have used Microsoft Excel 11.0 COM reference. (This is same in VB6). The problem is that I cannot find code in C#.Net equivalent to VB6 counterpart. Examples are given below: oBook.Worksheets("General") or this oSheet.Rows(2).Copy oSheet.Rows(i) There are many examples like this. Either I don't know how to write this in .Net or there is no equivalent. Does anybody know, where I can learn how to use Excel in .Net 2003 in good amount of depth so that I can convert any code in VB6 to .Net 2003? Regards Anil
hi anil look at this example http://www.codeproject.com/office/package.asp regards
-
hi anil look at this example http://www.codeproject.com/office/package.asp regards