How to call Worksheets of a Workbook as csv files through BeanShell sampler in Jmeter
I am new to Jmeter.
My test plan contains different thread groups. For each thread group, I am using a CSV file using 'CSV Data Set Config'.
But requirement is: Use a Work Book and call the workbook worksheets as CSV files using Bean Shell sampler
Could you please resolve this issue, how to call the worksheets of a workbook using Beanshell in Jmeter?
Thanks in advance.
what is the sceario....if you can use CSV Data set config for CSV files....why you want to use bean shell for the same
JMeter CSV Data Set config isn't capable of reading Excel entities per se. You'll need to get Apache POI libraries and drop them to JMeter classpath. However if so I wouldn't recommend using Beanshell for reading Excel, better consider JSR223 Sampler and Groovy as language (similarly to POI you'll need to have groovy jar in your classpath - usually JMeter /lib folder. See Beanshell vs JSR223 vs Java JMeter Scripting performance comparison document for details, recommendations and limitations.