|
How do I read an Excel file uploaded through a Web browser to a Servlet |
|
|
Get Jakarata Commons-Fileupload
Create in input form like this:
<form name="frm" action="/servlet/MyServlet" method="post"
enctype="multipart/form-data">
<input type="file" name="fl_upload">
<input type="submit" value="Upload">
<input type="reset" value="cancel">
</form>
in your servlet, include code like this:
DiskFileUpload fu = new DiskFileUpload();
fu.setSizeMax(MAX_SIZE);
fu.setSizeThreshold(1024);
fu.setRepositoryPath(System.getProperty("java.io.tmpdir"));
List fileList = fu.parseRequest(request);
InputStream uploadedFileStream = null;
String uploadedFileName = null; // name of file on user's computer
for (Iterator i = fileList.iterator(); i.hasNext(); )
{
FileItem fi = (FileItem)i.next();
if (fi.isFormField())
{
String key = fi.getFieldName();
String val = fi.getString();
System.out.println("Form parameter " + key + "=" + val);
} else
{
if (fi.getSize() < 1)
{
throw new Exception("No file was uplaoded");
}
uploadedFileName = fi.getName();
uploadedFileStream = fi.getInputStream();
}
}
Workbook workbook = Workbook.getWorkbook(uploadedFileStream);
|
Related Tips
|
Page 1 of 0 ( 0 comments )
Other API Tips 
You can share your information about this topic using the form below!
Please do not post your questions with this form! Thanks.