Formula with excel range
 

Hello,

I have a problem with the Excel Cell formula. I want to extract the
what are the referance cell for a particular formula.
Like if I use :
<range.Formula
Its return something like(depend on formula)
1) =SUM(A1:A3),
2)=A1+A3,
3)=A1+A2+A3,
4)=A1*SUM(A2:A3).

So, is there any built in function or types in C#.NET through which i
can eassily get the referance cell.

Please Reply me.

Thanks,
Prasanta

Formula with excel range
 

Range("A1").Precedents.Address
--
HTH...

Jim Thomlinson


"prasanta" wrote:

Hello,

I have a problem with the Excel Cell formula. I want to extract the
what are the referance cell for a particular formula.
Like if I use :
<range.Formula
Its return something like(depend on formula)
1) =SUM(A1:A3),
2)=A1+A3,
3)=A1+A2+A3,
4)=A1*SUM(A2:A3).

So, is there any built in function or types in C#.NET through which i
can eassily get the referance cell.

Please Reply me.

Thanks,
Prasanta

Formula with excel range
 

Hi Jim,

In range object there was no property such like this address i m geting
upto this Range("A1").Precedents, but i m not getting Address, so
please tell me where i can, i m using office 2003 with windows 2003 and
VS 2005.

Thanks,
Prasanta

Jim Thomlinson wrote:
Range("A1").Precedents.Address
--
HTH...

Jim Thomlinson


"prasanta" wrote:

Hello,

I have a problem with the Excel Cell formula. I want to extract the
what are the referance cell for a particular formula.
Like if I use :
<range.Formula
Its return something like(depend on formula)
1) =SUM(A1:A3),
2)=A1+A3,
3)=A1+A2+A3,
4)=A1*SUM(A2:A3).

So, is there any built in function or types in C#.NET through which i
can eassily get the referance cell.

Please Reply me.

Thanks,
Prasanta