copy data from 1 workbook (excel) to another

[eyal]

Hello,

I want to open 2 workbook, , lets say workbook1 and workbook2

now I want to copy data from a sheet name "TEST" in workbook2 and paste the
data to a sheet named "TEST" in workbook.
now , I dont know the size of the data ,so I can't use the get_range option
of the c# . I need a command like select.currentregion of the vba.

antoher problem that I have is that I can't open 2 workbook with the
Excel.Application:
Excel.Application oXL;

Excel.Workbook Wxls =
oXL.Workbooks.Open(wfile,
Type.Missing, Type.Missing, Type.Missing,
Type.Missing,
Type.Missing, Type.Missing, Type.Missing,
Type.Missing,
Type.Missing, Type.Missing, Type.Missing,
Type.Missing,
Type.Missing, Type.Missing);
Excel.Workbook Wxls2 =
oXL.Workbooks.Open(wfile2,
Type.Missing, Type.Missing, Type.Missing,
Type.Missing,
Type.Missing, Type.Missing, Type.Missing,
Type.Missing,
Type.Missing, Type.Missing, Type.Missing,
Type.Missing,
Type.Missing, Type.Missing);

mybe my syntax is not good.

So, Does anyone know how to do this?
Thanks,
Eyal