Renaming a file using groovy
Hi, I have 5 test cases in my test suite. I have written a groovy script which creates an excel file with results of all the test cases. My second test case copies the report created by first tes...
Forum Discussion
Hi,
I tried with below code and getting an error:
Code:
import java.text.SimpleDateFormat
import com.eviware.soapui.model.testsuite.Assertable.AssertionStatus
import com.eviware.soapui.impl.wsdl.teststeps.RestTestRequestStep
import com.eviware.soapui.support.XmlHolder
import jxl.*
import jxl.write.*
def count=0,i=1,j=1
def inputFileName,outputFileName
def testStep = testRunner.testCase.testSteps["Properties"]
if (testStep.getPropertyCount() > 0){
for (prop in testStep.getPropertyList()){
if(prop.getName()=="outputFileName"){
outputFileName=prop.getValue()
}
}
}
Workbook old_WB=Workbook.getWorkbook(new File(outputFileName))
DateFormat df = new SimpleDateFormat("yyyyMMddhhmmss");
String filename = old_WB.split(".")[0] + df.format(new Date()) + old_WB.split(".")[1];
Error:
org.codehaus.groovy.runtime.typehandling.GroovyCastException: Cannot cast object 'java.text.SimpleDateFormat@88c7dd60' with class 'java.text.SimpleDateFormat' to class 'jxl.write.DateFormat' error at line: 18
I'm not familiar with coding. Please bear with me if there are any blunders.
Thank you in advance
Try the below code for the Workbok :-
String FILE = "C:\\Desktop\\data.xls";
Workbook old_wb = Workbook.getWorkbook(new File(FILE));
DateFormat df = new SimpleDateFormat("yyyy-MM-dd:hh:mm:ss");
String filename = old_wb + df.format(new Date()) + ".";And if you have the excel path then directly use :-
String FILE = "C://Desktop//data";
String FILE_EXTENSION = "xls";
DateFormat df = new SimpleDateFormat("yyyy-MM-dd:hh:mm:ss");
String filename = FILE + df.format(new Date()) + "." + FILE_EXTENSION;
System.out.println(filename);
Hi,
I have used the below code as suggested but still getting error:
Code:
import java.text.SimpleDateFormat
import com.eviware.soapui.model.testsuite.Assertable.AssertionStatus
import com.eviware.soapui.impl.wsdl.teststeps.RestTestRequestStep
import com.eviware.soapui.support.XmlHolder
import jxl.*
import jxl.write.*
def count=0,i=1,j=1
def inputFileName,outputFileName
def testStep = testRunner.testCase.testSteps["Properties"]
if (testStep.getPropertyCount() > 0){
for (prop in testStep.getPropertyList()){
if(prop.getName()=="outputFileName"){
outputFileName=prop.getValue()
}
}
}
Workbook old_WB=Workbook.getWorkbook(new File(outputFileName))
DateFormat df = new SimpleDateFormat("yyyy-MM-dd:hh:mm:ss");
String filename = old_wb + df.format(new Date()) + ".";error:
org.codehaus.groovy.runtime.typehandling.GroovyCastException: Cannot cast object 'java.text.SimpleDateFormat@f7573bba' with class 'java.text.SimpleDateFormat' to class 'jxl.write.DateFormat' error at line: 18
nmrao Could you please help here? i am also not able to get this,.. I gave the solution. its not working as expected.
- Could not go thru all the all posts.
First of all why to re-invent the wheel while SoapUI can generate Junit style reports which is a standard reporting?
Have a look at here. You just need to have docker intsalled and working.
All you need is to provide your project path in command line
https://community.smartbear.com/t5/SoapUI-Open-Source/Docker-Image-for-SoapUI-5-4-0/td-p/154860
roja1 : Is this issue resolved or you are still finding solution?
