diff options
| author | Andreas Beeker <kiwiwings@apache.org> | 2021-04-07 21:40:33 +0000 |
|---|---|---|
| committer | Andreas Beeker <kiwiwings@apache.org> | 2021-04-07 21:40:33 +0000 |
| commit | b6aee1ef6d3e92a28ffd4b5c03e677b63b43747f (patch) | |
| tree | ad9c7b312976c4ed113a7f3b5b4757bfe1b3eee6 /examples/src/main/jsp | |
| parent | 6458acb931a0cc17b2d5ed205a1b3fbbb78b9193 (diff) | |
| download | poi-b6aee1ef6d3e92a28ffd4b5c03e677b63b43747f.tar.gz poi-b6aee1ef6d3e92a28ffd4b5c03e677b63b43747f.zip | |
65206 - Migrate ant / maven to gradle build
compile / jar / test of mrJars
don't include ants build.xml anymore
rename directories to match project and maven artifact names
refactor artifacts - so each project has one artifact
replace static references in hssf/dev tests with junit5 constructs, which had problems in parallel tests
increase gradle heap to 4gb because of OOM - maybe less would also work
git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1888488 13f79535-47bb-0310-9956-ffa450edef68
Diffstat (limited to 'examples/src/main/jsp')
| -rw-r--r-- | examples/src/main/jsp/HSSFExample.jsp | 116 |
1 files changed, 0 insertions, 116 deletions
diff --git a/examples/src/main/jsp/HSSFExample.jsp b/examples/src/main/jsp/HSSFExample.jsp deleted file mode 100644 index 4dd0a4f4e5..0000000000 --- a/examples/src/main/jsp/HSSFExample.jsp +++ /dev/null @@ -1,116 +0,0 @@ -<!-- - Licensed to the Apache Software Foundation (ASF) under one or more - contributor license agreements. See the NOTICE file distributed with - this work for additional information regarding copyright ownership. - The ASF licenses this file to You under the Apache License, Version 2.0 - (the "License"); you may not use this file except in compliance with - the License. You may obtain a copy of the License at - - http://www.apache.org/licenses/LICENSE-2.0 - - Unless required by applicable law or agreed to in writing, software - distributed under the License is distributed on an "AS IS" BASIS, - WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. - See the License for the specific language governing permissions and - limitations under the License. ---> -<%@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.isEmpty()) { -%> - <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.getColumnIndex() - + " VALUE=" + value %> -<% - } - } - } - } - } - } - catch (Exception e) - { -%> - Error occurred: <%= e.getMessage() %> -<% - e.printStackTrace(); - } - - } -%> -</body> -</html> - |