How to delete data-driven data on katalon recorder?

Web Testing
1

When I import data into data driven, when I load csv after each run I want it to delete the first row of the excel file right in the addon then what?Can someone help me. I just learned about it

How to delete rows directly when running in csv data driven file?
2

Hi, you can’t directly interact with local file from browser, it’s blocked because of security reasons. But there is a way to workaround this problem. You can use “Katalon Helper Tool”. You can read about and download it from:
https://docs.katalon.com/katalon-recorder/docs/katalon-recorder-helper-tool.html#introduction
It’s small server that listens on 18910 port and execute OS command.

So when you want to delete line from file you just use command open with target set to:

http://localhost:18910/execute?cmd=
and after “=” sign you can use “powershell deletingFirstLineScript.ps1”
and obviously you need to create powershell script named “deletingFirstLineScript.ps1” which will delete this line.

1 Like