Welcome to the Kapow forum. Here you can get help, use your skills to help others and enjoy hanging out in the company of other Kapow Robot Developers.

Excel Automation



Posts : 6
Points : 75
Join date : 2018-10-16

Excel Automation

Post by junwei on Thu Nov 01, 2018 1:51 pm

Hi everyone, just want to check if Kapow is capable of doing these automation in excel:

1) Remove unwanted columns,

2) followed by merging the 2 files with the columns removed 

3) Finally, Remove the duplicates from merged files.

Please advice on this issue, thanks for the help.


Posts : 2
Points : 274
Join date : 2018-03-23

Re: Excel Automation

Post by EmmaC on Thu Nov 01, 2018 4:40 pm


I don't know if this is the best method but for this I would write the files to a database table excluding the columns you don't want to capture.
Then run a query on the database to remove the duplicates and write the clean data back into an excel.



Posts : 6
Points : 75
Join date : 2018-10-16

Re: Excel Automation

Post by junwei on Fri Nov 02, 2018 7:43 am

Hi, thanks for the quick response. Just to check is there any functions in Kapow that help remove the duplicates? Thanks


Posts : 13
Points : 255
Join date : 2018-04-24
Location : Singapore

Re: Excel Automation

Post by chrismemo on Fri Nov 02, 2018 9:39 am

Hi Junwei,

The one of other alternative is creating small Excel VBA (you can record the VBA macro) then execute it using Device Automation.  
This will require MS Excel installed with Macro setting enabled. It will run faster than saving into DB. Smile 



Posts : 1
Points : 16
Join date : 2018-12-03

How to remove unwanted cells from excel for processing?

Post by HMEEE on Sat Dec 15, 2018 10:58 am

I would like to move Row2 ColC data to be on Row1 ColC in excel before I extract the data. How can I do that? Thank you.

Sponsored content

Re: Excel Automation

Post by Sponsored content

    Current date/time is Tue Dec 18, 2018 11:09 pm