Hi Expert,
I have make a User define function in Excel.
it takes some argument, and it make a hit from remote server fetch one res the accroding to given argument.
The UDF woriking fine. But when user input this function in multiple cell and calucate. then it makes slow, becase each function hit each time to remote server to fetch data.
I want to do it fast.
the idea i have.
1. Make xml for each UDF arguemnt.
<Data>
<Formula>
<EmpID>A1</EmpID>
<DataItem>Salary</Dataitem>
<Period>1998</Period>
</Formula>
<Formula>
<EmpID>A1</EmpID>
<DataItem>BasicSalary</Dataitem>
<Period>1998</Period>
</Formula>
<Formula>
<EmpID>A2</EmpID>
<DataItem>Salary</Dataitem>
<Period>1998</Period>
</Formula>
<Formula>
<EmpID>A2</EmpID>
<DataItem>HRA</Dataitem>
<Period>Current</Period>
</Formula>
</Data>
2. I want to send it via web service.
3 . Get Result on web service from remote server.
4. Return Result as xml
<Data>
<Formula>
<EmpID>A1</EmpID>
<DataItem>Salary</Dataitem>
<Period>1998</Period>
<Result>20000</Result>
</Formula>
<Formula>
<EmpID>A1</EmpID>
<DataItem>BasicSalary</Dataitem>
<Period>1998</Period>
<Result>2000</Result>
</Formula>
<Formula><
<EmpID>A2</EmpID>
<DataItem>Salary</Dataitem>
<Period>Current</Period>
<Result>250000</Result>
</Formula>
<Formula>
<EmpID>A2</EmpID>
<DataItem>HRA</Dataitem>
<Period>Current</Period>
<Result>9000</Result>
</Formula>
</Data>
how it is possible.
mainly how i can parse xml in web service, and send argument to my store procedure for each xml row.