As suggested by you, first I did excel recording and then checked the argument. three arguments were created:
- rangeArg1 where excel range is mentioned which has to be copied
- fileArg1 which has the path of the excel
- copyExcelArg1 which is of direction Out, without any default value.
When I tried to write all 3 arguments, i am getting correct range and path, but copy argument is returning System.Object[,] instead of actual data which was there for selected range.
One more query, when I am copying a chart from the excel, no out direction argument is created. Dont know how to achieve same.
Also, if I want to place argument rangeArg1 in the mail body, how to call same. I tried creating a new argument for mail content and typed the tet as “Range for automation is” rangeArg1, same was not accepted. I want to call multiple arguments in the mail content such that mail content is automatically updated based on these values.
Please suggest what mistake I am doing.