wood burning stoves 2.0*
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
Author

Uploading and reading excel sheet

Anil Prasad
Greenhorn

Joined: Feb 22, 2006
Posts: 14
Hi,
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.
thanks
anil
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.


Merrill
Consultant, Sima Solutions
 
It is sorta covered in the JavaRanch Style Guide.
 
subject: Uploading and reading excel sheet