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

Uploading xls files with JSF

shree lk

Joined: Mar 16, 2011
Posts: 14

Hello All...

I have problem with JSF file uploading.

I have uploaded excel file with ' inputFileUpload' tag of JSF and given value using BEANS as #{myBeans.myFile} to the tag. Now in backbean java file I can't able to get that file so that I can process or parse excel file. I declared it as follows
String inputFile= " #{myBeans.myFile}". But its not working. I don't know whether its right??. I also given getters & setters for 'inputFile' . But when i give direct path of the file like- String inputFile="c:/upload/test.xls" I am able to process that excel file file successfully. I have used POI to parse excel file.

Also I am able to display contents of xls from JSf form in the browser. Although I am getting it on the tomact console. I used following code to parse and display xls file contents.

Can anybody suggest solution to this. Also how to display xls file contents to browser with JSF form.

public String fileSubmit() throws IOException

inputFile= "c:/upload/test.xls";


List cellDataList = new ArrayList();

* Create a new instance for FileInputStream class
FileInputStream fileInputStream = new FileInputStream(inputFile);

* Create a new instance for POIFSFileSystem class

POIFSFileSystem fsFileSystem = new POIFSFileSystem(fileInputStream);

* Create a new instance for HSSFWorkBook Class

HSSFWorkbook workBook = new HSSFWorkbook(fsFileSystem);
HSSFSheet hssfSheet = workBook.getSheetAt(0);

* Iterate the rows and cells of the spreadsheet to get all the data.

Iterator rowIterator = hssfSheet.rowIterator();

while (rowIterator.hasNext())
HSSFRow hssfRow = (HSSFRow);
Iterator iterator = hssfRow.cellIterator();
List cellTempList = new ArrayList();

while (iterator.hasNext())
HSSFCell hssfCell = (HSSFCell);
catch (Exception e)

// List retList=printToConsole(cellDataList);

return "upLoaded";

private List printToConsole(List cellDataList)
for (int i = 0; i < cellDataList.size(); i++)
List cellTempList = (List) cellDataList.get(i);
for (int j = 0; j < cellTempList.size(); j++)
HSSFCell hssfCell = (HSSFCell) cellTempList.get(j);

String stringCellValue = hssfCell.toString();
System.out.print(stringCellValue + "\t");



return cellDataList;


I agree. Here's the link:
subject: Uploading xls files with JSF
It's not a secret anymore!