diff options
| author | Avik Sengupta <avik@apache.org> | 2003-01-26 20:43:02 +0000 |
|---|---|---|
| committer | Avik Sengupta <avik@apache.org> | 2003-01-26 20:43:02 +0000 |
| commit | 36cd4e8fb51083ab0175411ed7c7a87be8a9bae9 (patch) | |
| tree | fe341add199aa009e109c7ffbd3a407de4f66ac8 /src/examples/jsp/HSSFExample.jsp | |
| parent | 40d9a075970c876f385d79ce2aafc8d1177c5326 (diff) | |
| download | poi-36cd4e8fb51083ab0175411ed7c7a87be8a9bae9.tar.gz poi-36cd4e8fb51083ab0175411ed7c7a87be8a9bae9.zip | |
Example JSP page using POI/HSSF, submitted by brian westrich
git-svn-id: https://svn.apache.org/repos/asf/jakarta/poi/trunk@352989 13f79535-47bb-0310-9956-ffa450edef68
Diffstat (limited to 'src/examples/jsp/HSSFExample.jsp')
| -rw-r--r-- | src/examples/jsp/HSSFExample.jsp | 100 |
1 files changed, 100 insertions, 0 deletions
diff --git a/src/examples/jsp/HSSFExample.jsp b/src/examples/jsp/HSSFExample.jsp new file mode 100644 index 0000000000..853587b19d --- /dev/null +++ b/src/examples/jsp/HSSFExample.jsp @@ -0,0 +1,100 @@ +<%@page contentType="text/html" +import="java.io.*,org.apache.poi.poifs.filesystem.POIFSFileSystem,org.apache.poi +.hssf.record.*,org.apache.poi.hssf.model.*,org.apache.poi.hssf.usermodel.*,org.a +pache.poi.hssf.util.*" %> +<html> +<head><title>Read Excel file </title> +</head> +<body> +An example of using Jakarta POI's HSSF package to read an excel spreadsheet: + + +<form name="form1" method="get" action=""> +Select an Excel file to read. + <input type="file" name="xls_filename" onChange="form1.submit()"> +</form> + +<% + String filename = request.getParameter("xls_filename"); + if (filename != null && !filename.equals("")) { +%> + <br>You chose the file <%= filename %>. + <br><br>It's contents are: +<% + try + { + + // create a poi workbook from the excel spreadsheet file + POIFSFileSystem fs = + new POIFSFileSystem(new FileInputStream(filename)); + HSSFWorkbook wb = new HSSFWorkbook(fs); + + for (int k = 0; k < wb.getNumberOfSheets(); k++) + { +%> + <br><br>Sheet <%= k %> <br> +<% + + HSSFSheet sheet = wb.getSheetAt(k); + int rows = sheet.getPhysicalNumberOfRows(); + + for (int r = 0; r < rows; r++) + { + HSSFRow row = sheet.getRow(r); + if (row != null) { + int cells = row.getPhysicalNumberOfCells(); +%> + <br><b>ROW <%= +row.getRowNum() %> </b> +<% + for (short c = 0; c < cells; c++) + { + HSSFCell cell = row.getCell(c); + if (cell != null) { + String value = null; + + switch (cell.getCellType()) + { + + case HSSFCell.CELL_TYPE_FORMULA : + value = "FORMULA "; + break; + + case HSSFCell.CELL_TYPE_NUMERIC : + value = "NUMERIC value=" + + cell.getNumericCellValue +(); + break; + + case HSSFCell.CELL_TYPE_STRING : + value = "STRING value=" + + cell.getStringCellValue(); + break; + + default : + } +%> + <%= "CELL col=" + + + cell.getCellNum() + + " VALUE=" + value %> +<% + } + } + } + } + } + } + catch (Exception e) + { +%> + Error occurred: <%= e.getMessage() %> +<% + e.printStackTrace(); + } + + } +%> +</body> +</html> + |