i tried with absolute path also but it didnt work..actully i want to take excel file from user in jsp page using upload file option
Joined: Sep 21, 2011
Actually, I wasn't referring to either sort of path, both of which are about URLs. This problem is about file systems paths, where there's only one kind of relative path (relative to the current directory - a concept which doesn't make sense in web apps, and is somewhat unpredictable in its result if used anyway).
Joined: Jun 06, 2012
hey friends please help me..i m stuck in this problem from last two days..please help me
There is API provide by apache to read excel file .
You can use that one , name of the file is poi-3.5-FINAL-20090928.jar . I used it recently , even you will get program on google to read the excel and once you will get that excel row values , you can create statement and execute it so that it will be
stored in the database.
I recently used it , but mine was Java Class where in main method i am hardcoding xls file name from where it is reading data.
In case of JSP you can use FILE tag and form should have enctype="multipart/form-data" .