dorin
(Dorin Somlea)
June 2, 2020, 1:07pm
1
Hi everybody,
I have an excel file like this bellow an I need to copy and paste the depo value in a desktop app. Can be 0, 1, 2, 3,…n depo. How to copy the values with for each row till the first empty cell?
old account new account depo1 depo2 depo3 depo4
ABCEUR3520514 ABCEUR3520714 DEPO001 DEPO002 DEEPO003 DEPO004
BCDEUR2360484 BCDEUR6924584 DEPO011 DEPO022
EFGEUR6920578 EFG6920514 DEPO111 DEPO222 DEPO333
HYZEUR6284887 HYZ5682014 n/a
Thanks in advance,
Dorin
Test1.xlsx (8.5 KB)
balupad14
(Balamurugan)
June 2, 2020, 2:12pm
2
Hi @dorin ,
Here is an activity to copy the excel into the clipboard. After that you can past it anywhere
Hi Friends,
I have included some new activities in the “BalalReva.Excel.Actities”.
Activities
1.Copy Data activity - It copies the data from Excel Sheet to the clipboard
2.Delete Data activity - It deletes the data in the Excel Sheet
3.Clipboard To Datatable activity - It converts the clipboard to Datatable
Namespace
[image]
1.Properties Copy Data activity
[image]
Sample File : CopyData.zip (8.1 KB)
2.Properties of Delete Data activity
[image]
Sample : DeleteData.zip (6.9 KB)
3.…
Regards
Balamurugan.S