CODEWITHSUNDEEP
jmeter
Royce
Royce

Reputation: 1595

Read Excel file with CSV Data Set Config Element

I'm building a project on JMeter and I would like to read an Excel file with CSV Data Set Config to avoid to use Groovy to read it.

Do you know if it is possible? If not, any other JMeter element can help me to read Excel file row by row?

Many thanks in advance,

Best regards,

Upvotes: 0

Views: 601

Answers (1)

Dmitri T
Dmitri T

Reputation: 168072

CSV Data Set Config is only able to read text files, as per Wikipedia:

A comma-separated values (CSV) file is a delimited text file that uses a comma to separate values.

If your data file is a binary file like .xls or .xslx unfortunately CSV Data Set Config won't help, you have the following options:

  1. Export .xls or .xlsx file to CSV using MS Excel or equivalent

  2. If for any reason you cannot use point 1 you can go for Apache POI libraries to read the Excel file formats in JSR223 Test Elements like it's described in How to Implement Data Driven Testing in your JMeter Test article.

    You can also see Busy Developers' Guide to HSSF and XSSF Features for some code snippets for popular user scenarios when it comes to reading/writing data from/to Excel files

Upvotes: 1

Related Questions