Page 1 of 1

"reading" XLS and conditional delete rows

Posted: Wed Feb 15, 2012 5:48 pm
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?

"reading" XLS and conditional delete rows

Posted: Sat Feb 18, 2012 5:46 am
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)

"reading" XLS and conditional delete rows

Posted: Fri Feb 24, 2012 1:56 pm
by jeroen123
OK I try that, thanks