Error:execution Failed For Task ':app:transformclasseswithdexfordebug' After Adding Poi-ooxml:3.7 Library

I want to read a XLSX file, so I am using org.apache.poi:poi-ooxml:3.7 Now I have done everything, no errors so far, but when I am running the application, Android Studio is giving

Solution 1:

I resolved the problem by Adding two JARs externally.

1. poi-3.9.jar Download
2. poi-00xml-3.9.jar Download

PS: Please add the JARs externally, adding them via maven generates a confusing error.