"reading" XLS and conditional delete rows

Discuss RoboTask here
Post Reply
jeroen123
Posts: 25
Joined: Wed Feb 15, 2012 5:35 pm

"reading" XLS and conditional delete rows

Post by jeroen123 »

I would like robotask to read an excel file with 65000rows and conditional delete rows:Like: Cell K1 could have 100 different values; I want RT to delete rows based on conditions I set:If Cell K1 has value G3, then delete row 1If Cell K1 has value G4, then keep row 1goto next row, and check this row, based on same conditionswould this be possible?
Oleg
Site Admin
Posts: 3202
Joined: Thu Jan 01, 1970 1:00 am
Contact:

"reading" XLS and conditional delete rows

Post by Oleg »

Unfortunately RoboTask can't process Excel files directly.
I think that it's better to solve such job by using VBA script (built-in BASIC for MS Office)
jeroen123
Posts: 25
Joined: Wed Feb 15, 2012 5:35 pm

"reading" XLS and conditional delete rows

Post by jeroen123 »

OK I try that, thanks
Post Reply