Excel file content validation problem using Apache Tika in Jmeter Received

[Hfhex 4]

I am using Apache Tika within Jmeter to validate the information that appears in a generated document.

1. An error is not generated. What happens is that when you select the Document option, nothing appears:

NOTE: This is happening to me when the document is an Excel, because when it is PDF if you see the content.
2.I had to leave the file "tika-app-2.9.0.jar inside the folder "ext2"

Because when I leave it inside "lib" I get the message:

The only solution I found for this error was to leave the aforementioned file inside the "ext" folder.
-> I understand that this is not correct but it has been the only solution that has given me results.

3. I have tried to extract the data as indicated by the documentation of Jmeter and Blazemeter but nothing has given me results.

In fact I have tried to carry out the process with the last two versions of Jmeter: 5.5 and 5.6.22.
:I confirm the versions of the Tika files:

My doubt is that when I use the Tika-app-2.9.0 file.jar inside the Ext folder and the generated document is a PDF, if the data is displayed.

As for the answers I received, I continued to investigate but have not been able to find a solution. I wonder if it is a question of the version of Tika-app, if it is not compatible with the versions I am using, if I need to configure something, because my interest is that I can visualize the information of the Excel files, that as far as I have read if it is possible to do it using Apache Tika.

I appreciate your help and guidance.

[Dmitri T]

1. Install clean latest version of JMeter which is JMeter 5.6.2 as of now
2. Download https://archive.apache.org/dist/tika/1.28.5/tika-app-1.28.5.jar and copy or move it to "lib" folder of your JMeter installation. See JMeter Classpath for more details on where should different .jars go.
   
3. Restart JMeter if it was running
4. That's it, you should be able to "validate" (whatever it means) any format supported by Tika. More information: How to Extract Data From Files With JMeter