How to enter values into excel which is already open using QTP

[Narayanan]

I have a open excel work sheet and i need to activate this sheet and paste values to it. I have written code to open a new excel sheet and paste values into sheet1. But not sure how to activate once again and paste values into sheet2 so on...

Right now, every time i close the excel and open once again

Code:

Set xlsApp = CreateObject("Excel.Application")
xlsApp.Visible = True
Set xlsWorkBook = xlsApp.Workbooks.Open("C:\Users\narayk\Desktop\Test.xlsx")
columncounter  = JavaWindow("").JavaTree("").GetROProperty("columns_count")
For i=1 to columncounter-1
    selectItem =JavaWindow("").JavaTree("").Getcolumnheader(i)
    xlsWorkBook.Worksheets("sheet1").Cells(1,i).value=selectItem
next


'Activate the excel second time and paste values- not working
rowcount  = JavaWindow("").JavaTree("").GetROProperty("")
For R=0 to rowcount-1
    For C=0 to columncounter-1
      counter  = JavaWindow("").JavaTree("").GetColumnValue(R,C)
      xlsWorkBook.Worksheets("sheet2").Cells(2,C).value=selectItem
    Next
Next

I receive Unknow run time error

[basanth27]

Probably it should be,

Code:

For C=1 to columncounter-1