Hi
Just trying with excel automation but i provided an excel sheet for output and even provided the cell write range sheet as sheet 1,I am getting the output in the sheet 1 where as new sheet is created with the same name,how can i get the same output in the existing sheet 1,please help!!!
Use append range activity in place of writerange activity
You are giving the sheetname as Sheet 1 …where as the sheet that already exists in Sheet1…please remove the space between sheet and 1, then it should write to Sheet1 directly as needed
Cheers
I can see that the sheet name that you have given in write range activity have space between(Sheet 1) making it different from existing sheet ,please remove the extra space and then give it a try !
haha yeah! Thanks Anil.
yeah! Thanks Tazunnisa.
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.
