Copy excel data and paste it in Web mail

Help
1

Hi I want to copy few Rows and columns from an excel sheet and paste that same content in a Web mail , how can i do it ? The excel data size keeps changing always and whenever i copy the data from excel to word , it appears in a string format . Please help

Thanks !

2

Hi @shaileshpathak
you can use Read range activity and use with for loop Now you can paste your string from where you want.
Thanks & Regards
Bagish ojha

3

Hi @shaileshpathak,

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.

Regards
Balamurugan.S

4

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 ?

5

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 ?

6

Hi @shaileshpathak,

Create the string variable and stored the range into the variable.
Assign the variable to the Copy Range Property like below.

image
image1301×549 33.4 KB

Regards
Balamurugan.S

7

Hi @balupad14 - what if i dont know the Range value since it keeps changing ?

8

@shaileshpathak
So you can use DataTable Filter and provide their your specific column.
or
DataTable.select

Thanks & Regards
Bagish ojha

9

Hi @shaileshpathak,

Yes. using the variable you can assign the range(Which is changing dynamically). And you can set the variable to the CopyRange property.

Regards
Balamurugan.S

10

Hi , i dont have a column name , its just an excel sheet

11

Hi @balupad14- how can i check the output of copied range ? There is no out argument in it

12

Hi @shaileshpathak,

No. You can try it in the notepad,word etc… by Ctrl+V.

Regards
Balamurugan.S

13

https://youtu.be/WNCl0jeWWsA

Refer this link.

https://www.youtube.com/playlist?list=LL4rFIVc4DqmdpJ-xcp7y-bQ

14

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

15

Hi @John_M - there is no Copy Paste activity . Should i upgrade to latest version in order to see that activity ??

16

So only way is to use the activity called : Datatable to html.
First read range and then convert it to a html.

17

Hello,

You have to install a package called Datatable to html.

18

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 ?

19

Hi ,

This will help you.

Regards
Balamurugan.S

20

Hello John,

Not able to find the ‘Datatable to HTML’ package. Could you guide me here.

Thanks in advance…

Best Regards,
Pradeep