apache poi - Error When trying to use XSSF on Jmeter -

i getting error when trying create xlsx file using jmeter. try using hssf (for .xls) , works fine. when trying change using xlsx, getting error. copy jar file poi , poi-ooxml on jmeter lib file. here simple script :

import org.apache.poi.ss.usermodel.cell; import org.apache.poi.ss.usermodel.row; import org.apache.poi.xssf.usermodel.xssfsheet; import org.apache.poi.xssf.usermodel.xssfworkbook; import java.io.file; import java.io.filenotfoundexception; import java.io.fileoutputstream; import java.io.ioexception; import java.util.*; import java.lang.string; import java.lang.object;  xssfworkbook workbook = new xssfworkbook(); xssfsheet sheet = workbook.createsheet("sample sheet"); row row = sheet.createrow(0); cell cell = row.createcell(0); cell.setcellvalue("hencin");  try {     fileoutputstream out = new fileoutputstream(new file("d:\\jmeter\\testhencin.xlsx"));     workbook.write(out);     out.close();     system.out.println("excel written successfully.."); } catch (filenotfoundexception e) {     e.printstacktrace(); } catch (ioexception e) {     e.printstacktrace(); } 

actually when trying find error, problem getting line :

xssfworkbook workbook = new xssfworkbook(); xssfsheet sheet = workbook.createsheet("sample sheet"); 

please me figure out. works on hssf on xssf not working. getting error :response code: 500

response message: org.apache.jorphan.util.jmeterexception: error invoking bsh method: eval  org/apache/xmlbeans/xmlobject 

i suggest:

1. catching possible exceptions , printing stacktrace jmeter.log file well

2. re-throwing exception make sure won't false positive sampler result, like:

   } catch (throwable e) {     e.printstacktrace();     log.info("error in beanshell", e);     throw e; }  

with regards question, due missing xmlbeans jar in jmeter classpath. suggest following:

• get "clean" installation of latest jmeter version
• download latest version of tika-app.jar , drop jmeter's "lib" folder
• restart jmeter pick jar up

using tika necessary libraries bundled, moreover, jmeter display content of binary files in view results tree listener. see how extract data files jmeter article more details.