Copy/Paste Range Excel to Smartsheet

Hello, I want to copy a range of an excel row and paste it in a smartsheet sheet.
I used the copy/paste Range activity but I dont know how to write the filter and the range. I also get “RangeValue isn’t a member of RangeValue” as Error. Can someone help?
Thank you in advance

Regards

Screenshot 2023-01-20 105258

@Carl_Kiakala_Kisolokele
Hello
I think you can remove Value from RangeValue for the Excel Source.

Regards

I tried and it didn’t work. I got two errrors:

  1. Smartsheet hasn’t been declared
  2. Range isn’t a member of RangeValue

Could you write the expression?

Thanks

Regards

@Carl_Kiakala_Kisolokele
In the expression writer of Copy Paste, use the + sign and select show on Excel and SmartSheet, select the range and it will write the expression for you.

regards

Hey,
how do I select the smartsheet sheet? Do I have to save it in the explorer first? Since the copy/Paste is from Excel, I can only paste it into another excel sheet. Can you show me how you did it?

Regards

@Carl_Kiakala_Kisolokele
Being honest, I am not familiar with Smartsheet, so someone else may be more help. I found this though you may checkout: UiPath for Smartsheet | Smartsheet

Regards