How can I upload Excel sheet data to oracle databse using Java

Hi All,

I need to upload the data, which is in excel sheet, to Oracle Database using Java.

Is there a way to achieve it using Aspose?

I have the data in Excel columnwise as flexi ti insert to database.

How can I do that....

Can you provide the the relavent code in Java for that one.

Thanks & Regards

Madhu

Hi,

Well, I think you may fill an object array based on the worksheet data using Cells.exportArray() method and then implement your own code using jdk's database handling APIs to save the array data to oracle database.

For reference, please check: http://www.aspose.com/documentation/file-format-components/aspose.cells-for-.net-and-java/exporting-data-from-worksheets.html

Thank you.