I have three datable which contains data and I want to write it in excel so I used three write range activity by passing datable name individually and able to write it.
But if I want to use only one write range activity and pass datable name and sheet name dynamically then how we can do.
Are you trying to write into single sheet or different sheet ?
If you are writing into single sheet then no need to pass different sheet names and also you can use Append Range activity instead of Write Range.
Yep otherwise I would just count the rows and play with the number of rows in the way of pasting it
Use append data activity
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.