File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes Struts and the fly likes Uploading and reading excel sheet Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Frameworks » Struts
Bookmark "Uploading and reading excel sheet " Watch "Uploading and reading excel sheet " New topic

Uploading and reading excel sheet

Anil Prasad

Joined: Feb 22, 2006
Posts: 14
I have a problem,I want to upload an excel file .When a user click
submitted button .The uploaded file read in actionclass and record
is submitted to database through ejb.
I am not able to do the same using DiskFile or FormFile.Please
help me.
Merrill Higginson
Ranch Hand

Joined: Feb 15, 2005
Posts: 4864
I'd recommend using the open source project Jakarta POI for reading an Excel file. You can use org.apache.struts.upload.FormFile to upload the file, then use FormFile's getInputStream() method to pass it to the POI API.

Consultant, Sima Solutions
I agree. Here's the link:
subject: Uploading and reading excel sheet
It's not a secret anymore!