WritableWorkbook workbook = Workbook.createWorkbook(new File('d:\output. I know this is cheeky - cos I'm not coming to you with even an attempt at any code - I just wouldn t know where to start - I did find the following link which has the following code - but I'm getting : Pradeep : Manipulate the data inside an Excel file using jxl api in : Thanks to Andy Khan for sharing the reference documents about JXL API. So it could be something like admin:admin.

This property is named as basicAuthCreds and it contains user and password in the following format: :.

There is a jxl.jar file that is a sourceforge option for manipulating spreadsheets.i think this might be the way forward. As you can see in the description of the Library script, it can be added as: API request credentials are stored as user properties. I've done a bit of reading there is an 'Apose API' that appears to be reasonably straight forward to delete rows in a spreadsheet, but that looks like it requires money so that's not available. <- this would give me more than enough execution runs) and then I had a script that deleted the FIRST row in the spreadsheet (at the end of the test (teardown script)) - then each time the test was executed, the submissionid used in my. If I created a Excel datasource with the values required (e.g. I created another post ( link) originally cos I was asking about doing it via inline scripting - but I think I've thought of another way of doing it - hence the reason I've created a new post with a more apt title. json post request, so that the submissionid value is automatically incremented by a value of 1 each time the test case executes so that I can add my ReadyAPI! project into the jenkins pipeline I need to find someway to automate the update of a unique identifier (see below) contained in my.

Groovy jxl api