you can use Read range activity and use with for loop Now you can paste your string from where you want.
Thanks & Regards
It may help you. Here is an activity called copy data that to copy the excel data to clipboard in the specified range. It will call event if it is unformatted data. you can able to past where ever you want.
HI @bagishojha - the excel data is not static. Sometimes i have to select Range a13 to d14 and sometimes it could be from a15 to c16. How can i copy such dynamically changing data ?
HI @balupad14 - the excel data is not static. Sometimes i have to select Range a13 to d14 and sometimes it could be from a15 to c16. How can i copy such dynamically changing data ?
Create the string variable and stored the range into the variable.
Assign the variable to the Copy Range Property like below.
Hi @balupad14 - what if i dont know the Range value since it keeps changing ?
So you can use DataTable Filter and provide their your specific column.
Thanks & Regards
Yes. using the variable you can assign the range(Which is changing dynamically). And you can set the variable to the CopyRange property.
Hi , i dont have a column name , its just an excel sheet
Hi @balupad14- how can i check the output of copied range ? There is no out argument in it
No. You can try it in the notepad,word etc… by Ctrl+V.
Refer this link.
No , it doesnt work @balupad14- I have an excel and I do not know Range of cell values that has to be copied . In your activity I will have to mention Range values in a variable in order to copy that , also I need to paste that in an email .So i need an output variable to Copy and pass it to the email
Hi @John_M - there is no Copy Paste activity . Should i upgrade to latest version in order to see that activity ??
So only way is to use the activity called : Datatable to html.
First read range and then convert it to a html.
You have to install a package called Datatable to html.
Hi @John_M - it gives me an Output with all HTML Tags in it . Do you know how can i get a proper table without Tags in it ?
This will help you.
Not able to find the ‘Datatable to HTML’ package. Could you guide me here.
Thanks in advance…
- Right click on the worksheet tab and select Move or Copy .
- Select the Create a copy checkbox.
- Under Before sheet, select where you want to place the copy .
- Select OK.
You can learn some basic Excel knowledge here：https://docsbay.net/how-to-use-excel Hope it helps.