Forum Discussion
4 Replies
- nmraoChampion Level 3If you search (either on internet or in this forum), am sure you get sample code snippets. Doesn't it work?
- mani1Occasional Contributor
Hi Rao,
Thanks for your quick response.
Yes, I tried, searched in intranet and in forum, but I didn't get the correct sample code. Can you please help me on this..
I tried the below code, But it is giving the error "jxl.read.biff.BiffException unable to recognize OLE stream"
import jxl.*
import jxl.write.*
import jxl.read.biff.BiffException;def groovyUtils = new com.eviware.soapui.support.GroovyUtils( context )
def holder = groovyUtils.getXmlHolder("validateFile#Response")
//def request=groovyUtils.getXmlHolder("validateFile#Request")log.info holder.getXml()
def inputDataFileName= "D:\\userdata\\mchellia\\Desktop\\SSDP\\SSDP Test Automation\\NSCMD\\InputValues\\tmp_input_copy1.xls"
def inputDataSheetName="Sheet1"
Workbook workbook = Workbook.getWorkbook(new File(inputDataFileName));
WritableWorkbook copy = Workbook.createWorkbook(new File(inputDataFileName),workbook);
WritableSheet sheetl = copy.getSheet(inputDataSheetName);log.info(sheet1.isHidden())
xPath1 = "//*:uniqueid/text()"
log.info holder.getNodeValue(xPath1)Cell cell2Update = sheet.getRow(3).getCell(19);
cell2Update.setCellValue(xPath1);copy.write();
copy.close();
workbook.close();- nmraoChampion Level 31. You can try other sample code, there are plenty such as
http://www.javabykiran.com/tutorials/how-to-set-data-into-excel-sheet-using.jxl/how-to-set-data-into-excel-sheet-using.jxl.php
http://www.quicklyjava.com/write-to-excel-in-java/
2. I am particularly not favour of saving response into excel (column ). Excel becomes clutter. Instead you can save it a file and have the file name in the column. It's just my opinion and upto you.
Related Content
- 2 years ago
- 2 years ago
- 13 years ago
Recent Discussions
- 3 days ago