Hi al.
I have three Excel books,
Ex1, Ex2, Ex3,...
Consider..
EX1
-----
C1 C2
1 4
2 5

Ex2
-----
c3 c4 c5
1 4 5
2 6 7
3 8 9

I need to copy these data into third excel that is Ex3 in specific sheet.. as
Ex3
-----
C1 c2 c3 c4 c5
1 4 1 4 5 and so on


The data from source file will not be in first row and first clomun..
and this will be applicable for Ex3 Destination excel..

I have tried using java api to solve this.. But due to the additionla contents.. like macros, and some other objects in the excel i cudnt do it....
Kindly suggest some other way..

A third party free ware will also do...

Thanks in advance....