You will need to handle the import PDF file portion separately. That means once you have imported the excel files and you have all the PDF URL’s (to be imported) inside your application. You can use the mechanism of storing PDF files into Mendix FileDocument entities
Import the community commons module in your project. It contains a Java action that allows you to import file from URL: StoreURLToFileDocument - Retrieve a document from an URL using a HTTP GET request.
Please see following answers also to see how to import PDF file from url.
https://forum.mendix.com/link/questions/7225
I am trying to use the Java Action "StoreURLToFileDocument" in my microflow, but its asking me many parameters like "Filename". How to determine them ? Any sample example is there how can we implement this Java action in microflow to achieve the desired result ? Nothing is mentioned on Mendix store that how can we use this Java action