Sunday 11 July 2010

Learning to program excel with c#

After some time I figured out how to set ranges with row and column numbers.


            range = xlWorkSheet.get_Range(xlWorkSheet.Cells[r1, c1], xlWorkSheet.Cells[r2, c2]);

where r1, r2, c1, c2 are all integers
and xlWorkSheet is the worksheet under work

No comments:

Post a Comment