sagi

Hello

I am working on a project that is a web application. There is one part of the project I am not quite sure how to do, actually I do not even know how to get started.

We have excel files with data in it, and that data needs to be read in and stored into the database.

I am not sure how to get access to the excel file (the excel file name is not same everytime). I am not sure how to exactly read the excel file(standard format for all excel files) to extract the data and to finally store it into the database.

I know I am asking for a lot of help. However, if anyone has any idea on parts or all of the problem....I would be very grateful.

Any direction to even get started would be helpful. Thanks a bunch!!

sagi

java_roshan

Is excel the backend database of a frontend application? Is the frontend application a web application?

__________________
Visit: http://www.somaiya.edu

sagi

The front end is a web application, however the backend is a regular sql database.

The user uses the web application to upload an excel file and all that data in the excel file needs to be extracted and inserted into the database. I am not sure how to extract the data from the excel file.

Thank you for replying. If you have any ideas of where would be a good starting point, please let me know.

Thank you.

mackenga

I'm not sure of the details of the XLS format, but I do know that Excel can save in other formats. I believe it can handle CSV, which might be worth a look as it's extremely easy to parse. You'd have to get users to export to something other than XLS to do this, but it might well prove to be worth it.