Oracle file adapter can read and write CSV files, if you export excel files into csv format you could be able to read data from file and will be able to write into database.
If you need to read .xls files directly from BPEL than you need to write custom Java code. You can use Apache POI to read and write excel files from Java code.
My requirement is to read one excel file from FTP Location and insert the values into datbase is it possible through bpel or do we need tro write some jave ode.if can any one tell em how to achieve this.
I had a similar case in which I used a separate Java Webservice that accepts a Excel file. In my case it returned an XML of the data but you might as well write it straight to a database.
Whether this is the best way to approach your problem I don't know but if written generic it could come in handy to have it as a separate service.
Parsing excel using BPEL without using any custom Java code isn't possible as far as I know.
Thansk for your solution can you share the Webservice with or me can you share some light on the same so that it will be easy for me as this is urget for me we are struck with this and the client wats this urgently.
You can mail me at nagaraju.daramukkala@wipro.com.
