How to transfer data from CSV to Excel using Beanshell in JMeter?

Question

I want to save CSV file data into Excel file which is passed in parameterization using Beanshell. If it is possible than please let me know.

Answer 1

Everything is possible, it just the matter of time and efforts. If I'm getting your question right and you need to convert CSV file into Excel file, you can do it via Apache Tika:

1. Download tika-app-xxx.jar and save it into "lib" folder of your JMeter installation
2. Restart JMeter to pick the .jar up

3. Using Apache POI Spreadsheet API you can read and write Excel files, see following reference guides for examples

   • Busy Developers' Guide to HSSF and XSSF Features
   • How to Use BeanShell: JMeter's Favorite Built-in Component