i write this Article after many requests about “How to Integrate with Microsoft Excel Files" with read / write operations to manage Data transfer in Oracle ADF world.
Many Organizations contains many Integrations ways, and most of them still using such way to use Excel Files to Integrate between different projects.
in our case, we will handle only the Read Operation and we have to get help out of box !!, we have to cooperate with Apache project is named “Apache POI” , to integrate
and now, let me give a complete solution for our challenge
- First of all, try to understand the mechanism used in poi jars and how to use to take control of Data Cells.
- include poi jars (poi-3.9-20121203,poi-examples-3.9-20121203,poi-excelant-3.9-20121203,poi-ooxml-3.9-20121203,poi-ooxml-schemas-3.9-20121203,poi-scratchpad-3.9-20121203) in your ADF, Interface project.
- Build Back Bean Method to Make the operation of Data Transfer.
- Finally, Build a Method to Make Insertion Process.
No comments:
Post a Comment