CODEWITHSUNDEEP
oracle-adf
A_BOSS
A_BOSS

Reputation: 454

How to Import Data from Excel sheet to DB Table through Oracle ADF?

How to Import Data from Excel sheet to DB Table through Oracle ADF ? using Input file ?!

Upvotes: 0

Views: 4082

Answers (4)

A_BOSS
A_BOSS

Reputation: 454

Thanks for answers ,

I solved the issue by using Apache POI to parse excel sheet to java objects

Steps :

  1. use <af:inputFile/> component in jsf or jspx page.
  2. in managed bean get the file inputstream from inputFile component.
  3. parse this excel file using Apache POI.
  4. inserted them to DB using AM in adf.

Upvotes: 1

Dilini Chaturani
Dilini Chaturani

Reputation: 72

if you can Saved excel file as .CSV format. (Without excel functions) then you can upload file in to system using inputfile component

Upvotes: 0

Joe
Joe

Reputation: 3347

I would consider the use of Apache POI - which gives a java API to read MS Office VB Model. Then simply load the data into your VO(s) and commit.

Upvotes: 0

Patrick J Abare II
Patrick J Abare II

Reputation: 1129

To upload the file use standard implementation of:

<af:inputFile/>

For parsing the Excel file, there is no inherent java support, but I've used Apache POI in the past.

http://howtodoinjava.com/2013/06/19/readingwriting-excel-files-in-java-poi-tutorial/

Upvotes: 1

Related Questions